I've got a report where I'm pulling all employees in from a field UserFeatures.EmpName. This field shows every employee that's setup in the company. I'm passing this field to numerous subreports. I need to hide all employees unless they have data in any of the subreports. For example, I have 4 subreports...one for sales, one for credits, one for cash paid outs and one for deposits taken in. If any of these subreports return data for an employee, I need the employee to show on the main report. However, if none of the subreports return data for an employee, I need to hide that employee on the main report.
Hope this makes sense...it did in my head ;).
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.