PDA

Click to See Complete Forum and Search --> : Report/Sub-Report Parameter Linking


wookie224
Mar 18th, 2004, 03:32 PM
Greetings,
I have one report that gets data from a stored procedure, I have a sub-report that is ran with its own stored procedured.

They are both grouped together.

Heres what I want. I want [Report 1].[Field 1] to be passed to the parameter of the second report so each time it changes the group, the subreport is updated.

Any ideas?

ARPRINCE
Mar 19th, 2004, 09:32 AM
This is how I do it for CR9.

I create my main report using the SPROC. After all is well and done, I insert a SUBREPORT using the "Insert Subreport" icon on my toolbar. Proceed to create a subreport with reference to your other SPROC. When done, click on the "LINK" tab to link your MAIN REPORT to your SUB REPORT using a field that is common to both.

Hope this helps.