Post reply

Optional grouping depending on selected parameter in reporting services

  • April 21, 2008 at 4:49 am

    #189577

    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....

  • April 22, 2008 at 4:34 am

    #805392

    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.

  • April 22, 2008 at 8:49 am

    #805573

    Thanks for your help Jon!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply