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

Case Study: Hilltops IT create Innovative Contract Calculator which Transforms Tescan’s Sales Process

Feb 05, 2025

Hilltops IT Consultancy Services Ltd. is excited to announce the successful implementation and expansion of a groundbreaking Contract Calculator for Tescan, a leading provider of scientific instrumentation. This innovative solution, developed by our dedicated team, seamlessly integrates SugarCRM and QuoteWerks systems, significantly enhancing the accuracy and efficiency of generating customer quotations. Read the full press […]

READ MORE

Embracing Technologies: Our Adoption of Xojo

Oct 08, 2024

Introduction In the fast-paced world of software development, businesses must remain agile and adaptable. This case study explores how we successfully transitioned the maintenance and enhancement of a custom software application written in Xojo in-house following the retirement of the original developer. The Challenge When the original developer of a critical custom software application retired, […]

READ MORE

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