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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
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,
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
Posts: 2410 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013