I have a report that I have to code that is pulled from 2 different tables. Both tables have the same data, but it's group a bit differently. I need sub totals for each category though. I also need a final total over all. Should I use sub reports or try to use groups? How can I do sub totals on groups?
1 Answer, 1 is accepted
0
Hi,
Try to merge the data into one and use groupings on report level. Then using Data functions sub totals can be displayed in each group header/footer section.
Other approach is to use Table/Crosstab/List item, and add proper groupings and totals. An example for Crosstab item can be found in the provided with your installation local demos, placed by default under C:\Program Files (x86)\Telerik\Reporting <VERSION>\Examples
If you need further help, please elaborate on the data structure and desired layout.
Regards,
Stef
Telerik
Try to merge the data into one and use groupings on report level. Then using Data functions sub totals can be displayed in each group header/footer section.
Other approach is to use Table/Crosstab/List item, and add proper groupings and totals. An example for Crosstab item can be found in the provided with your installation local demos, placed by default under C:\Program Files (x86)\Telerik\Reporting <VERSION>\Examples
If you need further help, please elaborate on the data structure and desired layout.
Regards,
Stef
Telerik
Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.