March 8, 2013 at 10:35 am
I have a sub report in a matrix cell that works just fine. The matrix displays values for each Month. The sub report takes parameter values from the matrix for the date range and displays more detailed data on a day by day basis. However if there are no records in the matrix cell for a particular month - such as the current month. I get an error "One or more parameters were not specified for the sub report".
Has anyone any idea how I might overcome this error - ie simply show nothing instead?
For completeness the subreport is toggled visible by the matrix value cell so its not obvious until you try to open up the sub report that you have a problem.
March 8, 2013 at 2:46 pm
I believe all you need to do is check the Allow Blank Value/Allow Null Value properties of the parameters for the subreport and you should stop seeing the error - assuming the data set behind the subreport can execute successfully without a value for the given parameter.
March 9, 2013 at 8:35 am
It's quite obvious really - isn't it. Now I just need to ensure the stored procedure will accept a NULL start and end date and return an empty record set and Bob's your fathers brother!
Thanks for your help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply