Pass Date Parameters to Sub Reports

[BradW]

Hi, thanks for all help!

I have a main report and several sub reports. I have set the reports up off the same table, and am using sub reports because I need to calculate different statistical totals off of the same data for the same time period. I have created a date range parameter to select the time period for the report. If I select a single date, then the report runs fine and all is well. However if I select a range then the sub reports do not find the entire range, just the starting date in that range. I need to be able to pass the selection parameter to the sub reports but can't find a work around that will do this.

Thanks again for all your help.

 

[synapsevampire]

Check the Report->Edit Selection Formula-Record in the subreports, it's probably wrong.

I'd guess that the main report parameter is pointing to a single field in the subreport, so it's just using the minimum of the date parameter range.

You can edit this in the subreports so that it contains something like:

{table.field} >= minimum({?Pm-MainParm})
and
{table.field} <= maximum({?Pm-MainParm})

-k