September 22, 2015 at 9:59 am
Hello,
I have this RDL that has two parameters. First parameter is @edate (year month), second parameter is @EVTCD (events from each month). The RDL prompts the user to select year month first (@edate), then prompts the user to select an event(@EVTCD) from that month. I would like the RDL to display all of the events from a month if the user selects a month(first parameter) and does not select an event(second parameter) from that month. I ran the RDL and got an error: “Please select a value for the parameter ‘EVTCD’. “
Does SSRS allow blank parameter? I modified the queries so that it would work if either of the parameters is selected. But I still got the same error. Is it because I have two parameters listed in the dataset properties? Can this be done in a different way?
Thank you in advance for any input.
September 22, 2015 at 2:02 pm
If you right-click on the parameter that you want to allow nulls and view the properties, you can specify that the parameter can allow nulls.
If you are basing your dataset on a stored procedure, it will determine how you handle this. Are the parameters coming from the stored procedure (they "magically show up" when you specify the stored procedure as the source for the dataset), or do you create them manually?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply