Click here to Skip to main content
Rate this: bad
good
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
 
5000,5001,5002
 
'5000','5001','5002'
 
(5000,5001,5002)
 
('5000'),('5001'),('5002')
 
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 22:12pm

1 solution

Rate this: bad
good
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 + "')";
        ReportViewer1.LocalReport.Refresh();
and it works. If anyone find a batter solution to add multiple values to DataSource variable then please update me.
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 406
1 /\jmot 180
2 Suraj Sahoo | Coding Passion 170
3 Afzaal Ahmad Zeeshan 159
4 BillWoodruff 154
0 OriginalGriff 8,344
1 Sergey Alexandrovich Kryukov 7,407
2 DamithSL 5,634
3 Maciej Los 5,024
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web03 | 2.8.1411023.1 | Last Updated 12 Mar 2013
Copyright © CodeProject, 1999-2014
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