Focal Point Banner


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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Report Caster Dynamic Distibution with Burst on a Compound Document

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Report Caster Dynamic Distibution with Burst on a Compound Document
 Login/Join
 
Member
posted
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,


WF767, WinServ2003, SQLServ2000
HTML
 
Posts: 25 | Registered: March 17, 2009Report This Post
Expert
posted Hide Post
Documentation

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.




Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Member
posted Hide Post
I am not using Excel compound reports but I guess that covers any compound report... I guess.

Thanks for the reply.


WF767, WinServ2003, SQLServ2000
HTML
 
Posts: 25 | Registered: March 17, 2009Report This Post
Expert
posted Hide Post
Well, Read the Documentation. It's not that it can't be done, it can...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Member
posted Hide Post
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,


WF767, WinServ2003, SQLServ2000
HTML
 
Posts: 25 | Registered: March 17, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Report Caster Dynamic Distibution with Burst on a Compound Document

Copyright © 1996-2020 Information Builders