SSRS in 2024: rsInvalidReportParameter intermittent error for Data Driven Subscription

Question

Hi,

• could not find right tab for this posting.

I'm having weird intermittent error on my data driven subscription SSRS report. It's already simplified to the ground to eliminate all possible errors and still doesn't work as expected.

My report go thru list of 10+ users, run report with each @user and send email to each @useremail.
And checking result I can see that one day I have 8/10 success, other 10/10 errors, other day userA go thru, other day userA didn't go thru, etc...

Can not figure out what is wrong. our DBA gave me logs and it says rsInvalidReportParameter . Which I can not explain.
MS Help !!!!

Thansk

Mario

Answer 1

Hi @Viktor Moshkovoy

An "Invalid Report Parameter" error occurs when the report parameters specified in the data-driven subscription are not valid for a particular subscriber. This can happen for several reasons, such as:

• The subscriber's data does not match the expected data type or format for a report parameter.
• A required report parameter is not provided for a subscriber.
• The report parameter value is not valid for the report.

In your scenario, please also check if values for the parameter is corresponding to the values in the source table. Check if the parameter data type matches the data type in database.

Also please check if the parameter values have a trailing space.

https://learn.microsoft.com/en-us/archive/blogs/psssql/invalidreportparameterexception-with-data-driven-subscription

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.