Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] EXL07 Output and Subheads
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] EXL07 Output and Subheads
 Login/Join
 
Guru
posted
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,


WebFOCUS 8.1.05
 
Posts: 495 | Registered: January 04, 2008Reply With QuoteReport This Post
<Kathryn Henning>
posted
Hi Matt,

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

Thanks and regards,

Kathryn
 
Reply With QuoteReport This Post
Guru
posted Hide Post
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,
$
 


WebFOCUS 8.1.05
 
Posts: 495 | Registered: January 04, 2008Reply With QuoteReport This Post
<Kathryn Henning>
posted
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
 
Reply With QuoteReport This Post
Guru
posted Hide Post
My Reporting Server release is

8008M
Gen 157


WebFOCUS 8.1.05
 
Posts: 495 | Registered: January 04, 2008Reply With QuoteReport This Post
<Kathryn Henning>
posted
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
 
Reply With QuoteReport This Post
Guru
posted Hide Post
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
 





WebFOCUS 8.1.05
 
Posts: 495 | Registered: January 04, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
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,$


Tom Flynn
WebFOCUS 7.7.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1946 | Location: Parker, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
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.


WebFOCUS 8.1.05
 
Posts: 495 | Registered: January 04, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] EXL07 Output and Subheads

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.