I am facing a problem in SQUEEZE while using COURIER Font for my PDF Report.

Even though the Column shows enough space for the values to get displayed, The SQUEEZE gets applied on the Values instead of colun width.

This happens only with the Numiric that are converted to ALPHA numeric. Works fine with Numeric values.

Where in ARIAL doesnt create much problem in this area.

COURIER expects a bigger SQUEEZE number for Every column to show entire value, which makes me hard to align a 30 column report with in a 'A4' landscape page...

  
DEFINE FILE CAR
DEALER_COST/D10c = DEALER_COST;
DEALER_COSTMAL/A12= FTOA(DEALER_COST,'(D10c)','A10');
END

TABLE FILE CAR
PRINT
  DEALER_COSTMAL AS COURIER,DEAL
  DEALER_COSTMAL AS ARIAL,DEAL 
  DEALER_COSTMAL AS COUR,LESS,DEAL
  DEALER_COSTMAL AS ARIAL,LESS,DEAL 
  DEALER_COST AS COUR,NUM,DEAL

ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='A4',
     ORIENTATION=LANDSCAPE,$
TYPE=REPORT,
     GRID=OFF,
     SIZE=7,
     COLOR='BLACK',
     SQUEEZE=ON,
     BORDER=LIGHT,
     BORDER-COLOR=RGB(127 127 127),
$

TYPE=REPORT,     COLUMN=N1,    FONT='COURIER', SQUEEZE=.589111,COLOR=GREEN,$
TYPE=REPORT,     COLUMN=N2,    FONT='ARIAL',   SQUEEZE=0.419111,COLOR=BLUE, $
TYPE=REPORT,     COLUMN=N3,    FONT='COURIER', SQUEEZE=0.579111,COLOR=GREEN,$
TYPE=REPORT,     COLUMN=N4,    FONT='ARIAL',   SQUEEZE=0.419111,COLOR=BLUE,$
TYPE=REPORT,     COLUMN=N5,    FONT='COURIER', SQUEEZE=0.309111,COLOR=GREEN,$



ENDSTYLE
END
-RUN
-EXIT

Any suggestions on this is much welcome....

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

Try your defined field as:

DEALER_COSTMAL/A14 = LJUST(14,FTOA(DEALER_COST,'(D10c)','A14'),'A14');

You have to take into account that FTOA will need extra positions to commas, dots and minus signs, plus that it stores the converted number right aligned - thereby sort of bypassing the squeeze option, which works only on right side trailing blank space.

Thanks Gamp for the info.
I will try this.

Or try your defined field as::

DEALER_COSTMAL/A12= SQUEEZ(12, FTOA(DEALER_COST,'(D10c)','A10'), 'A12');

and remove all the SQUEEZE= from your stylesheet

-Fred-

That worked Great...

Thanks Gamp and Freste.