Suppress Cross Column
Posted: Tue Sep 22, 2009 5:42 am
Hai,
In my table i have days,Triptype,Count(TimeIn),Count(TimeOut) fields.
It has values like;
Days- 1,2,3,4,5,.......................30 (days of month, doesn't have null values)------------------Cross-Row
TripType- One way Trip, Two way trip and also has null values------------------------------------Cross-Column
Similarly other 2 fields has values and also null.------------------------------------------Summary fields
Problem is in cross tab report; Cross Column field Trip Type shows an empty column for null values.
Is it possible to hide the empty cross column
Regards
Jay
In my table i have days,Triptype,Count(TimeIn),Count(TimeOut) fields.
It has values like;
Days- 1,2,3,4,5,.......................30 (days of month, doesn't have null values)------------------Cross-Row
TripType- One way Trip, Two way trip and also has null values------------------------------------Cross-Column
Similarly other 2 fields has values and also null.------------------------------------------Summary fields
Problem is in cross tab report; Cross Column field Trip Type shows an empty column for null values.
Is it possible to hide the empty cross column
Regards
Jay