Reporting Services Parameters

I have a report set up in SQL reporting services which I need to pass two values: fundingRef and mRef from another aspx page which I have managed to get working using the following code:

string param = "&fundingRef=2" + "&mRef=25";
ReportViewer1.ReportPath = Global.ReportPath + reportPath + param;

Both the parameters have been set up in the SQL report designer in VS2003.NET and will contain several values using the SQL IN statement. My sql statement is to a structure as follows:

SELECT [field names] FROM [table] WHERE (fundingRef in(@.fundingRef )) AND (mastercourseRef in(@.mRef))

When I pass single values, it works fine but when I try to send values e.g. 14, 25, 3, 4, 28, 2, 1, 6, 5. I get the following error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot read the next data row for the data set TTP. (rsErrorReadingNextDataRow) Get Online Help Error converting data type nvarchar to bigint.

I have tried declaring the variable as a varchar but although it returns no error, it also returns no records. Please can someone enlighten me as to how I can this to work. Cheers.

Are you using "," as value seperators?

D.|||Yes|||This should work with RS 2005 as it support multiple param selections.

I'm guessing this is the reason it's not working now.|||Try using a table function & large varchar parameter if your report can accomodate.
See this article on parsing tokens...|||Cool, thanks for the information wavesmash. I hope this should fix my problem. I'll let you know how I get on.

Cheers again