Page 1 of 1

How to do totals with cross data

Posted: Tue Jan 20, 2015 1:29 am
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.

Re: How to do totals with cross data

Posted: Tue Jan 20, 2015 1:01 pm
by HighAley
Hello.

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

Thank you.

Re: How to do totals with cross data

Posted: Wed Jan 28, 2015 6:19 am
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.

Re: How to do totals with cross data

Posted: Wed Jan 28, 2015 11:07 am
by HighAley
Hello.

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

Thank you.