 |
|||||
|
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 |
| Bursting Compound Report | Login/Join |
| Platinum Member |
Here's what I currently do. I have 2 report caster jobs (one creates summary reports and the other creates detail reports) for capital projects. The reports are then burst out via email to project managers. If a project manager has 10 projects, currently they will receive 2 emails - one with 10 summary reports attached and one will 10 detail reports attached. We would like to find a way to create a single compound report with summary and detail for each project and then burst the output to the project managers. It seems like you'd need to create a loop that runs the summary report and the detail report for the first project then loops back and runs the summary and detail reports for the 2nd project, etc....until all the projects are run. Any ideas??? Bethany Server Environment: Win2K3 Server WebFOCUS 7.13 DevStudio 7.14 Apache Tomcat standalone application server Server Environment: Win2K3 Server WebFOCUS 7.13 Apache Tomcat standalone application server | ||
|
| Expert |
The easy, flip answer is to upgrade to 76 which has the PDF Layout Painter. But all silliness aside, write a short report which produces a SAVE file with all the distinct projects. Then you can use this as a WHERE in your loop. But as I write this, I realize that this will not work in Report Caster which only distributes the last report run. Another idea is to combine the summary and detail reports into one, possibly using MacGyver technique such that you would be creating a single report (more efficient against the backend data source as well) that you could then burst and distribute with RC. 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 |
Bethany We do something similar. We created a compound report per account team. The report has data tables and graphs per team. The report works very well but the monthly bursting was a challenge. The basic bursting was not an option. What we did is use the function "prereport" this prereport runs and prepares the settings we need for the compound report. In the prereport we create an little file with a sequence number and the teamnames. At the start we first test if the file exists and if it is from this day. If that is the case we read the first line and use that to create some amper variables. The real looping is not managed. What we do is create 10 lines in the Reportcaster process each with a time split of 2 minutes. It runs on the first day of the month. It can be done this way since we know there are only 10 teams. I hope this helps a bit
| |||||||
|
| 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 |