SSRS Hidden parameter results in "Parameter X is missing a value"

Question

First I would like to apologise for any mistake and misuse of the english language as it is not my natural language.

I built a few reports using SSRS. Each one are feeded through different stored procedures. Each stored procedures has two parameters: id and date. When I display the report the parameter I only want to be visible the date that will be supplied by the user. The id should be hidden and with the default value of 1. So, I turned the parameter id to hidden and set up a default value with the value 1. Im setting the default value on a report's definition level instead on the datasets used to feed the reports. PLease see below the steps I have done: enter image description here

enter image description here

I've been through some websites(stackoverflow included) and I've seen similar issues. I followed the suggested tips but still no success. Any help on this will be very appreciated. Thanks

P.S. Im using VS2015 to design the reports and SQl Server 2014.

Answer 1

Without knowing more, my first instinct suggests that you have your parameters ordered incorrectly. If you have a parameter, P2, with a default value that is processed after a parameter without a default value, P1, and both parameters are hidden, then the report will fail citing that P1 is missing a value.

See my screenshot below as an example. You need to make sure that the parameters are loaded in the order, vertically, that they should be processed, especially if one parameter is dependent on another. Take a look at the ordering and leave a comment if you need further information.

Revised based on Response in Commments Try opening the report manager via the Report Server web interface (http://[serverName]/[instanceName - reports is default]/Pages/Folder.aspx?ItemPath=/[directoryOfReport]). Click on the dropdown list beside the report name and choose manage. Check out the parameters tab and make sure the default is set properly. Sometimes, if you've messed with parameter properties numerous times in BIDS or report builder, the settings won't translate onto the server itself. Let me know if that fixes it.