Bonjour,
I certainly made a mistake with my previous message : I can't see the answers (Sorry GamB).
So, could someone Run the following fex, Catch the output file EX1 and send it to me as a .txt so that I can compare with my own EX1 baillecl@e-i.com

Could the WebMaster destroy my previous message that this one duplicates

Cordially

*** Previous Message ***

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)

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

This message has been edited. Last edited by: Baillecl,

quote:

I can't see the answers

That is because, when posting code, you should put it between the code tags, the red < / >icon while entering comments.
Which by the way was my answer.

Anyway, I ran your code, captured the file - which turned out to become ex1.xht. And excel 2003 could read it without any problem. I'll send you my ex1 file.

Bonjour,
The file sent by GamP was accepted by my Excel (after a few mistakes on my side).
So I could compare both Files. The Problem comes of an Ebcdic X'15' that turns into an Ascii X'20' on my site. In Gamp's File, at this place, I could see Ascii X'0A'. So, after changing 0D 0A 20 into 0D 0D 0A in a few lines, my file was accepted by Excel ...
My problem is thus specific, I'll see what can be done and thank you all (GamP in the 1st place)
Focusely and not knowing how to classify as Solved

quote:

not knowing how to classify as Solved

Go to the first post in this thread and edit it. You'll then have the possibility to change the description.