Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Hide a Crosstab row


It seems to have a little diference between "hide" and "suppress" in Crystal.

We're using CR 14 to built a Cross Tab with 2 groups of measuring: group 1 shows data each 30 min. Group 2 summarize daily.

We use group 1 to calculate the last 3 calculated columns (Total, Gas, Liq), and then the summarized Total (blue row).

So far, so good! However, we want now just Totals, i.e., we need data in yellow to calculate blue lines, but we want to hide them and collapse all blue (totals) in just one table.

We've tried the "Format - Suppress" and reach this:

But it didn't collapsed yellow lines, even though setting (Row options - Suppress Blank Lines). Maybe because these are not "blank" lines.

Is there an easy way to collapse lines to show only TOTALS? Something like this:

Not what you were looking for? View more on this topic or Ask a question