M
MarieM via AccessMonster.com
My database has a custom report application where the user can build custom
reports based on which fields the user wants to display on a report, such as
Names, Title, DOB, etc. The Main report is based on a query which selects the
appropriate employees. The Detail section of the Main report is made up of
null sub reports which are populated with the appropriate prebuilt subreports
depending on which fields have been selected.
For example, if the user builds a custom report to display the Name and Title,
the report displays the Name and Title for the appropriate employees. The
custom report concept is working correctly.
I have now added a grouping level to the Main report to separate the
employees into Officers and Directors. The report is able to separate the
employees correctly. However, some of the same employees are both Officers
and Directors, so they are correctly appearing in both grouping sections of
the report. However, the employees’ two titles are repeated in both sections.
The report should only show the Officer title in the Officer section and the
Director title in the Director section.
Does anyone have any ideas on how to set up the report to display the
information correctly?
Thank you in advance for any help you can provide!
reports based on which fields the user wants to display on a report, such as
Names, Title, DOB, etc. The Main report is based on a query which selects the
appropriate employees. The Detail section of the Main report is made up of
null sub reports which are populated with the appropriate prebuilt subreports
depending on which fields have been selected.
For example, if the user builds a custom report to display the Name and Title,
the report displays the Name and Title for the appropriate employees. The
custom report concept is working correctly.
I have now added a grouping level to the Main report to separate the
employees into Officers and Directors. The report is able to separate the
employees correctly. However, some of the same employees are both Officers
and Directors, so they are correctly appearing in both grouping sections of
the report. However, the employees’ two titles are repeated in both sections.
The report should only show the Officer title in the Officer section and the
Director title in the Director section.
Does anyone have any ideas on how to set up the report to display the
information correctly?
Thank you in advance for any help you can provide!