Seperate Stored Procedures, Same Params (Subreports)

[dBjason]

CR 9

Hello,

I have a report & subreport which display data from two very different stored procedures (displays two very different recordsets). It works OK, but has one hitch.

Both stored procedures have the same, identical parameters (date, group name, and type). So when the user tries to run the rpt file, s/he has to enter each variable twice (once for the main report, and once again for the subreport).

Is there some way I can set up the subreport to feed off the main report's parameters so the user only has to type them in once?

Thanks in advance,
Jason

 

[dBjason]

Nevermind. Found the subreport link in the edit menu..

 

[vidru]

You can link the subreport's parameters to the main report's parameters:

Right click on the Subreport > Change Subreport Links > Pick one of your subreport parameters in the 'Subreport parameter field to use' dropdown (bottom left of the window) > From the 'Available Fields' listbox, double click on the matching main report parameter - this will add it to the 'Field(s) to link to' list.

Repeat the above for any other parameters, and when the main rpeort is run, it should only prompt once for the parameters.

-dave

 

[vidru]

I was a day late and a dollar short then, eh?

-dave