formating cross-tabs

[uksub]

How do you make the columns of a cross-tab fixed? Say for example... Company column field consist of 5 company's. If company for does'nt have any data... how do i make it show up with just 0's for blanks. I have two cross tabs on the report and i'd like have the columns remained on the report regardless of whether there is any data for the field.
Example.


cross tab1| comp1 comp2 comp3 comp5
33 44 33 55
cross tab2| comp1 comp2 comp3 comp4 comp5
44 33 13 34 33

what i want is:

cross tab1| comp1 comp2 comp3 comp4 comp5
99 343 34 34

cross tab2| comp1 comp2 comp3 comp4 comp5
13 34 44 44 44

 

[fredp1]

The way I'v approached this problem is to create a manual cross tab report.
Basically use have 5 variables, 1 for each company.
//comp1 variable
if company = 'comp1' then value else 0

//comp2 variable
if company = 'comp2' then value else 0
etc.
then format each variable to by, format field, number, customise, suppress if zero.(right click on the field)

Place the variables in the detail section, then in you report footer, summarise your variables to show the totals.

Fred