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,

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.

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

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.

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.

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

As I noted above. The issue is the versio of FOCUS. Compound is not available.

Sandy