ReportExecution2005.asmx get error for parameter

Question

I have a report having a parameter CollID . and i use ReportExecution2005.asmx and add parameter to get the report

however I get the above error.

the link is like
http://reportserver/ReportExecution2005.asmx?.......&rs:ParameterLanguage=en-us&CollID=MYVALUE

Answer 1

Hi @sakuraime ,

add parameter to get the repor

I'm not sure if you mean creating a subscription, please feel free to correct me if I misunderstood.
In Reporting Services, when we create an subscription for a parameter report, reporting services will check if the parameter default value is an available value. So if the default values doesn’t exist in the source table or the specified values exist in Available Values, the exception will throw out.

Please check if values for the parameter is corresponding to the values in the source table. Also check if the parameter data type match the data type in database.
Also please check if the parameter values have a trailing space. Please refer to this article: InvalidReportParameterException with Data Driven Subscription.
This link is very clear.

Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.