We help IT Professionals succeed at work.

How to use +mimetype=application/vnd.ms-Excel  in ORACLE forms 9i???

4,664 Views
Last Modified: 2013-12-19
Hi,

I created a report with delimiteddata (ORACLE forms and reports and iAS 9i), the report is showed on the preview screen very well, however I found that if I add to the report URL the following characters : +mimetype=application/vnd.ms-Excel  on the explorer window , it appears an option to save the file in excel format which is what I really want, the problem is that I added these characters on the form as follows:

WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'||substr(lv_report,instr(lv_report,'_',-1)+1)||'?'||'server='||lv_rep_server||'+mimetype=application/vnd.ms-Excel','_blank');                   

it used to be like
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'||substr(lv_report,instr(lv_report,'_',-1)+1)||'?'||'server='||lv_rep_server,'_blank');        --> this works but is not what I need.

What is happening is that if I add the characters for mimetype then the report seems to be opened but suddenly it is closed. (At execution time on the iAS)

If I type directly on the explorer window this:
http://myserver.data.ab.com:7780/reports/rwservlet/getjobid159?server=devrepserver+mimetype=application/vnd.ms-Excel

Then the option to save as excel appears,
 
Can you please assist me?

Regards,
Diana
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2008
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
schwertner,

I asked two co-workers to try the same that I tried last night

-- code in forms 9i
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'||substr(lv_report,instr(lv_report,'_',-1)+1)||'?'||'server='||lv_rep_server||'+mimetype=application/vnd.ms-Excel','_blank');             

This is the result: On their computers the option to save the file is appearing as expected, but, on mine, same status it opens the explorer window for a second and suddenly it is closed.

This is really weird, any clue on this?

Regards,
Diana Sanchez

Author

Commented:
I also noticed that I included the "_blank" option on the web.show_document and the '+' sign.

This is my try
+mimetype=application/vnd.ms-Excel','_blank');  

This is your example
'&mimetype=application/vnd.ms-excel');

Is it making any difference?

Regards,
Diana Sanchez
CERTIFIED EXPERT
Top Expert 2008

Commented:
Possibly it will be a good idea to compare the versions of Jinitiator and Excel you have installed on your box.
Also the browser version is important.
I have just tried outside Forms (via browser)
to run this

http://train/reports/rwservlet?module=per_day.rdf+destype=cache+desformat=delimited+userid=sys/s123$37h@bluechips+mimetype=application/vnd.ms-Excel 


and it runs
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.