Click here to Skip to main content
15,905,419 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
When i try accessing below ssrs link i get error

http://inggfdsfyz/ReportServer/Pages/ReportViewer.aspx?%2fMonitorReport%2fFinalReport&CountryID=2628&Stateid= 2&CityId=346,7

Here two values are passed for parameter cityid

Below is the error i get-;

An error has occurred during report processing. (rsProcessingAborted)
Cannot read the next data row for the dataset dsFinalReport. (rsErrorReadingNextDataRow)
ORA-01722: invalid number

I need to pass multiple values for parameter cityId. Please Advise.

1 solution

The url should repeat the parameters instead of delimiting it.

So, your url should be http://inggfdsfyz/ReportServer/Pages/ReportViewer.aspx?%2fMonitorReport%2fFinalReport&CountryID=2628&Stateid=2&CityId=346&CityId=7
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900