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

2 posts, 0 answers
  1. Stephane
    Stephane avatar
    1 posts
    Member since:
    Feb 2014

    Posted 14 Feb 2014 Link to this post


    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
  2. KS
    KS avatar
    165 posts
    Member since:
    Oct 2012

    Posted 18 Feb 2014 in reply to Stephane Link to this post


    It is easier if you make a model and tables data are just nested collections or custom properties( Then you can have totals on the container level with little calculations in the model, because expressions data scopes( ) cannot be messed.

Back to Top