SFozzy
November 21st, 2007, 05:17 AM
I currently have a main report and a subreport - both use the same date range, but I have to enter this for each report. How can I get both reports to use the same date range (i.e. user only enters the one date range?)
Thanks...
Lugh
November 21st, 2007, 07:58 AM
I assume that you are selecting your date range with parameters. In the Subreport Links dialog box, select the parameter fields as the link. You will see a prompt at the bottom, to link the parameter fields of the subreport to the parameters of the main report. This will mean that your user is only prompted once, and the value is passed to the subreport.
SFozzy
November 21st, 2007, 11:24 AM
Fantastic - thank you forthat pointer, got it working :-)