I have a scrunching problem. A handful of my subheading get scrunched when I export to EXL07. EXL2K I do not have this problem.

I did some searching, and it appears that SQUEEZE no longer works with EXL07, is that true?

I tried setting SQUEEZE=XX, and that works for HTML, but not for EXL07.

Any other suggestions?

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

Hi Matt,

In addition to SQUEEZE, does your code also contain WRAP?

Thanks and regards,

Kathryn

Yes it does

TYPE=REPORT,
     WRAP=OFF,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=&FONTSIZE,
	    HEADPANEL=ON,
&PRNTCMNT.EVAL     BOTTOMMARGIN=0,
&PRNTCMNT.EVAL     TOPMARGIN=0,
&PRNTCMNT.EVAL     RIGHTMARGIN=0,
&PRNTCMNT.EVAL     LEFTMARGIN=0,
$
 

Hi Matt,

Thank you for confirming this. There was a Project implemented in the Reporting Server release 7705M that addressed this issue with format EXL07 with SQUEEZE and WRAP. Please verify that you are using release 7705M with WebFOCUS 8008.

Thanks and regards,

Kathryn

My Reporting Server release is

8008M
Gen 157

Hi Matt,

Thank you for the information. Something other than the Project I mentioned is causing this to occur. Since we'll need to review your entire FOCEXEC and stylesheet, please open a case for this issue on InfoResponse Online.

Thanks and regards,

Kathryn

I will do that. I created an example using the car file. Can anyone else tell me using this example outputting to EXL07, does it squinch? It does it on PDF too.

 
-* File Car_Cntry.fex
SET EXCELSERVURL      = ''

TABLE FILE CAR
SUM SEATS AS ''
    DEALER_COST AS ''
    RETAIL_COST AS ''
    SALES       AS ''
    LENGTH      AS ''
    WIDTH       AS ''
    HEIGHT      AS ''
BY CAR NOPRINT
BY MODEL NOPRINT
ON CAR SUBHEAD
"<+0>Seats<+0>Dealer Cost<+0>Retail Cost<+0>Sales"

-*ON TABLE PCHOLD FORMAT EXL2K
ON TABLE PCHOLD FORMAT EXL07
-*ON TABLE PCHOLD FORMAT PDF

ON TABLE SET PAGE NOPAGE

ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
     TITLETEXT='Car_Summary',
$

TYPE=REPORT,
     WRAP=OFF,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
     HEADPANEL=ON,
$
TYPE=SUBHEAD,
     HEADALIGN=BODY,
$
TYPE=SUBHEAD,
     LINE=1,
     ITEM=2,
     COLSPAN=1,
     SIZE=10,
     STYLE=BOLD+UNDERLINE,
     JUSTIFY=RIGHT,
$
TYPE=SUBHEAD,
     LINE=1,
     ITEM=3,
     COLSPAN=1,
     SIZE=10,
     STYLE=BOLD+UNDERLINE,
     JUSTIFY=CENTER,
$
TYPE=SUBHEAD,
     LINE=1,
     ITEM=4,
     COLSPAN=1,
     SIZE=10,
     STYLE=BOLD+UNDERLINE,
     JUSTIFY=LEFT,
$
END
-RUN
 

Need to style the columns:

  
TYPE=REPORT, COLUMN=N3, SQUEEZE=.50,$
TYPE=REPORT, COLUMN=N4, SQUEEZE=.75,$
TYPE=REPORT, COLUMN=N5, SQUEEZE=.75,$
TYPE=REPORT, COLUMN=N6, SQUEEZE=.75,$
TYPE=REPORT, COLUMN=N7, SQUEEZE=.75,$
TYPE=REPORT, COLUMN=N8, SQUEEZE=.75,$
TYPE=REPORT, COLUMN=N9, SQUEEZE=.75,$

Thanks Tom!

I could have sworn that I tried that and I didn't get it to work, but now it's working correctly. I have done that in the past where I have squeezed certain columns but for some odd reason I wasn't getting it working here.

I guess sometimes you stare at something so long, it all just becomes mush.