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.
How to do totals with cross data
How to do totals with cross data
- Attachments
-
- testDB.7z
- (196.34 KiB) Downloaded 201 times
-
- sample.mrt
- (17.54 KiB) Downloaded 197 times
Re: How to do totals with cross data
Hello.
Please, try to use Cross-tab component instead of the Cross-data.
Thank you.
Please, try to use Cross-tab component instead of the Cross-data.
Thank you.
Re: How to do totals with cross data
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.
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
Hello.
You could use a HashTable to store sum and then show it in the footer.
Thank you.
You could use a HashTable to store sum and then show it in the footer.
Thank you.