Click here to Skip to main content
11,799,282 members (75,801 online)
Rate this: bad
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
0 OriginalGriff 473
1 CPallini 410
2 Richard MacCutchan 319
3 phil.o 244
4 Kornfeld Eliyahu Peter 205
0 OriginalGriff 2,475
1 Maciej Los 1,860
2 KrunalRohit 1,496
3 CPallini 1,465
4 Richard MacCutchan 1,149

Advertise | Privacy | Mobile
Web04 | 2.8.151002.1 | Last Updated 12 Mar 2013
Copyright © CodeProject, 1999-2015
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