Does somebody can help me? I'm getting a MIME message when I run a procedure using 3 holds, trying to get a compound file in excel 2007, the procedure works just fine using PDF, here's the error and the code I wrote, thank you guys.

MIME-Version: 1.0 X-Document-Type: Workbook Content-Type: multipart/related; boundary="====Boundary====" --====Boundary==== Content-Location: file:///C:/HOLD.XHT Content-Transfer-Encoding: 8bit Content-Type: text/html; charset="windows-1252" Sheet1 --====Boundary==== Content-Location: file:///C:/IBIT0001.xht Content-Transfer-Encoding: 8bit Content-Type: text/html; charset="windows-1252" False
DEALER_COST
37,853
DEALER_COST
41,235
COUNTRY DEALER_COST
ENGLAND 37,853
FRANCE 4,631
ITALY 41,235
JAPAN 5,512
W GERMANY 54,563
--====Boundary====--



TABLE FILE CAR
SUM DEALER_COST
WHERE COUNTRY EQ 'ENGLAND'
ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK
END
-RUN

TABLE FILE CAR
SUM DEALER_COST
WHERE COUNTRY EQ 'ITALY'
ON TABLE PCHOLD FORMAT EXL2K NOBREAK
END
-RUN


TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K CLOSE
END
-RUN

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

I think that you should submit a case with Techsupport.

Thank you Waz, but if I have no login privilege to submit the case at IBI Techsupport, how can I find a solution?

You can register you self, all you need is the siite code, and the name of the company as it appears on the mainenance contract.

http://techsupport.information...om/tech/new_user.jsp

I believe if you are not using the document composer, trying using the

SET COMPOUND = OPEN
Fexes (Keep the nobreak where applicable)
SET COMPOUND = CLOSE
Last fex

Thank you Kathy, but unfortunally still doesn't work, it can't open the excel spred sheet.

At the beginning of one of the middle reports in the compound EXL2K focexec, try SET COMPOUND syntax followed by a -RUN.

SET COMPOUND = NOBREAK
-RUN

Hi there Kathy, still having same problem, here's the code using your suggestions:

SET COMPOUND = OPEN
-RUN

TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
WHERE COUNTRY EQ 'ENGLAND'
ON TABLE PCHOLD FORMAT EXL2K
END
-RUN

SET COMPOUND = NOBREAK
-RUN

TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
WHERE COUNTRY EQ 'ITALY'
ON TABLE PCHOLD FORMAT EXL2K
END
-RUN

SET COMPOUND = CLOSE
-RUN

TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K
END
-RUN

-EXIT

and here's the result:

MIME-Version: 1.0 X-Document-Type: Workbook Content-Type: multipart/related; boundary="====Boundary====" --====Boundary==== Content-Location: file:///C:/HOLD.XHT Content-Transfer-Encoding: 8bit Content-Type: text/html; charset="windows-1252" Sheet1 Sheet2 --====Boundary==== Content-Location: file:///C:/IBIT0001.xht Content-Transfer-Encoding: 8bit Content-Type: text/html; charset="windows-1252" False
COUNTRY DEALER_COST
ENGLAND 37,853
--====Boundary==== Content-Location: file:///C:/IBIT0002.xht Content-Transfer-Encoding: 8bit Content-Type: text/html; charset="windows-1252" False
COUNTRY DEALER_COST
ITALY 41,235
COUNTRY DEALER_COST
ENGLAND 37,853
FRANCE 4,631
ITALY 41,235
JAPAN 5,512
W GERMANY 54,563
--====Boundary====--

am I using correctly the COMPOUND syntaxis?

Alex, the code works correctly for Excel 2003.

The problem *may* be with the mime redirection settings. Verify the following:

WebFOCUS Admin Console > Configuration > Redirection Settings. On my server, xls is set to Redirect "yes".

"The mime.wfs file contains information about format types available with WebFOCUS. Setting the redirect column to yes enables redirection, which allows you to save the report output in a temporary directory. Then, an http call is made from the browser to retrieve the temporary stored output for display in the browser. If redirection is turned off (set to no), the report output displays in the browser immediately after the request is executed. The len setting stores report content in the temporary directory when it exceeds the buffer size and then sends the output to the browser without an additional http call." - I feel this documentation isn't very clear, but may help fix the problem.

Then again it may be an Excel 2007 issue. Does Excel 2007 open a non-compound report without any problem?

Thanks for your time Francis, I can't find the conf path that you wrote, I mean WebFOCUS Admin Console > Configuration > Redirection Settings. On my server, xls is set to Redirect "yes".

But I have checked the MIME file at C:\ibi\srv76\home\etc and at C:\ibi\srv76\wfs\etc they both have the settings as shown:

extension content_type format redirect translate content_disposition

.xls application/vnd.ms-excel binary yes no no

So I guess this is right isn't.

I've also tried the xls output with a non compound pchold, it works just fine.

Any way thank you so much, I'm thinking in a MS Excel 97 issue.

Hi Alex,
I played with it quite a bit and could not reproduce your error. Did some research and that was the only thing I could find related to your problem and releases. I think it is an 2007 issue also. You forgot to "close" your compound report on the syntax above. I do not have office 2007. Sorry.

Alex,

A pure shot in the dark here but check the default program for opening files of type ".xlt" is MS Excel and not something else.

I can't see it being anything else but you never know.

T

Thanks Tony, it is MS Excel the defualt program for opening '.xlt' files, so I'm still looking for an aswer to this problem, greetings.

Thank you all for your kindness, I discover that the error comes using the WF admin web console, if I run this procedure using the ibi_apps URL i.e. "http://localhost:8080/ibi_apps/WFServlet?IBIF_ex=f_ide_cte" then I get the open/save excel dialog manager.

Best regards to all.

Note: Even thoug I don't know why I can't run it from the web console.