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

Optional grouping depending on selected parameter in reporting services Expand / Collapse
Author
Message
Posted Monday, April 21, 2008 4:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 20, 2012 8:13 AM
Points: 21, Visits: 82
Hi,

I have a report which can be executed by selecting different companies from the parameter field. The report is grouped by company but I want to be able to ran the report for ALL companies without the grouping. So when ever a sepecific company is selected it executes by grouping on (Campany) but when "ALL Companies" is selected it should ran without grouping by Company

Any ideas pls....
Post #487818
Posted Tuesday, April 22, 2008 4:34 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, June 20, 2012 5:02 AM
Points: 530, Visits: 945
When defining the group, you need to use an expression, something like:

=iif(Parameters!Company.Value = '"[ALL]",1,Fields!Company.Value)

The content of the group header should reflect this too.
Post #488474
Posted Tuesday, April 22, 2008 8:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 20, 2012 8:13 AM
Points: 21, Visits: 82
Thanks for your help Jon!
Post #488686
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse