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
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