Subreport select based on main report select 1

[DavidSherring]

I have a main report with data filtered by select. I would like exactly the same select on my sub report. But I want my sub report to have it's selects automatically mirroring the main report selects.

Do I do this with shared variables?

Anyone got an example anywhere?

As per usual, I'm eternally grateful for the help I'm given on this site, I tend to search the help files for ages before giving up in frustration.

David

 

[lbass]

Just copy the select from the main report into the select in the sub. If you are using parameters, create the same parameters within the sub, and then link the sub to the main report on the parameters, by using the dropdown in the lower left corner to select the corresponding subreport parameters.

PS. You are in the wrong forum. Questions like this belong in forum149 or forum767.

-LB

 

[DavidSherring]

Thanks Ibass. But I tried this and got two issues. Firstly, I know I can copy the selects, but what I really want is for if someone changes the selects in the main report, they filter down into the sub report (I have some date selects based on paramters). This is my real problem, how do I filter down those parameters without asking for them twice?

 

[lbass]

If you have set up the same parameters in both the main and subreports and used them in the record selection formulas of each, then all you need to do to get one prompt is to link the parameters to each other. Use the dropdown in the lower left of the subreport linking screen to select the {?parm} instead of the default {?pm-?parm}. You will get only one prompt.

-LB

 

[DavidSherring]

I have just done this, and it has worked a dream. Many thanks, I really did not think this was conventional functionality.

David