Create subtotals

[mrapi]

Hi,it is possible to create such subtotals as in image,for every group?

img.png (2.22 KiB) Viewed 1919 times

thanks

[Lech Kulikowski]

Hello,

Depends on DataStructure. You can try to use master-detail construction with grouping to implement it.
Please send us a test data, we will try to prepare a sample for you.

Thank you.

[mrapi]

Hi
I've attached some sample data and a staring report
thanks

[Lech Kulikowski]

Hello,

Please check the modified report in the attachment.

Thank you.

[mrapi]

great.

recap:
main data source: tb, 3 columns: ID(long),PROC(int),VALUE(int)
add +2 report internal datasources(Data from other DataSource): DataSource1 and DataSource2,in both set tb as main source
DataSource1 add 1 columns ID(long),Add Group(in edit datasouce->Groups) by col ID,add relation Relation1 by ID between tb as child and DataSource1 as parent
DataSource2 add 3 columns ID(long),PROC(int),VALUE.Sum(int)-added as agregate func SUM(in edit datasouce->Results),Add Group(in edit datasouce->Groups) by cols ID+PROC,add relation Relation2 by ID between DataSource2 as child and DataSource1 as parent
on report add 3 bands:
first(DataBand1) set to DataSource1,add one text set to:{DataSource1.ID}
second (DataBand2) set to tb,set Master Component to DataBand1,set relation to Relation1,add 2 text set to: {tb.PROC} and {tb.VALUE}
third(DataBand3) set to DataSource2,set Master Component to DataBand1,set relation to Relation2,add 1 text set to: {DataSource2.PROC} - {DataSource2.VALUE_SUM}

thanks

[Lech Kulikowski]

Hello

We are always glad to help you!

Thank you.