 |
|||||
|
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
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Compound Compound Reports | Login/Join |
| Member |
I have several reports that are compound documents. They all start off by getting data from an SQL database and then they populate reports based on that data. The "individual" reports are made up of several FEXs that end up as a PDF. I'd like to combine all of these reports together so that I can run just one FEX and have the full PDF, but I can't seem to get the syntax right to do a compound compound document. Some might be thinking - why not just do one giant compound report, but i'd have to redo a fair amount of work to in order to fix things so I don't have a dozen "page 1" headers, etc. any ideas? WebFOCUS 7.6.5 | ||
|
| Expert |
My guess is you can't do a "compound compound report" - the close compound command will close the whole report. I'm not up to speed on v7.6.5, but I thought I read in one of the FocalPoint postings (or could it be just my imagination running away with me?) that you can concatenate existing PDF documents, so, perhaps, using FILEDEF you can create the individual compound reports and then concatenate them to make the final report. Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Expert |
Since you are running 765, you can use the PDF Layout Painter to do what you want. You can use a Page Master to do the page numbering for you instead of the individual reports. It is a great tool. Check it out. Since you already have fexes created, create another one and choose PDF Layout Painter as the tool. Then once inside, reference your existing fexes as external reports. Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Virtuoso |
I also tried this a while back and it just didn't work out. I don't have the newest Layout painter, but 7.1 does handle the new syntax for compound reports (without page master functionality.) Your best bet is just to redo it in the PDF Layout, referencing your existing focexecs, and letting it handle things like page numbers. Let us know if you figure something out. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Member |
Thanks for the comments. I'll try the PDF Layout Printer. It's new to me (I was on 7.1 until about two weeks ago). WebFOCUS 7.6.5 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |