Urget - PLease help!! How to show all headers/ columns

system · January 24, 2011, 9:57am

Hopefully a simple question for the experts; how do I force all the column headers to appear in my cross tab - even if they’re empty or show zero value.

I’ve ticked show columns with empty measure values in the properties.

Quick reponse will be very much appreciated!!

jaanse (BOB member since 2011-01-24)

system · January 24, 2011, 10:46am

Hi jaanse,

select the other properties also like Show When Empty, Show Rows with empty dimension values, Show Empty Columns.

let me know this is worked or not.

Regards,
Pradeep.

av_deepu (BOB member since 2010-08-11)

system · January 24, 2011, 10:47am

Hi Pradeep,

I’ve selected all of these, but no joy.

jaanse (BOB member since 2011-01-24)

system · January 24, 2011, 10:55am

Hi Jansee,

Does your report has any blocks or report level filters?

Regards,
Pradeep.

av_deepu (BOB member since 2010-08-11)

system · January 24, 2011, 10:57am

Yes it does. But I have headers with null values which appear, yet a couple in particular don’t…?

jaanse (BOB member since 2011-01-24)

system · January 24, 2011, 10:59am

Hi Jansee,

Apply a condition to the headers like

=If(IsNull([dimension]);“Some Defalut Text”;"[dimension]")

Try this.

Regards,
Pradeep.

av_deepu (BOB member since 2010-08-11)

system · January 24, 2011, 12:19pm

Sadly that doesn’t work either.

When I try to sort the columns, it’s there in the custom sort window but doesn’t appear in the report??

Is there a way of forcing all to come in regardless of whats on the other axis of the cross tab?

jaanse (BOB member since 2011-01-24)

system · January 24, 2011, 1:05pm

Hi,

You are probably after this entry in the Reporter’s FAQ:

Marek Chladny (BOB member since 2003-11-27)

system · January 24, 2011, 4:55pm

Thanks for the help guys. Seems to be a quirk in the system.

I tried rebuilding the cross tab in the same report and it seemed to work ok second time.

jaanse (BOB member since 2011-01-24)