Hello, I have a program that is generating multiple sheets in EXCEL. In the program (using Text Editor), I use EXL2K OPEN for the first TABLE and then the last one EXL2K CLOSE. When I attempt to set up a schedule through ReportCaster, it generates an error. However, if I set it up with one of the TABLES and take off the EXL2K OPEN to just EXL2K then it works. Can you assist so that all the tabs can be generated using Report Caster? Thank you.This message has been edited. Last edited by: Tamra,
WebFOCUS 8 Windows, All Outputs
June 14, 2017, 02:28 PM
MartinY
Do you have the following ?
SET EXCELSERVURL = ''
Also, I'm not 100% sure but I think that using EXL2K OPEN/CLOSE with Report Caster doesn't work. Reason why I either used : a) XLSX (Excel2007) format with a template where each "report" is assigned to its own tab b) EXL2K format with : ON TABLE SET COMPOUND BYTOC
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
June 14, 2017, 05:32 PM
jcannavo
Do you have any error details?
JC WebFOCUS Dev Studio / App Studio 8.2.01 Windows 7
June 15, 2017, 10:01 AM
Joanna Swiggett
Try checking the Override the Format box in the Task tab.