About / Blog

SSRS rsReportParameterValueNotSet error

An answer to SQL Server Reporting Services (SSRS) rsReportParameterValueNotSet – “This report requires a default or user-defined value for the report parameter. To run or subscribe to this report, you must provide a parameter value” error.

We’ve just found a very strange reason for this error to occur. At the moment we can’s explain why this solution resolves the problem, but we will be looking into it. If you’ve got any insights, then please comment with your thoughts as to why this problem could occur.

The server being used is a Windows Server 2008 with SQL Server 2008. We’re generating a report through code using the standard ReportingService2005 and ReportExecutionService objects, calling GetReportParameters and SetExecutionParameters before finally calling the ReportExecutionService Render function to generate a PDF of the chosen report.

The report that we were having a problem with had just one parameter – SupplierID – a string value (actually a database GUID / uniqueidentifier) but converted to a string for the report.

Anyway: we were getting the rsReportParameterValueNotSet – “This report requires a default or user-defined value for the report parameter. To run or subscribe to this report, you must provide a parameter value” error.

The answer was to convert the GUID uniqueidentifier value to UPPER CASE before assigning it to the ParameterValue array!???

Thoughts on why this might be necessary are welcomed!

Related Stories

See all

How to be a better software development company

Dec 30, 2010

Prompted by some of the comments and discussion in the article about software development add-ons, and during an internal brainstorming session as to how we can improve our ConnectIt software development services, we started a couple of lists on how to be a better software author. We’ve tried to think of it as traits of a […]

READ MORE

Why choose QuoteWerks Corporate rather than Professional?

Oct 15, 2010

Why QuoteWerks Corporate edition? As well as some additional features (to do with synchronisation) and the additional contact manager options i.e. MSCRM and ConnectWise, the real reason we recommend QuoteWerks Corporate over Professional is the ability to host the database to SQL Server. For a larger organisation that’s generating more quotes, the SQL Server back end is […]

READ MORE

Why should I pay for developed add-ons when my software should do ‘X’ anyway!?

Oct 15, 2010

I started this blog article in response to the comment made in the QuoteWerks software support forum here: “I know there are add-ons to correct the date, but why should we need an add-on to get basic functionality?” For anyone who’s reading this that’s not familiar with my (and Hilltops IT / ConnectIT Software‘s) background […]

READ MORE