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.
I tried using RC's Dynamic Distribution with burst using a procedure to create the table containing the VALUE and DEST columns. But it doesn't work when I use it on a compound document. It works fine on a regular report though.
Is there a way to work around this or is this a current limitation on Report Caster? Or is it just a limitation on our version?This message has been edited. Last edited by: Kerry,
Look at 13C, Manually Coded EXCEL Compound Reports, and, the NOTE, AND, the last sentence:
Note: Excel 2002 (Office XP) or higher must be installed.
Excel Compound Reports will not work with earlier versions of Excel since they do not support
the Web Archive file format.
Bursting is not supported with Excel Compound Reports.
Manually Coded Excel Compound Reports ------------------------------------- Excel Compound Reports enables you to generate multiple worksheet reports using the EXL2K output format.
The syntax of Excel Compound Reports is identical to that of PDF Compound Reports. By default, each of the component reports from the compound report is placed in a new Excel worksheet (analogous to a new page in PDF). If the NOBREAK keyword is used, the next report follows the current report on the same worksheet (analogous to starting the report on the same page in PDF).
Output, whether sent to the client using PCHOLD or saved in a file using HOLD, is generated in Microsoft's Web Archive format. This format is labeled Single File Web Page in Excel's Save As dialog. Excel provides the conventionally given file suffixes: .mht or .mhtml. WebFOCUS uses the same .xht suffix that is used for EXL2K reports. Since the output is always a single file, it can be easily distributed using ReportCaster.
The components of an Excel compound report can be FORMULA or PIVOT reports. For more information about the Excel Compound Reports feature, see the Creating Reports With WebFOCUS Language manual.
Note: Excel 2002 (Office XP) or higher must be installed. Excel Compound Reports will not work with earlier versions of Excel since they do not support the Web Archive file format. Bursting is not supported with Excel Compound Reports.
Compound Reports and Coordinated Compound Reports ------------------------------------------------- ReportCaster can distribute compound reports developed using the Document Composer in Developer Studio in AHTML, DHTML, EXL2K, PDF, and PPT formats.
ReportCaster can burst and distribute coordinated compound reports developed using the Document Composer in Developer Studio in DHTML, PDF, and PPT formats.
Changed the compound doc and all the reports in it to PDF and still got this error message in the mail from RC.
------------------------------------------------ Message Code Message Text
BTP1010 Schedule Executed On Demand BTP1020 Starting task: Agency Monthly Transaction for Dynamic Distribution BTP1020 Task type: MR Standard Report BTP1020 Task domain: customer/customer.htm BTP1020 Retrieving MR report: app/agency_monthly_transaction_for_dynamic_distribution BTP1020 Connecting to server EDASERVE with execution id biadmin BTP1020 Executing focexec. BTP1020 0 HOLDING PDF FILE ON PC DISK ... BTP1020 Task finished. BTP1010 Dynamically creating distribution information BTP1010 No report for rc@brotherhoodmutual.com with a burst value of 59. BTP1010 No report for rc@brotherhoodmutual.com with a burst value of 140. BTP1010 No report for rc@brotherhoodmutual.com with a burst value of 407. BTP1010 No report for rc@brotherhoodmutual.com with a burst value of 446. BTP1010 No report for rc@brotherhoodmutual.com with a burst value of 466.This message has been edited. Last edited by: Kulot,