This is a migrated thread and some comments may be shown as answers.

Multiselect parameters

6 Answers 199 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
harlowhair
Top achievements
Rank 1
harlowhair asked on 08 Oct 2010, 04:33 PM
Hi,

I am slightly confused with multi select parameters - can these be automatically passed through to a SqlDataSource (referencing a stored procedure) as a comma delimited list, or do I have to manually create this string in the NeedDataSource event?

Thanks

6 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 08 Oct 2010, 04:43 PM
Hello harlowhair,

Such scenario would work automatically since the latest Q2 SP1 2010 release, namely the following item: Fixed: SqlDataSource cannot map database parameter to multivalue report parameter.

Sincerely yours,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
harlowhair
Top achievements
Rank 1
answered on 08 Oct 2010, 04:46 PM
Hi Steve,

The version I have is 4.1.10.921 which looks to be the latest however if I map the multiselect parameter to a stored procedure parameter it is passed through as null.  Is there a specific way this needs to be setup?

Thanks,
Rob
0
Steve
Telerik team
answered on 12 Oct 2010, 04:26 PM
Hi Rob,

Yes, the version you're using is the latest. There must be some other problem unrelated to the new functionality if the parameter is returning null. You can use the FormatArray function from the ProductLineSales demo report and show the value of the report parameter in an expression to see its value. If necessary you can use the built-in IsNull function to check for such cases.

All the best,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
harlowhair
Top achievements
Rank 1
answered on 13 Oct 2010, 11:05 AM
That worked - I created FormatArray in the code behind of my report and then used it in an expression to pass the parameter to the datasource
0
Rakesh
Top achievements
Rank 1
answered on 22 Oct 2010, 09:47 PM
i am not able to get the result if i use multi select = true in telerik reporting services
0
Rakesh
Top achievements
Rank 1
answered on 22 Oct 2010, 10:38 PM
Hi harlowhair
can you send a sample code how you did that
Tags
General Discussions
Asked by
harlowhair
Top achievements
Rank 1
Answers by
Steve
Telerik team
harlowhair
Top achievements
Rank 1
Rakesh
Top achievements
Rank 1
Share this question
or