I have a reports form. On this form, the user chooses the report that they want, by the first option group. Then they choose a date option on the second option group. They can choose today, to enter a date, a date range, or all dates.
Then the "get report" command button opens the report, and uses the date option to filter the chosen report. If the user chooses today, the filter is for date(), if they choose to enter a date, there is a date control on the form that become visible and required to be filled in. Date reange shows 2 date controls, etc.
This works for all of my reports, except my latest. I have a statistics report, which show counts of what has been happening with this data. One of the activities in this data has sub activities, and therefore has a subreport. When I run the cumulative, or all dates, it runs great. If I choose any other date option, though, I do not get a correct filter on the subreport. It seems to pull just one date (indiscriminately).
I have tried adding the date field to the subreports query, tried making it a link between the reports, tried making it a criteria in the subquery, tried different groupings. Nothing seems to do it.
Can someone please help me figure out how to make the date filter for the main report, filter for the subreport?
I think one of the issues may be that while I use the date to filter, the report is just grouped to count, it does not sort or group on date.
Thanks!
Then the "get report" command button opens the report, and uses the date option to filter the chosen report. If the user chooses today, the filter is for date(), if they choose to enter a date, there is a date control on the form that become visible and required to be filled in. Date reange shows 2 date controls, etc.
This works for all of my reports, except my latest. I have a statistics report, which show counts of what has been happening with this data. One of the activities in this data has sub activities, and therefore has a subreport. When I run the cumulative, or all dates, it runs great. If I choose any other date option, though, I do not get a correct filter on the subreport. It seems to pull just one date (indiscriminately).
I have tried adding the date field to the subreports query, tried making it a link between the reports, tried making it a criteria in the subquery, tried different groupings. Nothing seems to do it.
Can someone please help me figure out how to make the date filter for the main report, filter for the subreport?
I think one of the issues may be that while I use the date to filter, the report is just grouped to count, it does not sort or group on date.
Thanks!
