Skip to Content

Crystal Cross tab suppress total and show zero fields

Experts,

I'm consolidating financials in Crystal across 2 DB's (A & B) and using Cross Tab in Crystal works well.

Question 1: I see that there is a total of some sort under the DB name column. But I do not know where this comes from, it is not the Sum of the Balance... How can I suppress this total? It seems it is something Cross Tab is doing automatically, I cannot select that field to suppress.

Question 2: I do not see all the Account Segments in the rows - the ones with 0 values does not show. I need all to show even if it is $0.

Your assistance will be appreciated,

Marli

3.png (30.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 05 at 04:48 PM

    I was able to solve the extra amount and wrong Total field with the Cross Tab Expert > Cross Tab > Cross Tab Group Options > Others: "Discard all others"

    Thanks for your assistance.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 01 at 07:58 PM

    Hi Marli,

    Do you have Account Segments with NULL values? If yes, then that's what the first row is.

    To show all rows, go to the Crosstab Expert > Customize Style and make sure "Suppress Empty Row" and "Suppress Empty Columns" is unchecked.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded