Hi !!!
I'm working on a report to show data from 3 queries : Firm, employee and notes.
In a firm, there are none, one or more employees, and the same for notes. So I put data from the firm in the main report, and others in two sub reports.
My problems are :
- how can I filter data in the subreport from notes(e.g. how can I show only notes entered during the last week)
- how can I hide (or suppress) a subreport if it is empty ?
Thank you in advance for your help !!!
I'm working on a report to show data from 3 queries : Firm, employee and notes.
In a firm, there are none, one or more employees, and the same for notes. So I put data from the firm in the main report, and others in two sub reports.
My problems are :
- how can I filter data in the subreport from notes(e.g. how can I show only notes entered during the last week)
- how can I hide (or suppress) a subreport if it is empty ?
Thank you in advance for your help !!!
