Parsing a parameter drop down... a parameter in order to populate...

• David-368560

  SSC-Addicted

  Points: 438

  More actions

  April 16, 2008 at 9:47 am

  #189159

  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?

• David-368560

  SSC-Addicted

  Points: 438

  More actions

  April 18, 2008 at 1:36 am

  #804127

  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...