Passing parameter to subreport

[lisa13ep]

I have main report with subreport in it. Both have the same parameter prompt to enter date range. How do I pass it from main report into subreport instead of entering in twice? I was looking at the solutions online that say to link through the prameter field and then remove the parameter from the subreport, which I did, but it still prompts to enter date twice, plus (because I tried it several different ways) sometimes it does not pull any info from subreport at all. Please help

 

[lbass]

I'm not sure you can actually link on a range parameter. Try replacing each with start and end parameters. Then in the subreport linking screen, in the lower left corner, use the dropdown to select the actual parameter, not the default {?pm-?startdate}, e.g.

In the subreport go into the record selection formula and change it to reflect:

{table.date} >= {?Start Date} and
{table.date} < {?End Date}+1

-LB

 

[Charliy]

You can keep the range parameter in the main report, but you'll need to create formulas for separate Start and End dates and pass them to the subreport.

/@bdate
beforereadingrecords;
minimum({?DateRange})

/@edate
beforereadingrecords;
maximum({?DateRange})

 

[lisa13ep]

After I create them how do I pass them over? And mainly, how would I remove the date range parameter from subreport so it does not show up? Thank you.

 

[Charliy]

You pass them to the subreport using the "Change subreport links" dialog.

Right click on the subreport and you'll see it.