January 13, 2015 at 10:50 am
I've written a data-driven subscription for a particular report. On the scheduled run date however it didn't send any output. Looks like I'm getting this on the subscription page:
Done: 1 processed of 1 total; 1 errors
Looking at the SSRS execution log file I'm getting the following error:
library!WindowsService_40!b3c!01/09/2015-16:50:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: , Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'AKParam' is not a valid value.;
I don't know why this is so as this parameter is in effect a dummy parameter on the report to get it through a data-driven subscription i.e. the parameter isn't fed in to the report's dataset stored procedure, it's just a string data type parameter on the report. The data type for the subscription SQL table is nvarchar(10), and the value it's trying to pass in is the same as default for that parameter in the report i.e. a two character code.
Anyone know how to troubleshoot this issue? Tried running a SQL trace but it gave me no clues.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply