I am getting a extra line when my total line print on a recompute. Is there anyway to make the output print on one line example

xxxxxxx 111111 2222222
xxxxxxx 111111 2222222
total
222222 4444444

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

There are many posts on this subject in the forum. Search for 'total one line' and you'll find a number of posts with possible solutions to this problem.

Don,

I am on 7.6.7 now and I find the following:
1. If my output is HTML then everything is on one line.
2. If my output is PDF, then it will depend whether WF can squeeze the "Total" caption into the first column.
See the example:

  
-* File SubTotalOneLine.fex
TABLE FILE CAR
PRINT 
     SALES RETAIL_COST COMPUTE RATIO=RETAIL_COST/SALES;
BY COUNTRY
ON COUNTRY RECOMPUTE 
-*ON COUNTRY RECOMPUTE AS '*'
ON COUNTRY SUBFOOT
" "
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
-*ON TABLE PCHOLD FORMAT HTML
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=ON,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
ENDSTYLE
END

Try with the different options.

It's the BY that does it. That causes the 1st column of nuumbers to be to the right of another, text, column as well.

DON: Can you reproduce it using the CAR file?

Thanks to everyone. Sometime you cannot see the forest because of all the trees.

Don R.