Regarding Grouping in ssrs

  • Hi ,

    Need some help regarding grouping expression.I have a parameter @cc i wanna group a field based on it.If @cc=1 then it should group on a field else it should not group on any field.I mentioned expression =IIF(Parameters!CC.Value=1,Fields!DIVISION.Value,Nothing) but it is not giving me the exact results,am assuming the issue is due to the toggling of detailed information.

    Help me

    Thanks in advance 🙂

  • In a data region, you can group data by a single field, or create more complex expressions that identify the data on which to group.

    We can apply dynamic field in Group Expression. However, in this scenario, you apply the condition to return a field or nothing. If it returns nothing, the group is disables which means the table structure is changed. The report can't process this kind of dynamic structure. So you should replace the nothing into another field within detail row.

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

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