April 16, 2008 at 9:47 am
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?
April 18, 2008 at 1:36 am
Parameters can't be forward dependant...
I created a very basic version of my problem... and i got the error mesasge.
That answered my question.
My solution...
Creating a table then dropping it is very messy.
So I've decided the user can navigate with one value...
The second value i wanted will just have to entered manually.
e.g.
report a - param 1,2,3 - created columns a,b,c
report b param b,c, - from report a.
My solution is click on b... that'll be parsed to report b, and the user will just need to enter parameter c manually...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply