Parameter is missing a value ssrs 2008

reporting-services ssrs-2008
Adarsh picture Adarsh · Jun 23, 2012 · Viewed 42.1k times · Source

I have a parameter of integer datatype which is hidden. When i run the report, report gives me an error

Parameter X is missing a value

However if i make the parameter visible it works. I tried providing default value of 0 but that does not suffice my requirement as i have sub-report(Drill-dowm) depended on this parameter. Please help. Thanks!

Answer

dmbreth picture dmbreth · Jul 20, 2012

Make sure that you have not specified Available Values for the parameter. Available Values should be "None" for internal and hidden parameters.

Related questions

How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More
How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the …

Read More
SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: …

Read More