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     COMPOUND REPORTS (HOLD an Excel WorkBook Frameset)
Go
New
Search
Notify
Tools
Reply
  
COMPOUND REPORTS (HOLD an Excel WorkBook Frameset)
 Login/Join
 
Platinum Member
posted
Bonjour,
I get into Focus/MVS : version FOCUS 7.6.11 and try to build Compound Reports (I could not reach FORMAT EXL2K OPEN/CLOSE with Prior Focus Versions)
I certainly miss a point because the Hold file that Focus creates does not work with Excel 2007. ( Impossible de lire le fichier)

This Good Old Focus creates me, exactly what I want ( A single File with two Sheets)
But there must be something wrong somewhere ( perhaps in the transcoding EBCDIC -> ASCII)
The X'15' before --====Boundary==== puzzles me :
BROWSE xx.xxxxx.xxxxxx.EX1
Command ===>
.--====Boundary====
1667777C9A9889A7777
500EEEE26454198EEEE

Thanks for Help
Focusely and Cordially

The Focus Fex is taken out of documentation :

SET PAGE-NUM=OFF
TABLE FILE CAR
HEADING
"Sales Report"
" "
SUM SALES
BY COUNTRY
ON TABLE SET STYLE *
type=report, titletext='Sales Rpt', $
type=heading, size=18, $
ENDSTYLE
ON TABLE HOLD AS EX1 FORMAT EXL2K OPEN
END
TABLE FILE CAR
HEADING
"Inventory Report"
" "
SUM RC
BY COUNTRY
ON TABLE SET STYLE *
type=report, titletext='Inv. Rpt', $
type=heading, size=18, $
ENDSTYLE
ON TABLE HOLD FORMAT EXL2K CLOSE
END

And the EX1 Held file begins as follow (And is contains everything to m

MIME-Version: 1.0
X-Document-Type: Workbook
Content-Type: multipart/related; boundary="====Boundary===="
--====Boundary====
Content-Location: file:///C:/EX1.XHT
Content-Transfer-Encoding: 8bit
Content-Type: text/html; charset="windows-1252"

xmlnsRed Face="urn:schemas-microsoft-comRed FacefficeRed Faceffice"
xmlns:x="urn:schemas-microsoft-comRed Faceffice:excel"
xmlns="http://www.w3.org/TR/REC-html40">








Sales Rpt



Inv. Rpt







.--====Boundary====
Content-Location: file:///C:/IBIT0001.xht
Content-Transfer-Encoding: 8bit
Content-Type: text/html; charset="windows-1252"
.
xmlnsRed Face="urn:schemas-microsoft-comRed FacefficeRed Faceffice"
xmlns:x="urn:schemas-microsoft-comRed Faceffice:excel"
xmlns="http://www.w3.org/TR/REC-html40">