Hi All,

I have searched the forum and have come across quite a few threads regarding this problem, but no matter what I try, I cannot get this to work. I have a column title with a really long name so the column width in Excel ends up being really wide (whether I put the commas in the title name to wrap it or not). I cannot get WRAP or SQUEEZE to work in the style sheet (whether I put the commas in the title or not). Please help. This is so frustrating. Below, I put the scenario in the CAR file.

Thanks so much,

Krysti


TABLE FILE CAR
PRINT
COUNTRY
MODEL
CAR AS 'A REALLY, REALLY LONG, COLUMN NAME'
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.150000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.000000,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=TITLE,
COLUMN=N1,
WRAP=.25,
$
TYPE=DATA,
COLUMN=N1,
WRAP=.25,
$
TYPE=TITLE,
COLUMN=N2,
WRAP=.25,
$
TYPE=DATA,
COLUMN=N2,
WRAP=.25,
$
TYPE=TITLE,
COLUMN=N3,
WRAP=.25,
$
TYPE=DATA,
COLUMN=N3,
WRAP=.25,
$
ENDSTYLE
END

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

Try TYPE=REPORT:

-* File fmfp001.fex

TABLE FILE CAR
PRINT
COUNTRY
MODEL
CAR AS 'A REALLY, REALLY LONG, COLUMN NAME'
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.150000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.000000,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=.25,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=.25,
$
TYPE=REPORT,
COLUMN=N3,
WRAP=.25,
$
ENDSTYLE
END

Look for "Controlling Column Width and Wrapping in Excel 2000" in the "Creating Reports With WebFOCUS Language" document.

I do not believe that the WRAP or SQUEEZE syntax can be transferred to Excel, as column width is a function that is specifically managed by Excel. You could try using an Excel template or seeing if the -HTMLFORMTYPE (referenced in several postings) would afford you any added functionality. Try a search on those and see if you can find any additional useful information.

Yup. There you go. I don't use EXL2K as much so not that familiar with its use. Should have noticed, hewever, that you should be using TYPE=REPORT instead of TITLE or DATA.

This message has been edited. Last edited by: Darin Lee,

Krysti,

Please put your release in your signature. There were issues with this very thing in the early versions of 7.6.x that were fixed by 7.6.2. If you are running 7.6.1, I can get you a case number to reference.

Darin is also correct in that TYPE=REPORT is the preferred syntax.

TYPE=REPORT worked! Thank you so much. I had read everything I could find regarding this issue and never realized that was the correct syntax.

I really appreciate all your replies!

Krysti

quote:

Darin is also correct in that TYPE=REPORT is the preferred syntax.

- so is Francis.

quote:

Originally posted by GinnyJakes:
Krysti,

Please put your release in your signature. There were issues with this very thing in the early versions of 7.6.x that were fixed by 7.6.2. If you are running 7.6.1, I can get you a case number to reference.

Darin is also correct in that TYPE=REPORT is the preferred syntax.

Can we get that case number? We're converting to WF 7.6.1 and are running into this WRAP issue with a large text field that we output to PDF. Seems to wrap, but not the full width of the page like it does in WF 5 that we're coming from.

Case: 31732557

Our problem was resolved in 7.6.2.

quote:

Originally posted by Francis Mariani:
Try TYPE=REPORT:

-* File fmfp001.fex

TABLE FILE CAR
PRINT
COUNTRY
MODEL
CAR AS 'A REALLY, REALLY LONG, COLUMN NAME'
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.150000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.000000,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=.25,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=.25,
$
TYPE=REPORT,
COLUMN=N3,
WRAP=.25,
$
ENDSTYLE
END

woo hoo! This also solved my problem! I've got a report that's not very wide, and my logo at the top-left was colliding with my header. By using
TYPE=REPORT,COLUMN=N1,WRAP=X I was able to stretch my report out so the logo would fit!