![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Member |
I am working on a compound PPTX report that contains multiple pages, graphs, tables, etc... I also need to add a blank table (with font background colors) and a blank text box for some of the pages for user input (Some of the data that needs to be on this report cannot be automated and has to be put in manually by other departments). Is there a way to do this? If there isn't, can someone point me to a good guide on how to use PPTX templates? I tried making a simple blank template with both new .potx and the old .pot file types. Trying to upload them to EDASERVE failed as WebFOCUS said neither .potx nor .pot are supported file types. Thank you.This message has been edited. Last edited by: Tamra, WebFOCUS 8.0.0.9 Windows 7 | ||
|
Guru |
Hi Konstantin, Welcome to Focal Point. The following are a few links that should provide you with the information you are looking for. At least get you started. Using PowerPoint Templates Using PowerPoint Output Format and PowerPoint Templates We also ask that you update the subject line with keywords to help all Focal Pointers communicate and find information a little easier. Tag your topic with keywords Thank you for participating in the Focal Point Forum. Kindest regards, Tamra Colangelo Focal Point Moderator - Information Builders Inc. * Summit 2016 – June 13-17 in Reno, Nevada - http://www.informationbuilders.com/events/summit WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5 | |||
|
Member |
Thank you for the reply Tamra, unfortunately those links provide no help to creating PowerPoint templates or PowerPoint reports from a template. WebFOCUS 8.0.0.9 Windows 7 | |||
|
Virtuoso |
You should be able to create a multi page document using InfoAssist. For those slides that require space for user notes, you can insert a Text Box and style it anyway you want. To add a new page (slide) click the drop down all the way to the right of the Document where it says Page 1. You can add New Page and insert whatever you require. Below is a very rough draft of something like that. ENGINE INT CACHE SET ON SET PAGE-NUM=NOLEAD SET EMPTYREPORT=ON COMPOUND LAYOUT PCHOLD FORMAT PPTX SECTION=Section_1, LAYOUT=ON, PAGESIZE=LETTER, ORIENTATION=PORTRAIT, SHOW_GLOBALFILTER=OFF, $ PAGELAYOUT=1, NAME='Page 1', TEXT='Page 1', LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.25, BOTTOMMARGIN=0.25, $ OBJECT=STRING, NAME=Text_1, POSITION=(1.041666 0.604166), MARKUP=ON, TEXT='<left><font face="Trebuchet MS"><font color=#424649>ENTER DATA LINE 1:</font></font><left><BR><font face="Trebuchet MS"><font color=#424649><BR></font></font><left><BR><font face="Trebuchet MS"><font color=#424649>ENTER DATA LINE 2:</font></font><left><BR><font face="Trebuchet MS"><font color=#424649><BR></font></font><left><BR><font face="Trebuchet MS"><font color=#424649>ENTER DATA LINE 3:</font></font>', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(6.65625 3.625), $ COMPONENT=dummyReportName1, TYPE=REPORT, POSITION=(0 0), DIMENSION=(0 0), $ PAGELAYOUT=2, NAME='Page 2', TEXT='Page 2', LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.25, BOTTOMMARGIN=0.25, $ COMPONENT=Table_1, COMPONENT-TYPE=REPORT, POSITION=(1.041666 1.041666), DIMENSION=(* *), ARREPORTSIZE=DIMENSION, METADATA='VERSION:1.0;WIDTH:4.0;HEIGHT:3.0;LEFT:1.041666;TOP:1.041666', $ PAGELAYOUT=3, NAME='Page 3', TEXT='Page 3', LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.25, BOTTOMMARGIN=0.25, $ OBJECT=STRING, NAME=Text_2, POSITION=(0.5 1.0), MARKUP=ON, TEXT='<left><font face="Trebuchet MS"><font color=#424649>Annotation:</font></font>', FONT=ARIAL, SIZE=12, COLOR=RGB(0 0 0), WRAP=ON, DIMENSION=(6.645833 1.666666), $ COMPONENT=dummyReportName2, TYPE=REPORT, POSITION=(0 0), DIMENSION=(0 0), $ END SET COMPONENT=dummyReportName1 TABLE FILE SYSCOLUM " " SUM TBNAME NOPRINT IF READLIMIT EQ 1 ON TABLE SET PAGE-NUM NOLEAD ON TABLE PCHOLD FORMAT PDF ON TABLE SET EMPTYREPORT ON ON TABLE SET PREVIEW 10 ON TABLE SET STYLE * END SET COMPONENT=Table_1 -*component_type report -DEFAULTH &WF_SUMMARY='Summary'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; TABLE FILE CAR SUM CAR.BODY.DEALER_COST CAR.BODY.RETAIL_COST BY CAR.ORIGIN.COUNTRY BY CAR.COMP.CAR ON TABLE NOTOTAL ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET SQUEEZE ON ON TABLE SET EMPTYREPORT ON ON TABLE SET HTMLCSS ON ON TABLE SET HTMLENCODE ON ON TABLE SET CACHELINES 100 ON TABLE SET STYLE * $ TYPE=REPORT, TITLETEXT='Report2', SUMMARY=&WF_SUMMARY.QUOTEDSTRING, $ ENDSTYLE END SET COMPONENT=dummyReportName2 TABLE FILE SYSCOLUM " " SUM TBNAME NOPRINT IF READLIMIT EQ 1 ON TABLE SET PAGE-NUM NOLEAD ON TABLE PCHOLD FORMAT PDF ON TABLE SET EMPTYREPORT ON ON TABLE SET PREVIEW 10 ON TABLE SET STYLE * END COMPOUND END WebFOCUS 8206, Unix, Windows | |||
|
Member |
Thank you BabakNYC, I have tried that. The question is not about creating labels. I can do that easily enough. What I am looking to do is create blank text boxes in PowerPoint that are in the correct location, have a specific font type and size pre-set, the text area being set to automatically expand with text, etc... So that all the user needs to do is click within this text area and put in their content. I was able to find no way to do it with FOCUS code, so I think the only way to do it is to use a PowerPoint template and output the report using this template. But I cannot find any documentation on using PowerPoint templates with WebFOCUS. Hopefully that clarifies my question. Once again, thank you. WebFOCUS 8.0.0.9 Windows 7 | |||
|
Virtuoso |
It appears in the Text Box Font color and size are maintained in PPTX but the size of the box is a different story. Sorry I've never used the template feature. WebFOCUS 8206, Unix, Windows | |||
|
Guru |
Konstantin, The following is a better resource for applying PPT templates to WebFOCUS reports. The other links in my previous update were HTML related - sorry about that. Using PowerPoint Output Format and PowerPoint Templates Here is the link to the PPT Template information within the Reporting Manual. Examples of code are also included. Your TEXT box will need to be added into the template somehow and then the template added to the report. Creating Reports With WebFOCUS Language Page: 679 - 684 Here are few other links that might be helpful for adapting PPT template to the report. Here are steps for adding a template using AppStudio How to get multiple reports on 1 slide via PPT Template This links talks about adding items to the master slide within the template that is used by the WebFOCUS report. Can Power Point Templates respecting timings in WebFOCUS? Thank you for participating in the Focal Point Forum. Kindest regards, Tamra Colangelo Focal Point Moderator - Information Builders Inc. * Summit 2016 – June 13-17 in Reno, Nevada - http://www.informationbuilders.com/events/summit WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5 | |||
|
Member |
Thank you Tamra, this helped me solve my issues. WebFOCUS 8.0.0.9 Windows 7 | |||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|