ReportExecution2005.asmx get error for parameter

sakuraime 2,321 Reputation points
2021-02-09T15:07:35.4+00:00

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

65869-image.png

however I get the above error.

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

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,830 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-02-10T02:17:15.257+00:00

    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.