SSRS is it possible to insert custom line between the group list?

  • Hi,

    I have simple report but user wants to add some title that kind looks like parent group, is it possible to insert extra line let say after 3rd group Total ?

    Otherwise I'll need to add extra group I think and play with visible/hide properties.

    GROUP101

    GROUP102

    GROUP103

    TOTAL FOR <100> GROUP 1000

    AND NOW REST OF THE GROUPS

    GROUP201

    GROUP202

    GROUP300

    SUPER TOTAL FOR ALL

    Best

    Mario

  • mario17 (12/2/2013)


    Hi,

    I have simple report but user wants to add some title that kind looks like parent group, is it possible to insert extra line let say after 3rd group Total ?

    Otherwise I'll need to add extra group I think and play with visible/hide properties.

    GROUP101

    GROUP102

    GROUP103

    TOTAL FOR <100> GROUP 1000

    AND NOW REST OF THE GROUPS

    GROUP201

    GROUP202

    GROUP300

    SUPER TOTAL FOR ALL

    I would add another group into your report. That group would be based on a calculation (something like IFF (LEFT (Fields!CurrentGroupField.Value, 6) = "Group1" ,"100 Group" , "All Other Groups")

    Potentially, you could add the calculation of this value either into the source for the dataset or as a calculated field in the dataset.

    You may still need to conditionally hide/show headers and footer from the groups depending on what you need to show and you probably need to use and expression in the header/footers to show the values you are after.

    Best

    Mario

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

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