locked
Add totals within a specific data structure inside RDLC Report RRS feed

  • Question

  • User785109023 posted

    Hi everybody,<o:p></o:p>

    I have one specific problem that I can not solve. My data set (Detail Tablix) inside RDLC report has the following structure:<o:p></o:p>

    On that structure I need to insert SubTotals (for column Amount) for each level of data as shown in the following picture:<o:p></o:p>

    So, we have five different levels that we need to calculate Totals (to a depth of 3): Level 1, Level 1.1, Level 1.2, Level 1.2.1, Level 1.2.2

    For each Level there is an indicator inside the column LineNo which marks the beginning and end of the group: GB - Group Begin, GE - Group End

    Do you have any idea or tips how to achieve that? Just to mention, this is the input data set to RDLC and is not subject to any manipulation at the level of the database.

    I really appreciate your help. Thanks.

    Saturday, March 11, 2017 9:22 PM

All replies

  • User-2057865890 posted

    Hi AdnanG,

    To add totals for a group, click Add Total on the shortcut menu for the group in the Grouping pane. To add totals for an individual cell in the tablix body area, click Add Total on the shortcut menu for the cell. 

    https://msdn.microsoft.com/en-us/library/ms170712.aspx

    Best Regards,

    Chris

    Monday, March 13, 2017 5:59 AM