How to do totals with cross data

Stimulsoft Ultimate discussion
Post Reply
iamyong
Posts: 23
Joined: Tue Dec 16, 2014 7:43 am

How to do totals with cross data

Post by iamyong »

Hi,

I have attached a sample report and database (MS SQLExpress 2014) for my problem. My main question is: how do I do totals on cross-tab data based on the currently displayed values, WITHOUT having to create another datasource for it. In my sample report, please check CrossDataBand10, I'm not getting the correct totals when I try to do summary totals.

Thank you.
Attachments
testDB.7z
(196.34 KiB) Downloaded 201 times
sample.mrt
(17.54 KiB) Downloaded 195 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: How to do totals with cross data

Post by HighAley »

Hello.

Please, try to use Cross-tab component instead of the Cross-data.

Thank you.
iamyong
Posts: 23
Joined: Tue Dec 16, 2014 7:43 am

Re: How to do totals with cross data

Post by iamyong »

Hi Aleksey,

Is there no way to do the totals just using the existing components i have in my sample? The reason I'm asking is because the actual report that I am making follows a specific layout format that cross-data satisfies. The only problem I have now is doing totals and subtotals from dynamic column data using only stimulsoft summary sum functions.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: How to do totals with cross data

Post by HighAley »

Hello.

You could use a HashTable to store sum and then show it in the footer.

Thank you.
Post Reply