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     How to Schedule Compound Excel report having Multiple worksheets thru Report Caster

Read-Only Read-Only Topic
Go
Search
Notify
Tools
How to Schedule Compound Excel report having Multiple worksheets thru Report Caster
 Login/Join
 
Gold member
posted
Hi,Kindly see the below sample code displaying excel report in multiple worksheet
1st worksheet contains the result of table output
2nd worksheet contains the graph

-SET &ECHO = ALL;

SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT EXL2K
UNITS=IN, $
SECTION=section1,
LAYOUT=ON,
ORIENTATION=PORTRAIT,
PAGESIZE=Letter, $
PAGELAYOUT=1, $
COMPONENT='REPORT1', $
COMPONENT='HOLD1', $
END

SET TEMPERASE = OFF

SET COMPONENT='REPORT1'
TABLE FILE CAR
SUM
SALES
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K
END

SET COMPONENT='HOLD1'
GRAPH FILE CAR
SUM
SALES
BY COUNTRY
ON GRAPH HOLD AS GIF1 FORMAT GIF
ON GRAPH SET STYLE *
SQUEEZE=ON, ORIENTATION=PORTRAIT, $
TYPE=REPORT, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10, $
ENDSTYLE
END

TABLE FILE CAR
SUM
SALES NOPRINT
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT, IMAGE=GIF1.GIF,$
ENDSTYLE
END

COMPOUND END


Error :
SET DISTRIBUTE=OFF
INVALID DISTRIBUTION FORMAT FOR COMPOUND REPORT
Compound Report is TERMINATING.....
Task error: INVALID DISTRIBUTION FORMAT FOR COMPOUND REPORT
No report to distribute.

Kindly provide me a solution to schedule compound excel reports having Multiple worksheets


WebFocus Version 7.7.05
Windows, HTML/PDF/EXL2K/AHTML
 
Posts: 63 | Registered: January 12, 2011Report This Post
Gold member
posted Hide Post
The graph is created and then inserted in to Excel as an image. Runs fine until I try to schedule and run thru ReportCaster...


WebFocus Version 7.7.05
Windows, HTML/PDF/EXL2K/AHTML
 
Posts: 63 | Registered: January 12, 2011Report This Post
Platinum Member
posted Hide Post
Are you trying to burst the report or just send out the entire book to a distribution list?


Kathy Phillips
Web FOCUS 8.2.05.14, 8.1.05, 8.08, 8.0.7, 8.0.5,8.0.2m, 7.6.10,7.7.03
Windows
 
Posts: 118 | Location: Livonia, MI | Registered: March 27, 2009Report This Post
Gold member
posted Hide Post
I am sending the entire book to the distribution list and not bursting the report...


WebFocus Version 7.7.05
Windows, HTML/PDF/EXL2K/AHTML
 
Posts: 63 | Registered: January 12, 2011Report This Post
<JJI>
posted
Hi,

Perhaps reading this document could help you.
Read the part "Distributing a Graph Image in a PDF Report" in appendix C page 504.

Hope this helps you solving the problem.
 
Report This Post
Gold member
posted Hide Post
If compound excel reports contains graph,then still not able to schedule them.Its getting scheduled if it doesn't have graph.

Since to have graph in excel report, the code is different and using COMPOUND LAYOUT PCHOLD FORMAT EXL2K and so on.

But for normal compound excel report, we use
ON TABLE PCHOLD FORMAT EXL2K OPEN


WebFocus Version 7.7.05
Windows, HTML/PDF/EXL2K/AHTML
 
Posts: 63 | Registered: January 12, 2011Report This Post
Silver Member
posted Hide Post
One of the error messages is
quote:
INVALID DISTRIBUTION FORMAT FOR COMPOUND REPORT

What format are you selecting in the ReportCaster scheduling tool when you create the schedule? The default is HTML. If you do not change the default to EXL2K in the scheduling UI then it will try to create the report in HTML. HTML is invalid for compound reports (you would need to select DHTML).


WebFOCUS All Releases
 
Posts: 45 | Location: NYC | Registered: September 21, 2007Report This Post
Gold member
posted Hide Post
I am selecting EXL2K format in the ReportCaster scheduling tool.

Is it the limitation of tool for excel compound reports with graph getting scheduled?


WebFocus Version 7.7.05
Windows, HTML/PDF/EXL2K/AHTML
 
Posts: 63 | Registered: January 12, 2011Report 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     How to Schedule Compound Excel report having Multiple worksheets thru Report Caster

Copyright © 1996-2020 Information Builders