[SOLVED] Question about making Excel in mainframe FOCUS
I know you can make Excel output from Mainframe FOCUS; however, here's my question: Can you make an output Excel file that contains both a detail section and a summary section? Can you put different output into different worksheets of one Excel workbook? If so, how is that done?
Thank you in advance........This message has been edited. Last edited by: webmeister,
Mainframe FOCUS 7.0 VM/CMS and MVS/TSO
June 25, 2008, 10:53 AM
Darin Lee
I think you're getting into the WebFOCUS realm. What your are needing is a compound document and I don't know if straight FOCUS provides that functionality. But then my MF FOCUS eperience ended years ago, so I don't know exactly all of the current functionality.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
June 25, 2008, 11:14 AM
webmeister
Thanks, Darin,
I know that WebFocus can do what I'm searching for....I was hoping that perhaps someone might have a way of doing something similar in mainframe FOCUS.
I appreciate you taking time to reply.
Mainframe FOCUS 7.0 VM/CMS and MVS/TSO
June 25, 2008, 02:34 PM
Danny-SRL
WebMeister,
From the MF/Focus 7.3 user manual:
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.
You should download all the Focus manuals from the IBI web site...
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
June 26, 2008, 09:07 AM
webmeister
Hi, Daniel,
Thank you for replying. While the excerpt you provided about PDF and Postscript output might be valid, I don't think it will work in my case, since we have Release 7.1 of mainframe FOCUS.
We have been presented with a demo of WebFOCUS and management is deciding whether we go with it or not.
It's just frustrating to have to make an Excel sheet for a detail report and then to make an Excel sheet for a summary report....
Thanks again for replying.
Mainframe FOCUS 7.0 VM/CMS and MVS/TSO
June 26, 2008, 10:50 AM
Danny-SRL
Webmeister,
Why don't you just give it a small try - that has been the Focus spirit for over 30 years?
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
June 26, 2008, 11:35 AM
GinnyJakes
Couldn't you use standard FOCUS reporting techniques of putting summary information into a subhead and the detail as normal lines? Or the MacGyver technique?
I agree with Danny. Sometimes you have to play with technique.
Thank you for replying... sorry I did not reply sooner, but have been on vacation. I'll keep trying, and see hwat comes out the other end. If I'm successful, I will definitely let you know.