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,

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.

I am not using Excel compound reports but I guess that covers any compound report... I guess.

Thanks for the reply.

Well, Read the Documentation. It's not that it can't be done, it can...

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,