Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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: 496 | Registered: January 04, 2008Report This Post
<Kathryn Henning>
posted
Hi Matt,

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

Thanks and regards,

Kathryn
 
Report 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: 496 | Registered: January 04, 2008Report 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
 
Report This Post
Guru
posted Hide Post
My Reporting Server release is

8008M
Gen 157


WebFOCUS 8.1.05
 
Posts: 496 | Registered: January 04, 2008Report 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
 
Report 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: 496 | Registered: January 04, 2008Report 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 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report 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: 496 | Registered: January 04, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders