Skip to Content
Former Member
Sep 02, 2013 at 07:02 PM

How to insert custom summary column in cross-tab report


I have a crosstab report that shows individual preferences based on age range and relationship status. Currently the value fields show a count of the number of persons. I would like to insert 2 additional columns to display the total number of males and females respectively. The columns are to be inserted to the left of the total column.

This is the original report.

So the report should look like this, displaying the total number of males and females for each relationship status for each age range. Then the grand total for both gender.

By the way I am new to crystal reports. I am using 2011

I cannot modify the datasource, sql server db, it is not allowed.

Please let me know if you require additional information and I will provide it. Any help will be much appreciated, I have been at this for sometime now 😔


table1.jpg (42.0 kB)
table2.jpg (49.3 kB)