This is a migrated thread and some comments may be shown as answers.

Total general in a report composed of several crosstabs with their own datasource

1 Answer 33 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Stephane
Top achievements
Rank 1
Stephane asked on 14 Feb 2014, 03:33 PM
Hello,

I made a report with 4 crosstabs in detail section (I want to avoid doing subreports)
The report doesn't have datasource but each crosstab has its own datasource.
In the ReportFooter section i want to show a general total (The sum of crosstabs's total cells).

Example :
Crosstab1 total cell  = Sum(Fields.AcResult) = 1000
Crosstab2 total cell = Sum(Fields.VeResult) = 500
Crosstab2 total cell = Sum(Fields.PaResult) = 0
Crosstab2 total cell = Sum(Fields.CcResult) = -100
ReportFooter total should be 1400

How can i define the reportfooter total  textbox value ?

Thank you for your help
Stephane

1 Answer, 1 is accepted

Sort by
0
KS
Top achievements
Rank 1
answered on 18 Feb 2014, 06:49 PM
Hi,

It is easier if you make a model and tables data are just nested collections or custom properties( http://www.telerik.com/help/reporting/data-items-how-to-use-data-object.html). Then you can have totals on the container level with little calculations in the model, because expressions data scopes(http://www.telerik.com/help/reporting/expressions-scope.html ) cannot be messed.

-KS
Tags
Report Designer (standalone)
Asked by
Stephane
Top achievements
Rank 1
Answers by
KS
Top achievements
Rank 1
Share this question
or