I have a report with many fields, a few fields display salary/earning information. Is there any way I can hide this information on a select few reports (for salaried employees indicated by a particular field in the report)?
The salary information is confidential and cannot go out to the field, however the other 90% of the report has benefit information which needs to go out.
Would love some help with this one!
Thanks
Ok, I figured out part one.. I just copied and renamed the report, then deleted those fields with salary info on the second report.
However, when I try to sort (by going into query the report is based on and sorting it - successfully) it is not reflected in the report. Anyone know why?
Thanks again!
Ok, figured out part two, went into design view of report, and reset the sorting sequence. Learned this from the archives. THANKS.
Love this forum!
The salary information is confidential and cannot go out to the field, however the other 90% of the report has benefit information which needs to go out.
Would love some help with this one!
Thanks
Ok, I figured out part one.. I just copied and renamed the report, then deleted those fields with salary info on the second report.
However, when I try to sort (by going into query the report is based on and sorting it - successfully) it is not reflected in the report. Anyone know why?
Thanks again!
Ok, figured out part two, went into design view of report, and reset the sorting sequence. Learned this from the archives. THANKS.
Love this forum!
Last edited: