Optional grouping depending on selected parameter in reporting services

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Optional grouping depending on selected...

Optional grouping depending on selected parameter in reporting services

Rate Topic

Display Mode

Topic Options

Author

Message

felix-659856

Posted Monday, April 21, 2008 4:49 AM

Grasshopper

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

Jon Spink

Posted Tuesday, April 22, 2008 4:34 AM

Mr 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

felix-659856

Posted Tuesday, April 22, 2008 8:49 AM

Grasshopper

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 »

Permissions