Right so as the title says...
I have a parameter (actually two), that is populated by running a sproc.
That sproc expects 3 parameters to run.
I have a report where those parameters are used. But i need to parse them to another report, in order to populate the parameters list... so the list can populate :S hahaha.
So:
Report A; uses parameters A,B,C
This Report generates 4 columns 1,2,3,4
There is a link on Report A which directs you to Report B.
Report B uses two parameters D,E
Parameters D,E are actually column 4 of Report A.
So i either have to run the sproc for Report A, parsing in A,B,C and make the value of D = column 4
Or I need to somehow parse 4 as a recordset straight to Report B parameters, D and E.
I need a parameter for my parameter!
The only solution I've thought of is creating a table on the fly, populating with column 4's data, then populating D and E with the data from the table. Then dropping the table.
But that is just MESSY.
What you think?