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 email@example.com for further assistance. Reference the community FAQ to learn more about the community.
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.
COMPOUND LAYOUT PCHOLD FORMAT EXL2K SECTION=section1,LAYOUT=ON,ORIENTATION=PORTRAIT,PAGESIZE=Letter, $ PAGELAYOUT=1, $ COMPONENT = 'HOLD1',$ COMPONENT = 'HOLD2',$ END
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
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 ENDThis message has been edited. Last edited by: Kerry,
WebFOCUS 8.104 Windows, All Outputs
Posts: 28 | Location: Holland, MI USA | Registered: September 30, 2010