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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

910 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now