Click here to Skip to main content
13,088,101 members (68,396 online)
Rate this:
Please Sign up or sign in to vote.
I am trying to develop client side report in visual studio 2012. My report is working fine with different selection criteria variables. I am getting error while multi selected list values in filters.
In query in need id as SkillTargetID IN (@AgentList). when I pass single value as 5000 its working fine and showing records. But when I pass multiple values as 5000,5001,5002 etc then got error. [An error has orrcurred during report processing. cannot crate a connection to data source 'MyDataSource'. Conversion failed when converting to nvarchar value '5000,5001,5002' to data type int.]
I had tried with
Any suggestion to pass multiple values to report viewer. I am trying this on visual studio 2012, Sql server 2008 r2 and .net framework 4.5.
Posted 11-Mar-13 21:12pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Sill I couldn't find any proper solution but I solve my problem by changing DataSource SelectCommand query. On report refresh button_click I just change MyDataSource.SelectCommand query as
string AgentIds = "5000,5001,5002";
        MyDataSource.SelectComamnd = "Select * from Agent where AgentId IN ('" + AgentIds + "')";
and it works. If anyone find a batter solution to add multiple values to DataSource variable then please update me.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.170813.1 | Last Updated 12 Mar 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100