January 1, 2012 at 9:23 am
hi
can any one help how to achieve the below handing at report level.
how to find the values not in database table which are entered in a parameter at ssrs report level.
Scenario: user can enter values like 101,102,108 in a parameter with comma separated
-------
data in the table
id name
101 zzz
102 asd
103 ccc
out put: a text box containing value 108 (as this is not in the table)
---------
January 9, 2012 at 2:25 am
It is not clear as to what exactly you are trying to do...
However i suppose it is similar to this:
You want the user to be able to enter different values & depending on this you want to display these in the report!!!
You can create a report parameter and set values for it (select parameter --> parameter properties--> available vales --> specify values ( you will have to manually put all the values the user could enter) OR Get values from query (You will have to define a query to get values from a populated table)...
Now drag the parameter on the report area & this would display the value the parameter holds at runtime on the report...
Hope this helps...
However if you want the user to select a comma separated list then there is a different way of doing this through multi-value parameters & Join , split functions...
Do let me know..if that is the case..
January 9, 2012 at 2:19 pm
How are you using the parameter in the query? Are you just using an IN (Parameters!paramter_name.Value) or are you splitting the delimited list into a table and doing a join?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply