Search code examples
crystal-reportscrystal-reports-xicrystal-reports-2010

how to find sub total for each T1 & T2 using Formula in Crytal Report


See This images

how to find sub total for each T1 & T2(see abv img link) using Formula in Crytal Report


Solution

  • An easier solution:

    1. select the Amount field
    2. choose Insert | Summary...
    3. select 'Sum' from the Calculate this summary pick-list (if not already chosen)
    4. choose the Tenant field from the Summary pick-list

    Follow these steps a second time to create a 'grand total' (a summary field located in the report-footer section).

    If you insist on doing it the hard way, the formula would be:

    // {@the_hard_way}
    Sum({table.Amount},{table.Tenant})