Suppress Rows in Cross Tab Reports

Posted on 2002-03-20
Last Modified: 2007-12-19
I have a cross tab report that, that breaks/groups on a field,
I only want to see the column header & Column totals for each break/group, no row totals and no rows for the group!

I know in a regular report I just suppress the rows and they wont show. How do you do this in Cross tabs? If at all.

Question by:ewalsh
  • 2

Expert Comment

ID: 6883848
Please see the following from Crystal Help to see if helps:

Suppressing Cross-Tab data
This section provides you with the steps required to suppress data in your report. You can suppress:

Empty rows and columns
Row and column grand totals
Subtotals and their labels.
To suppress empty rows and columns
Right-click the blank top-left area of the Cross-Tab and select Format Cross-Tab from the shortcut menu.
The Cross-Tab dialog box appears.

Click the Customize Style tab.
Select either the Suppress Empty Rows or Suppress Empty Columns check box.
Click OK.
Now, when you print the report, empty rows and/or columns will not appear.

To suppress row and column grand totals
Right-click the blank top-left area of the Cross-Tab and select Format Cross-Tab from the shortcut menu.
The Cross-Tab dialog box appears.

Click the Customize Style tab.
Select either the Suppress Row Grand Totals or Suppress Column Grand Totals check boxes.
Click OK.
To suppress subtotals and labels
If you have more than two groups in your Cross-Tab you can suppress the subtotal and label for one of them.

Right-click the blank top-left area of the Cross-Tab and select Format Cross-Tab from the shortcut menu.
The Format Cross-Tab dialog box appears.

Click the Customize Style tab.
Click the field whose subtotal you want to suppress.
The Suppress Subtotal and the Suppress Label check boxes become active.

In the Group Options area select the Suppress Subtotal check box.
Click the Suppress Label check box to suppress the label associated with subtotal.
Click OK.

Let me know if this does not address your issue and we'll see what else we can do.

Good Luck

Author Comment

ID: 6885719
No, I read that already. The rows & columns are full of data, however the end user doesn't care about the detail, Its the bottom line (grand total) for the columns in each group that they need.
Just printing the entire report and ignoring the detail wouldn't work either since it would be over 100+ pages to print. By surpressing the row details and just printing the Column grand totals for each group would only be like 3-4 pages. So it would save alot of trees!
I know I can do this in MS Access and maybe forced to do so, This should be an easy thing to do, many people must only care about the bottom line of a cross tab report and don't need to see the detail, you can do it in C.R. in non-cross tab reports, can't see why not in cross tab reports.

Accepted Solution

pradeepkgupta earned 300 total points
ID: 6887885
Hi "ewalsh"

There is a easy solution for your problem.

Identify the field that is creating rows. i.e. the field which is selected in the "rows" area in the format CrossTab window. Let's say this field is Row_field.
The distinct values in this Row_field column is creating different rows. If this field contain one value then we will get only one row. This is how CrossTab works.

Now we play a tric with CrossTab. We will create a formula field named "Dummy_Row_field"like this

if Row_field = "ewalsh" then "Grand Total"
else "Grand Total"

Now include the folmula as the row in the crosstab and remove "Row_field" from there. Also check the "suppress row grand totals" check box.

Make sure that the summary operation is SUM.

Now you will get only one row.

You can modify you report like this to get the desired result.


Expert Comment

ID: 7089967
Have you solved that problem !!


Featured Post

ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sort by a cross tab in crystal report 2 50
Formatting a Crystal Reports Report 9 86
Crystal Reports--SubReport 3 57
Crystal Reports 12 35
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question