Passing mulitple Values + SSRS

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.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Passing mulitple Values + SSRS

Author

Topic

udham1985
Starting Member

6 Posts

Posted - 2011-01-31 : 06:32:03

Hi All,

How can i pass multiple values in a parameter,
for example

ReportParameter[] parm = new ReportParameter[1];
parm[0] = new ReportParameter("EmpID", "5");
ReportViewer1.ShowCredentialPrompts = false;
ReportViewer1.ServerReport.ReportServerCredentials = new ReportCredentials("username", "password", "server");
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://server/ReportServer");
ReportViewer1.ServerReport.ReportPath = "/ReportProjectNew/ReportParameter";

ReportViewer1.ServerReport.SetParameters(parm);

ReportViewer1.ServerReport.Refresh();

I just want to pass more than one value in the parame

parm[0] = new ReportParameter("EmpID", "5");

I want to pass EmpId 3,4 and 5

Thanks in advance

andydexster
Starting Member

7 Posts

Posted - 2011-01-31 : 23:45:26

In reporting services you have the option.
go to the parameter and double click, opens the report parameter properties dialog, in the dialog general tab... we have the options like name prompt datatype...
below the datatype we have the checkbox to allow multiple values..
tick the check box. u can get multiple values in the report.

andy

udham1985
Starting Member

6 Posts

Posted - 2011-02-01 : 04:25:51

Sorry friend i want to pass multiple value from aspx.

My question is

parm[0] = new ReportParameter("EmpID", "5");

in that parameter i want to pass 3,4 & 5 instead of single Value i.e 5

Thanks

quote:
Originally posted by andydexster

In reporting services you have the option.
go to the parameter and double click, opens the report parameter properties dialog, in the dialog general tab... we have the options like name prompt datatype...
below the datatype we have the checkbox to allow multiple values..
tick the check box. u can get multiple values in the report.

andy

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources