October 14, 2013 at 1:28 pm
Hi - SSRS NewBee here.
I want to show one value in a table driven prompt, but pass an associated value to my report query.
E.g. I'd like my prompt to show "Dog", "Cat", etc. But my underlying query needs "Canis Familiaris", "Felis Catus", etc.
I created a data set that returns both values, say "CommonName" and "BinomialName".
I created two parameters, "@CommonName", which is visible and does a "Get Values from query" to pull the from my dataset. The second parameter, "@BinomialName" I made hidden. It pulls from the same data set.
The report ran, but it doesn't pull the correct data for the prompt value chosen.
So, I reworked this using a "cascading parameter" approach (I think), and made a second data set which returns the BinomialName based on the CommonName parameter returned from the first data set. The second data set is behind the hidden parameter that is used by the dataset that drives the report.
This seems to work, but am I missing a better solution?
Thanks.
October 14, 2013 at 4:17 pm
Doh!
I was missing the concept of "Value Field" vs "Label Field" on the "Available Values" tab of the parameter. Fixing that, gave me exactly what I needed. (Label is CommonName. Value is BinomialName.)
Sorry for cluttering the database.
Steve
October 15, 2013 at 3:39 am
Actually, don't worry about it. If you had this problem there are probably more out there with the same problem. If they find this thread they will find an answer.
October 15, 2013 at 2:39 pm
Lynn Pettis (10/15/2013)
Actually, don't worry about it. If you had this problem there are probably more out there with the same problem. If they find this thread they will find an answer.
+1, this is definitely useful for someone who may be struggling.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply