sql server reporting services: Q: passing int parameter -- sql server reporting services

Q: passing int parameter

JIM.H.
6/8/2005 2:07:06 PM

sql server reporting services:

Hello,

This is the way I call report viewer in my asp.net application.

this.ReportViewer1.ServerUrl=serverUrl;
this.ReportViewer1.ReportPath=repName
this.ReportViewer1.Parameters=Microsoft.Samples.ReportingServices.ReportViewer.multiState.False;

this.ReportViewer1.SetQueryParameter("MyName",myname);
this.ReportViewer1.SetQueryParameter("MyID",myID);

MyName is a string and MyID is an int. Without MyID parameter it is working
fine, however, when I add MyID it does not work, so how can I pass an int
parameter to reporting services.

Thanks,

Re: passing int parameter

Bruce L-C [MVP]
6/8/2005 4:33:23 PM

Is the parameter defined as an int in the report? The default is string and
unless you have changed it in the report it is still a string.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]