Printable View
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?
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.