The main report is filled by a query with a parameter of (Between [T1] and [T2])
The detail section is hidden as I don't need this information showing but use it to generate the required numbers.
The subreport is located in the footer and is filled by a query based off the main report query. The detail section takes the numbers generated in the main report details, looks for duplicates and lists those. The footer just counts the number of records that has duplicates which is the reason for this query/subreport
The queries and reports return the information I want but always asks twice for the parameter values (between T1-T2) I believe this is due to the subreport query being based off the main report query but how do I make it so it only asks for the parameters once
or even better, is there a way to combine this into one query / report.
I have included a graphic with the queries and reports setup. View attachment 53449
The detail section is hidden as I don't need this information showing but use it to generate the required numbers.
The subreport is located in the footer and is filled by a query based off the main report query. The detail section takes the numbers generated in the main report details, looks for duplicates and lists those. The footer just counts the number of records that has duplicates which is the reason for this query/subreport
The queries and reports return the information I want but always asks twice for the parameter values (between T1-T2) I believe this is due to the subreport query being based off the main report query but how do I make it so it only asks for the parameters once
or even better, is there a way to combine this into one query / report.
I have included a graphic with the queries and reports setup. View attachment 53449
