Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

formating cross-tabs

Status
Not open for further replies.

uksub

Programmer
Jun 15, 2003
51
US
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

 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top