Crystal Reports Crosstab Report Suppress Grand and Subtotals

In this post Crystal Reports Crosstab Report Suppress Grand and Subtotals, we shall see on how to suppress the Grand and Sub-Total values which come with the Cross Tab report.

To know more on how to create a Cross-tab report refer the post Crystal Reports CrossTab Report in Asp.Net.

A Crosstab report by default comes with Row and Column wise Grand and Subtotals
A Grand Total is added to all the Cross Tab reports
A Subtotal is added to Cross Tab reports, which have grouping enabled in Rows/Columns

In many cases we might not want the Grand and Sub totals, as they get embedded between the data and give a confusion, here we shall see on how to disable these.

To Disable Grand Totals
Right click on the Cross Tab and select Cross Tab Expert
Navigate to the Custom Style Tab
Check the Suppress Row/Column Grand Total checkboxes
Click OK

To Disable Sub Totals

Right click on the Cross Tab and select Cross Tab Expert
Navigate to the Custom Style Tab
Under Rows/Columns select the Field which is used for Grouping
Under Group Options, select the Suppress Subtotal checkbox
Click OK

Now save and run the report.
Here's how the reports look with and without the Totals

With Totals

Without Totals

That's it we have suppressed the Grand/Sub totals in a Cross-tab Crystal report.