Search code examples
crystal-reportscrystal-reports-2008crosstab

Add 3 rows separately at the end of the crosstab


I am working on crosstab in Crystal Reports, I am able to see required data and everything is fine but I am stuck at one point where I need to insert Total, Avg and Max as 3 rows one below one at the end of cross tab.

I have tried Embedded Summary but that one is inserting a row below every row of the cross tab but I don't need that way.

Image of my problem

I searched the web, but couldn't find the solution.


Solution

  • I finally found a solution.:

    1. In preview mode added the rows using the option Calculated Summary, by this way we can add any number of rows at the end of the cross tab.
    2. Now by editing the required row, added the calculation formula for Sum, Max and Average.