Columns with zero on rows not showing in Cross Tab

[Roni1]

I have a Cross Tab that whenever a column has all the rows with zeros or nulls, that column is not displayed.
I need to see all the columns, and I am not supressing any rows or columns with zeros.

That is on CR 8 and the database is Oracle.

Thanks in advance for any help.

Ron

 

[dgillz]

This is a trait of a cross tab report. If you have say an item range as rows and a month range as items as columns, and there is am item that did not sell during the months in question, you get no row.

Also, if there is a month with no sales of the item range in question, you get no column.

The only way to change this is (in my example) to put dummy data of quanties (even if the qty is zero) and dates sold so that every item and every month is displayed. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com