Sum of total columns from different data sources

Stimulsoft Reports.JAVA discussion
Post Reply
Manuel Costa
Posts: 72
Joined: Thu Sep 24, 2020 2:40 pm
Location: Brazil

Sum of total columns from different data sources

Post by Manuel Costa »

Gentlemen, I'm performing the following process I have two different data sources Folder and Report that have two columns of type Double, I total them with the SUM function and the result is returned normally.

But when I try to perform the REPORT_ID column of the double type of the Report source with the FOLDER_ID column also of the Double type and the Folder source, where it should display the total value, it doesn't return any value, Could you explain to me how I can perform this process?
Attached prints and the report in question.
Attachments
2.JPG
2.JPG (39.77 KiB) Viewed 1058 times
1.JPG
1.JPG (119.31 KiB) Viewed 1058 times
soma rodape.mrt
(11.34 KiB) Downloaded 134 times
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Sum of total columns from different data sources

Post by Lech Kulikowski »

Hello,

Please read the descriptions of the Sum function, it is not possible to use two columns in one function. You should use the following expression:
{Totals.Sum(FONTE, FONTE.FOLDER_ID) + Totals.Sum(FONTE2, FONTE2.REPORT_ID)}

Thank you.
Post Reply