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     [CLOSED] Compound Excel and Graph file Issue

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Compound Excel and Graph file Issue
 Login/Join
 
Member
posted
I have a question in regards to using the compound Excel feature in Webfocus.

Here is some code that works with the car file and does essentially what I want it to. It allows for multiple tab Excel files as well as inserting two graphs into the same tab in Excel. It allows me to embed and not float two graph files (gif) into the same Excel Tab. The problem is that the graphs are right on top of each other. Is there a way to position the gif file in an excel tab so I can see both graphs side by side or right underneath each other. I suspect that it must be controlled somehow in the Stylesheet section of the fex but anytime I try to change it to anything other than 'TYPE=REPORT,...' I get an error.

The customer wants one tab in Excel with nine separate graphs, side by side, and they want to be able to see the graphs without being connected to the internet in the excel file. This is the reason that I can't just store the graph files on the server and then call them when the Excel file is opened. They need to be embedded in the Excel file. This code does this but it won't let me position the graphs in the Excel tab. It just stacks them in the Top Left corner of the Excel tab.

Any help would be greatly appreciated.

Keith


COMPOUND LAYOUT PCHOLD FORMAT EXL2K
SECTION=section1,LAYOUT=ON,ORIENTATION=PORTRAIT,PAGESIZE=Letter, $
PAGELAYOUT=1, $
COMPONENT = 'HOLD1',$
COMPONENT = 'HOLD2',$
END

SET COMPONENT='HOLD1'

GRAPH FILE CAR
SUM
SALES
BY COUNTRY
ON GRAPH HOLD AS GIF1 FORMAT GIF
ON GRAPH SET STYLE *
SQUEEZE=ON, ORIENTATION=PORTRAIT, $
TYPE=REPORT, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10, $
ENDSTYLE
END

TABLE FILE CAR
SUM
SALES NOPRINT
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT,IMAGE=GIF1.GIF,$
TYPE=REPORT,IMAGE=GIF2.GIF,$
ENDSTYLE
END



SET COMPONENT='HOLD2'

GRAPH FILE CAR
SUM
SALES
BY CAR
ON GRAPH HOLD AS GIF2 FORMAT GIF
ON GRAPH SET STYLE *
SQUEEZE=ON, ORIENTATION=PORTRAIT, $
TYPE=HEADING, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10, $
ENDSTYLE
END


TABLE FILE CAR
SUM
SALES NOPRINT
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT,IMAGE=GIF2.GIF,$
ENDSTYLE
END


COMPOUND END

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


WebFOCUS 8.104
Windows, All Outputs
 
Posts: 28 | Location: Holland, MI USA | Registered: September 30, 2010Report This Post
Master
posted Hide Post
The only thing I can think of is to do a template. Store your graphs to specific locations and call them into the template file and then create your spreadsheet in sheet2


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report 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     [CLOSED] Compound Excel and Graph file Issue

Copyright © 1996-2020 Information Builders