2

I have a parameter in my SSRS report which I have marked as "Allow Null Value". But when I dont send that parameter from my C# code. I get the below error.

Message=This report requires a default or user-defined value for the report parameter 'UserID'. To run or subscribe to this report, you must provide a parameter value. (rsReportParameterValueNotSet)

Here is the parameter configuration. Available Values and Default Values tabs are marked as "None".

In some conditions, I don't want to send that parameter. But it wont allow. What else am I missing?

enter image description here

Feroz
  • 351
  • 1
  • 5
  • 20
  • 2
    Perhaps you are experiencing [this issue](http://stackoverflow.com/q/14701233/419956)? – Jeroen May 01 '14 at 21:48
  • 1
    That was it.. Thanks Jeroen !!! So sad I can't mark your answer as accepted !!! – Feroz May 01 '14 at 22:22
  • That's ok, glad I could help. Let's mark your Q as a duplicate so others with your symptoms will quickly spot the solution. – Jeroen May 01 '14 at 22:29

1 Answers1

0

When you have a NULL or don't want to pass a value, then include this in the URL:

&UserID:IsNull=True
Registered User
  • 8,357
  • 8
  • 49
  • 65
  • which URL is this? In my C# code, I use the ReportViewer.ServerReport.Render() method to send the parameters and get a byte stream.. – Feroz May 01 '14 at 21:11