Impromptu - Cross table

[GilMerc]

Hi,

I create a cross table report and I would like to know if is possible to force a fix column where no data was found in line data.

In default, the column is generating by Impromptu and only the column with data appears. In context where the report is use by end user, it's more efficient and user friendly to display all columns anytime. The user doesn't think where is the data column. It's zero but the user would like to see the zero.

thank's in advance.
Gilles

 

[DoubleD]

Crosstab reports are built on the fly. If there is no data, then Impromptu won't know to create the column.
The only way around this is to create a list report that looks like crosstab. Each column becomes a calculation, (if then else, decode) depending on the database. This is difficult to maintain and does not perform as quickly, but it does meet your need.

Pain is stress leaving the body

DoubleD