Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sub-report in matrix cell Expand / Collapse
Author
Message
Posted Friday, March 8, 2013 10:35 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, August 15, 2014 7:42 AM
Points: 56, Visits: 160
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.
Post #1428695
Posted Friday, March 8, 2013 2:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 20, 2014 1:53 PM
Points: 16, Visits: 366
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.
Post #1428772
Posted Saturday, March 9, 2013 8:35 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, August 15, 2014 7:42 AM
Points: 56, Visits: 160
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.
Post #1428899
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse