sub report date parameters

[jvolden]

Is there a way to make a sub report use the same date values used in the report it is embedded in? When I run the report now it is prompting me for two sets of dates, onece for the report and once for the subreport. I would like it to only prompt me once.

Than you

 

[Madawc]

Yes. Choose 'Subreport Links' under 'Edit'. The value from the main report is then available to you.

One common problem with linked subreports is that it adds the link as a record-selection in the subreport, additional to any test you already have. Check and see if the link is what you want. If you don't like the link you can remove it and still have the field.

Madawc Williams (East Anglia, UK)

 

[lbass]

The way I would do this is to create the date parameters in the subreport, add them to the subreport record selection formula as you would in the main report, and then when you link the subreport to the main report, choose the main report parameter to move to the right, and then in the bottom left corner, choose the date parameter {?date} from the dropdown list (NOT {?pm-?date}.

-LB