Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]WF 8201 ReportCaster Multi-tab Excel Schedule
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]WF 8201 ReportCaster Multi-tab Excel Schedule
 Login/Join
 
Platinum Member
posted
I created, in App Studio, a ReportCaster multi-tab Excel report. The report is for ytd and monthly data. I first created a hold file with ytd data. I next table filed the hold file to produce the ytd report using ON TABLE PCHOLD FORMAT &WFFMT OPEN with a stylesheet TYPE=REPORT, TITLETEXT='YTD',$. Lastly, I table filed the same hold file and added a WHERE clause to extract monthly data using ON TABLE PCHOLD FORMAT &WFFMT CLOSE with a stylesheet TYPE=REPORT, TITLETEXT='Monthly',$.

ReportCaster produced two separate reports instead of one multi-tab report. ReportCaster put the same default tab name on the first tab of each report that contained part of the schedule name; ignoring the stylesheet TITLETEXT in the FEX.

How can I get a single multi-tab Excel report with the title names on each tab. Thanks.

All I needed to do was to uncheck the BURST button in the Task menu.

This message has been edited. Last edited by: Michele Brooks,


WF 8201, Windows 7
Oracle DBMS
EXL07/PDF Output
 
Posts: 242 | Registered: August 27, 2012Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]WF 8201 ReportCaster Multi-tab Excel Schedule

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.