Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
HUHU
Starting Member
4 Posts |
 Posted - 2013-04-29 : 09:16:42
|
| Hi need to populate a multi-valued parameter with a comma separated string value like (1,2,3) in SSRS … i tried with parameter properties by setting values in "Default Values" tab.. am I missing something.. please help .. thanks in advance |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-04-29 : 09:46:31
|
| You also need to select the "Allow multiple values" checkbox in the general tab of the Report Parameter Properties. |
 |
|
|
HUHU
Starting Member
4 Posts |
Posted - 2013-04-29 : 10:01:27
|
| Hi James, thanks for reply i already set the checkbox to "Allow multiple values" and while fetching records i am able to send the selected items seamlessly... but whenever i want to bind again with comma separated string values in "Default values" tab its not working ... :( |
|
|
|
HUHU
Starting Member
4 Posts |
Posted - 2013-04-29 : 10:06:33
|
i tried an expression too in "Default Value" tab
=Split(First(Fields!ColumnValue.Value, "dsImageDescription"),",")
where ColumnValue is the comma seperated string coming from a stored procedure [dataset name : dsImageDescription]
As the value selected renders as an array i just gave an wild try. but it didnt work out for me too .. :( |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-04-29 : 10:20:00
|
When you call the stored procedure, the parameter values are sent as comma-separated values. However, SSRS does not provide a feature for output parameters. So you cannot retrieve those parameters (be they input only or input/output parameters) back into your report. So your options that I can think of are:
1. Send the comma-separated values back to the report as a column in the record set returned (or create another dataset just for this purpose)
2. Concatenate the parameter values in the report yourself with commas separating them. |
|
|
|
HUHU
Starting Member
4 Posts |
Posted - 2013-04-29 : 10:36:28
|
I just created a function where i send the comma separated string and get a ListItem column with all values row wise. What i am doing now
1. Get the value from dataset and assign it into a text parameter.
2. Send the text field value in newly created function.
3. Point the function's outcome to "Default Values" tab
I am getting an exception saying
An error occur during local report processing.
The definition of the report 'NewReport' is invalid.
A value expression is used for the report Parameter 'ColumnName' refers to a field.Fields can not be used in report parameter expression. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-30 : 04:52:48
|
quote:
Originally posted by HUHU
Hi James, thanks for reply i already set the checkbox to "Allow multiple values" and while fetching records i am able to send the selected items seamlessly... but whenever i want to bind again with comma separated string values in "Default values" tab its not working ... :(
why not generated comma separated list from database itself in query and bring? then you can use this query in a dataset and assign it to your ssrs parameter
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
|
|
|
|
|
|
|
Need to populate Multi valued parameter in SSRS