I have a report which group by data based a few parameters. Sporadically the report will give an error when loading the default values:
• Default value or value provided for the report parameter 'Parameter1' is not a valid value.
I assume that the above error could be occurring since it is trying to pass a comma separated parameter string into the dataset query which accepts this parameter.
The same query works fine on the backend and there are no null or blank values in the parameter lookup tables. We are running SQL Server 2005.