Ok, I have been struggling with this for months and no one has been able to help me. I have this report that uses ACROSS COLUMNS.

Now the report uses a where statement... where SPACETYPE= TYPE1 or TYPE2 or TYPE3.

Under those types are ARE OCC and DNS. DNS is a computed column. DNS is only valid for TYPE2. Base don the way the Report painter and apparently WEBFOCUS, DNS has to show up under TYPE1 and TYPE3 even though the rows are blank. This takes up much needed page width unnecessarily.

The report outputs to Excel. I can hard code the width on the useless DNS columns, but that presents another issue. Because the report is regionalized. Not all regions have TYPE1 and/or TYPE3 so the report may come out with just TYPE2 and TYPE 3 which would throw off the hard coded column widths. Is there a way to force all of the columns to show even if there is no accompanied data?

No only that, the customer doesn't want them shown in alphabetical order so is there anyway to get the ACROSS columns to print TYPE2 TYPE1 TYPE3?

i know this is a lot, but this report has way too many complications and I'm just not advanced or even work with WEBFOCUS enough to know definitive answers about what it can do.

ANY help will be greatly appreciated!

Here is a way to order the ACROSS:
DEFINE FILE CAR
COUNTRY_ORD/I2= DECODE COUNTRY('ENGLAND' 1 'FRANCE' 3 'ITALY' 2 'JAPAN' 5 'W GERMANY' 4);
END
-RUN

TABLE FILE CAR
SUM
RETAIL_COST
ACROSS COUNTRY_ORD NOPRINT
ACROSS COUNTRY
BY CAR
END
-RUN

This message has been edited. Last edited by: <Mabel>,

Here is a way to control the order of the ACROSS columns as well as force the column to appear even if there is no data.

TABLE FILE CAR
SUM RETAIL_COST
BY CAR
ACROSS COUNTRY
COLUMNS 'FRANCE'
AND 'ITALY'
AND 'JAPAN'
AND 'W GERMANY'
AND 'ENGLAND'
AND 'ELSEWHERE'
END

quote:

Originally posted by Piipster:
[qb] Here is a way to control the order of the ACROSS columns as well as force the column to appear even if there is no data.

TABLE FILE CAR
SUM RETAIL_COST
BY CAR
ACROSS COUNTRY
COLUMNS 'FRANCE'
AND 'ITALY'
AND 'JAPAN'
AND 'W GERMANY'
AND 'ENGLAND'
AND 'ELSEWHERE'
END [/qb]

Ok, this sort of worked. It worked in the sense that it ordered and forced. However, I have columns that have to come after the across. Unfortunately, WBEFOCUS doesn't understand anything after the columns statement. If I use the end, nothign else (like the styling and output format) are understood.

quote:

Originally posted by CurtisA:
[qb] Here is a way to order the ACROSS:
DEFINE FILE CAR
COUNTRY_ORD/I2= DECODE COUNTRY('ENGLAND' 1 'FRANCE' 3 'ITALY' 2 'JAPAN' 5 'W GERMANY' 4);
END
-RUN

TABLE FILE CAR
SUM
RETAIL_COST
ACROSS COUNTRY_ORD NOPRINT
ACROSS COUNTRY
BY CAR
END
-RUN[/code][/qb]

This worked like a charm! Thanks to both of you for your help!

This message has been edited. Last edited by: <Mabel>,