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
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
0
KS
Top achievements
Rank 1
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
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