Hello

I'm trying to figure out why my column titles appear to be wrapping when there is no reason to.
In developer preview it looks fine, but when I run it and view the PDF the title wraps to a new line leaving a large space between the Title Text data

What I expect

Product
Accident
Universal Life


What I get

Product

Accident
Universal Life


I've played with SQUEEZE and WRAP, but I haven't found anything that works.
I know HTML is entirely different, but outputting in that format doesn't have this problem

 
TABLE FILE TMPSALESDTL
BY  TMPSALESDTL.TMPSALES.PRODUCTNM
ON TABLE SUBHEAD
"&RPTHEADER1"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SET LAYOUTGRID OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=REPORT,
     LINES-PER-PAGE=UNLIMITED,
     ARGRAPHENGINE=JSCHART,
     CALC-LOCATION=TOP,
     ALLOW-CALC=OFF,
     ALLOW-HIDE=OFF,
     ALLOW-CHART=OFF,
     ALLOW-VISUALIZE=OFF,
     ALLOW-SORT=OFF,
     ALLOW-ROLLUP=OFF,
     ALLOW-PIVOT=OFF,
     ALLOW-COMMENTS=OFF,
     ALLOW-SENDEMAIL=OFF,
     ALLOW-SAVECHANGE=OFF,
$
TYPE=REPORT,
     OBJECT=STATUS-AREA,
     JUSTIFY=LEFT,
     PAGE-LOCATION=BOTTOM,
$
TYPE=REPORT,
     COLUMN=N1,
     SQUEEZE=2.0,
	 WRAP=OFF,
$
TYPE=TITLE,
     COLUMN=N1,
     STYLE=UNDERLINE,
	 WRAP=OFF,
$
ENDSTYLE
END 

This message has been edited. Last edited by: Dan Paxson,

Hi Dan,

You have:

TYPE=TITLE,
     COLUMN=N1,
     STYLE=UNDERLINE,
     WRAP=OFF,
$

That should put an underline to TMPSALESDTL.TMPSALES.PRODUCTNM title.

Also, you have:

ON TABLE SUBHEAD
"&RPTHEADER1"

Which create a space between the column title and the sub-header but not with the data.

Using your code but with IBI CAR file:

TABLE FILE CAR
BY  CAR
ON TABLE SUBHEAD
"A SUB-HEAD"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SET LAYOUTGRID OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=REPORT,
     LINES-PER-PAGE=UNLIMITED,
     ARGRAPHENGINE=JSCHART,
     CALC-LOCATION=TOP,
     ALLOW-CALC=OFF,
     ALLOW-HIDE=OFF,
     ALLOW-CHART=OFF,
     ALLOW-VISUALIZE=OFF,
     ALLOW-SORT=OFF,
     ALLOW-ROLLUP=OFF,
     ALLOW-PIVOT=OFF,
     ALLOW-COMMENTS=OFF,
     ALLOW-SENDEMAIL=OFF,
     ALLOW-SAVECHANGE=OFF,
$
TYPE=REPORT,
     OBJECT=STATUS-AREA,
     JUSTIFY=LEFT,
     PAGE-LOCATION=BOTTOM,
$
TYPE=REPORT,
     COLUMN=N1,
     SQUEEZE=2.0,
	 WRAP=OFF,
$
TYPE=TITLE,
     COLUMN=N1,
     STYLE=UNDERLINE,
     WRAP=OFF,
$
ENDSTYLE
END 

Here is the what the result look like:

A SUB-HEAD 
  
CAR
---
ALFA ROMEO 
AUDI 
BMW 
DATSUN 
JAGUAR 
JENSEN 
MASERATI 
PEUGEOT 
TOYOTA 
TRIUMPH 

So I can't find where you can have a blank line between "Product" and "Accident".
Does "Product" is the column title ?

Thanks for the help.
Here are the results using the code below



I found the answer here

This is the code that removes the extra line under the column titles

 ON TABLE SET TITLELINE SKIP 

But AS errors when using GUI. It may have been deprecated?

New method that I could not find using the GUI

 TYPE=REPORT, TITLELINE=ON,$  

  
TABLE FILE IBISAMP/CAR
BY  CAR.COMP.CAR
ON TABLE SUBHEAD
"A SUB-HEAD"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SET LAYOUTGRID OFF
ON TABLE SET TITLELINE SKIP
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=REPORT,
     LINES-PER-PAGE=UNLIMITED,
     ARGRAPHENGINE=JSCHART,
     CALC-LOCATION=TOP,
     ALLOW-CALC=OFF,
     ALLOW-HIDE=OFF,
     ALLOW-CHART=OFF,
     ALLOW-VISUALIZE=OFF,
     ALLOW-SORT=OFF,
     ALLOW-ROLLUP=OFF,
     ALLOW-PIVOT=OFF,
     ALLOW-COMMENTS=OFF,
     ALLOW-SENDEMAIL=OFF,
     ALLOW-SAVECHANGE=OFF,
$
TYPE=REPORT,
     OBJECT=STATUS-AREA,
     JUSTIFY=LEFT,
     PAGE-LOCATION=BOTTOM,
$
TYPE=REPORT,
     COLUMN=N1,
     SQUEEZE=2.000000,
$
ENDSTYLE
END