Hi,

Below is a sample code of a report that I'm trying to produce with a COMPUTE using the columns after the ACROSS.
But once I do that, the columns get all mis-aligned and the OVER column titles does not display.

Has anyone encountered this problem before?

TABLE FILE CAR
WHERE BODYTYPE EQ 'COUPE' OR 'ROADSTER' OR 'SEDAN'
SUM
SALES OVER
DEALER_COST OVER
RETAIL_COST
BY CAR
ACROSS BODYTYPE
-* I want to do some calculations with the columns and display it after the across for each car type
-*COMPUTE ASDF/D12.2 = (C1+C3+C6+C9)/C9*100;
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END



Thanks in advance.

Best Regards,

Jimmy Pang

This message has been edited. Last edited by: fatboyjim,

Hi,

You could try using

TABLE FILE CAR
WHERE BODYTYPE EQ 'COUPE' OR 'ROADSTER' OR 'SEDAN'
SUM
SALES
DEALER_COST
RETAIL_COST
BY CAR
ACROSS BODYTYPE
COMPUTE TOTAL/D12.2 = (C1+C3+C6+C9)/C9*100;
END

This will create one total column. I'm not sure what you mean by car type, is it for each CAR or for each BODYTYPE?

The OVER commands are messing up the report layout. I don't think OVER and ACROSS play well together.

Thanks for your quick response Frans.

What I meant was for each Car (eg. ALFA ROMEO, AUDI, BMW, etc).

It is now aligned for the COMPUTE column after the ACROSS, but is there a way to have the SALES, DEALER_COST, and RETAIL_COST display vertially per CAR and BODY TYPE

eg. with arbitrary data

BODYTYPE
CAR COUPE SEDAN CALCFIELD
AUDI SALES 12300 15000 33.15
DEALER_COST 12545 25333
RETAIL_COST 12121 30000

quote:

Originally posted by Francis Mariani:
The OVER commands are messing up the report layout. I don't think OVER and ACROSS play well together.

Thanks, but the weird part is that the code works in mainframe focus and the column titles align properly.

It was until I put the program into webfocus that this error occur.

I see what you mean, the COMPUTE TOTAL is messing up the layout. Seems like a bug to me.

Had time to play a little, I think it is definitely a mainframe versus web issue, this gives a report of sorts, but is the caluclated figure valid, I didn't check?

TABLE FILE CAR
WHERE BODYTYPE EQ 'COUPE' OR 'ROADSTER' OR 'SEDAN'
SUM SALES NOPRINT
DEALER_COST NOPRINT
RETAIL_COST NOPRINT
ACROSS BODYTYPE NOPRINT
BY CAR 
SUM 
SALES  OVER
DEALER_COST  OVER
RETAIL_COST  
ACROSS BODYTYPE
BY CAR
COMPUTE ASDF/D12.2 = (C1 + C2 + C3)/ (C3 * 100);
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END
  

Hi Leah,

Thanks for your input.

The solution you gave solves alignment problem.

The calculation is correct too, but the calculated value is now at the bottom of each car, and not the next column after the ACROSS.

Best Regards,

Jimmy Pang

Thank you all for your help/suggestions.

I was able to use the alternative, by removing the OVER from the report.

Although it doesn't display the OVER feature, at least the columns are aligned and the COMPUTE fields are displaying correctly.

Thanks again for your help.