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] IN FOCUS (not WebFOCUS) creating 2 tab EXCEL output
Go
New
Search
Notify
Tools
Reply
  
[Solved] IN FOCUS (not WebFOCUS) creating 2 tab EXCEL output
 Login/Join
 
Silver Member
posted
My client is a MF FOCUS shop. So ALL solutions must be FOCUS 7.2.2 compatible – not WebFOCUS.

I would like to be able to create, using 2 steps if needed, an EXCEL file with 2 unrelated tabs. That is not as the result of a BY.

While I can use EXL2K they prefer I don't but if that's what it takes I'll do it.


Thanks

This message has been edited. Last edited by: Sandy Weller,


Signature changes from project to project
 
Posts: 38 | Location: Chicago, IL area | Registered: June 16, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
Using MF FOCUS or WebFOCUS code, you cannot create a multi-tab EXCEL file - you can do this only with EXL2K. You may be able to do something with Visual Basic macros, but how you call those in a MF fex I don't know.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
As Francis states, EXL2K is the only way for compound reports.

If you use EXL2K, then try the OPEN/CLOSE technique:

  
TABLE FILE CAR
SUM
  DEALER_COST/P13.2M AS 'Dealer Cost'
  RETAIL_COST/P13.2M AS 'Retail Cost'
    COMPUTE PROFIT/P13.2M = RETAIL_COST-DEALER_COST; AS 'Profit'
  SALES/P13.2M AS 'Sales'
BY COUNTRY AS 'Country'
BY CAR AS 'Car'
BY MODEL AS 'Model'
ON COUNTRY SUBFOOT
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT EXL2K OPEN
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.400000,
     RIGHTMARGIN=0.050000,
     TOPMARGIN=0.000000,
     BOTTOMMARGIN=0.000000,
     ORIENTATION=LANDSCAPE,
     SQUEEZE=ON,
$
TYPE=TITLE,
  STYLE=BOLD, SIZE=10, FONT=VERDANA,
$
TYPE=REPORT, TITLETEXT='Report 1',$
ENDSTYLE
END
-RUN
TABLE FILE CAR
SUM
  DEALER_COST/P13.2M AS 'Dealer Cost'
  RETAIL_COST/P13.2M AS 'Retail Cost'
    COMPUTE PROFIT/P13.2M = RETAIL_COST-DEALER_COST; AS 'Profit'
  SALES/P13.2M AS 'Sales'
  SEATS AS 'Seats'
BY COUNTRY AS 'Country'
BY CAR AS 'Car'
BY MODEL AS 'Model'
BY BODYTYPE AS 'Body Style'
ON COUNTRY SUBFOOT
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT EXL2K CLOSE
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.400000,
     RIGHTMARGIN=0.050000,
     TOPMARGIN=0.000000,
     BOTTOMMARGIN=0.000000,
     ORIENTATION=LANDSCAPE,
     SQUEEZE=ON,
$
TYPE=TITLE,
  STYLE=BOLD, SIZE=10, FONT=VERDANA,
$
TYPE=REPORT, TITLETEXT='Report 2',$
ENDSTYLE
END
-RUN
-EXIT


hth


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1958 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Silver Member
posted Hide Post
OK. Now I get it. MF FOCUS 7.2 does not support OPEN and CLOSE.

ON TABLE PCHOLD AS TEST1 FORMAT EXL2K OPEN
(FOC002) A WORD IS NOT RECOGNIZED: OPEN
(FOC009) INCOMPLETE REQUEST STATEMENT

Thanks for ALL the help.


Signature changes from project to project
 
Posts: 38 | Location: Chicago, IL area | Registered: June 16, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
It looks like Compound reports in EXL2K format are not available in Mainframe FOCUS. I checked the v7.3 documentation and Compound reports are available for PDF and PS formats only.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Bonjour,
I think that Focus 7.6."Idon't remember which" is the first version of Focus MF that plays Compound Reports (7.6.11 does. I know because I've been waiting this feature for years. And I still have problem of EBCDIC -> Ascii conversion to actually have it working, but Focus does his job, (Personal worthless advice)
For Old Timers ; The Problems of Conversion :
More over, I'm French and &ecute; (é) and &eInolongerknow (è) are important for us ...
//*-------------------------------------------------------------------- 
//*                                                                     
//* EBCDIC -> ASCII conversion that Excel would appreciate !!!                           
//*     X'15'    -->   X'0A'    ( POUR BOUNDARY ETC ... COMPOUND REPORT)
//*     X'C0'    -->   X'7B'    ( POUR {                                
//*     X'D0'    -->   X'7D'      POUR } (  COMPUTE )  MAIS é, è !!!    
//*                                                                     
//* => ON RENONCE AU COMPUTE ET ON PRIVILéGIE LES ACCENTS ...           
//*     X'C0'    -->   X'E9'    ( POUR é                                
//*     X'D0'    -->   X'E8'      POUR è (  MAIS COMPUTE {, } !!!)  )   
//*                                                                     
//*--------------------------------------------------------------------  

Cordially and Focusely


Focus Mainframe 7.6.11
Dev Studio 7.6.11 and !!!
PC Focus, Focus for OS/2, FFW Six, MSO
 
Posts: 134 | Registered: November 06, 2007Reply With QuoteReport This Post
Silver Member
posted Hide Post
As I noted above. The issue is the versio of FOCUS. Compound is not available.

Sandy
 
Posts: 38 | Location: Chicago, IL area | Registered: June 16, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved] IN FOCUS (not WebFOCUS) creating 2 tab EXCEL output

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