none
Passing Nothing in Custom Group By Expression in SSRS

    Question

  • Hi All,

    Today i came with another issue related to the SSRS Tabix Grouping,

    I am using custom grouping of tabix according to user selected column name

    For ex: Parameter Group: A, B, C, None.  these are option for user i.e if user select A the tabix will group by column A,

    similarly for b and c, but i want that if user selects 'None' no groupin should apply.
    expression like:

    IIF(Not(Group.value)="None",fields(GRoup),<Nothing>)

    my problem is that, i want No grouping should apply, if user selects None option from above mentioned drop down.

    Please guide me how do i achieve this............

    Thanks in advance.........


    shahsank


    Tuesday, June 18, 2013 6:18 AM

All replies

  • Hi Shahsank,

    To achieve your goal, you can use the following steps:

    1. Right click on the target group from the Grouping pane, and open the Group Properties dialog box.

    2. Set the expression for the “Group on” option as follows:

      =Switch(Parameters!Group.Value="A",Fields!FieldName1.Value,Parameters!Group.Value="B",Fields!FieldName2.Value,Parameters!Group.Value="C", Fields!FieldName3.Value, Parameters!Group.Value="None", Nothing)

    Besides, if you also want the group textbox displays different fields values according to the parameter that user selects, you can also specify a similar expression to the textbox.

    If I have anything misunderstood, please feel free to let me know.

    Regards,


    Mike Yin
    TechNet Community Support

    Wednesday, June 19, 2013 6:55 AM
  • Hi Mike,

    thanks for the reply...

    i go through you technique...

    i changed my group expression like....

    =IF(param="None","1",Param.value)

    here param is my parameter name.

    now i need to hide the Group row also according to it i.e. if user select Group By: None  then group header row should be hidden otherwise shown this is working fine on Report Builder/Designer,

    but when i use this .rdl on report viewer then it fails and show me only one detailed row.

    Please help me on this....

    if you have any query related this, i love to answer that........

    it is very urgent for me...

    thanks in advance...


    shahsank

    Monday, July 29, 2013 9:21 AM