I need to insert cumulative sub-total on each page of my RDLC .NET report, I'm using a table to allocate all field values and their sums.
The great difficulty is to insert the total into one of the cells of this table.
I need to insert cumulative sub-total on each page of my RDLC .NET report, I'm using a table to allocate all field values and their sums.
The great difficulty is to insert the total into one of the cells of this table.
You need to add new groups in your tablix
, in the Detail section, and within the Row Groups
of your table. You can create as many groupings as you like.
Then you can set the partial and total sums for these groups. You can also do formulas in your fields, such as:
=sum(Fields!Campo1.Value)/CountDistinct(Fields!campo2Agrupado.Value)