I recently ran into an issue with a report where 90% of the time the report would work and the other 10% it was failing with the error:
The ‘???’ parameter is missing a value
Note: ??? is the parameter name – “AllAccounts” in my example here.
The parameter in question had the following attributes:
Data Type: Text
Visibility: Hidden
Default Values: Driven off a dataset within the SSRS report.
After researching the issue most people seemed to get around the issue by either:
- Setting the available values to None
- Specifying the default values (i.e. under Default Values set Specify values and add them to the list.
Both fixes above would not work for me and the default values needed to remain a dataset due to the dynamic nature of the report.
The Fix
The fix for me is a little embarrassing to admit: Check the default dataset is returning data.
Whilst I thought I had checked this multiple times, it turns out that I was using the wrong database connection. I had two sandbox environments and had missed that the report was pointing to an old copy rather than the latest copy and the failing records did not exist in the old copy (hence the default dataset was not returning any data).
That’ll teach me to not get back to basics and review the connections.
