Hello. I am trying to create a report with a sub report that groups information by date and is linked by orginator. The main report lists all requests, the orginator, when the request was made, and when the request was completed.
What I woud like to have is report that looks like such:
Date Made Jan
Date Completed Jan
Date Made Feb
Date Completed Feb
Where Date Made Jan, Feb, etc are on the main form and the info is grouped by the date footer. In the date footer I have the Date Completed sub report.
Currently the report displays:
Date Made Jan
Date Completed Jan
Date Completed Feb
Date Completeed March
.........
Date Made Feb
Is there a way to group the sub report by month with the main report? I have never used sub reports before so I'm uncertain what to do.