I know WF 7.6 allows to create worksheets in the excel file on the mainframe. How can I do it?
I had tried to use SET COMPOUND, it didn't work.
Thanks
May
WebFOCUS 7.6.8 Servlet - MRE/BID/Self Service/ReportCaster - MS Windows Server 2003 - MS SQL Server 2005 - DataMigrator 7.6.9
May 16, 2011, 11:09 AM
Prarie
ON TABLE PCHOLD FORMAT EXL2K
did you want a compound report?This message has been edited. Last edited by: Prarie,
May 16, 2011, 11:44 AM
May
Hi,
I tried the code, but I got the error message.
A WORD IS NOT RECOGNIZED: OPEN A WORD IS NOT RECOGNIZED: CLOSE
May
WebFOCUS 7.6.8 Servlet - MRE/BID/Self Service/ReportCaster - MS Windows Server 2003 - MS SQL Server 2005 - DataMigrator 7.6.9
May 16, 2011, 12:07 PM
Prarie
TABLE FILE CAR HEADING "First Report" PRINT CAR BY CAR ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK END
TABLE FILE CAR HEADING "Second Report" PRINT COUNTRY BY COUNTRY ON TABLE PCHOLD FORMAT EXL2K CLOSE END
May 16, 2011, 01:40 PM
Francis Mariani
May did specify "mainframe" and by that I assume IBM Mainframe FOCUS. The suggested example does not work on mainframe FOCUS.
(FOC002) A WORD IS NOT RECOGNIZED: OPEN
Compound EXL2K reports are not available in FOCUS 7.3.5. Compound PDF reports are available and the example will work for PDF, but I'm not sure how you would access this PDF report when the fex is run via a mainframe job.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 16, 2011, 01:45 PM
Francis Mariani
FOCUS for Mainframe > Creating Reports > Version 7 Release 3 > Working With PostScript and PDF Reports > Creating Compound PDF or PostScript Reports
quote:
Creating Compound PDF or PostScript Reports Compound reports combine multiple reports into a single PDF or PS file. This enables you to concatenate reports with styled formats (such as PDF, HTML, PS, or EXL2K). You can also embed image files in a compound report. The first PDF or PS report defines the format for the concatenated report, enabling you to intersperse intermediate reports in other formats into one encompassing report. Using compound reports, you can gather data from different data sources and combine reports into one governing report that runs each request and concatenates the output into a single PDF or PS file.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 16, 2011, 02:04 PM
May
Thanks Francis.
But I need to get Excel format. I think I just save it to seperate file.
May
WebFOCUS 7.6.8 Servlet - MRE/BID/Self Service/ReportCaster - MS Windows Server 2003 - MS SQL Server 2005 - DataMigrator 7.6.9
May 16, 2011, 04:11 PM
Prarie
Sorry thought you said WF on the Mainframe.
May 16, 2011, 09:02 PM
Jim Morrow
I do some stuff on the IBM mainframe, running batch jobs. I save the output as FORMAT TABT, which is attached to an e-mail. I call the attachment a .xls file.
When the e-mail with the file arrives, the .xls causes windows to do an open with EXCEL. EXCEL recognizes the format and opens the file, properly.
You can not do any formatting but you don't have to send the data as a binary
Jim Morrow Web Focus 7.6.10 under Windows 2003 MVS 7.3.3
May 17, 2011, 10:18 AM
ABT
quote:
Originally posted by Jim Morrow: I do some stuff on the IBM mainframe, running batch jobs. I save the output as FORMAT TABT, which is attached to an e-mail. I call the attachment a .xls file.
When the e-mail with the file arrives, the .xls causes windows to do an open with EXCEL. EXCEL recognizes the format and opens the file, properly.
You can not do any formatting but you don't have to send the data as a binary