calling reports from 6i form on 9ias

[bookouri]

In the past I have used a form with buttons to call reports and other forms in forms 4.5. We are migrating to forms 6i and 9ias. In forms 4.5 the user was required to logon when the form first came up. Then any forms or reports from that form automatically logged on with the username and password. When using 6i every button that calls a form or a report from the main form requires the user to manually log on every time. I use code like: web.show_document('

http://gcsoapp/dev60cgi/rwcgi60.exe?report=myreport

in the pl/sql property of a button. I can hard code in userid=scott/tiger@mydb to the button but if I dont, the user is required to logon EVERY time they want to print a report or go to another form. Is there any way around this?

thanks for any suggestions

 

[sem]

You may use RUN_REPORT_OBJECT built-in to launch reports and CALL_FORM for forms. Please, read these command descriptions before asking further questions.

Regards, Dima

 

[bookouri]

I used run_product in 4.5, but when I tried that in 6i/9ias it did not work. I was advised to use the web_show_document form to call reports.

I'll try to find info on the call_form and run_report_object. I never ran into them before.

thanks

 

[bookouri]

I have found hundreds of pages of info on the run_report_object command, but I still cant make it work. I'm having to work with parameter forms. Much of the documentation is contradictory, and the rest just doesnt seem to work. Does it REALLY require 12 pages of code to create a procedure to just make the run_report_object use a parameter form to run a simple report? Some sources say you just need to add the paramform=yes to the object's definition in the form, but no form of paramform=yes or paramform=html (as stated in other documentation) would work for me..

any good help files or sources of information that actually works would be greatly appreciated. This really cant be as difficult as it seems to be...

 

[sem]

I don'tknow where you found 12 pages of code. Did you follow this note?

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=139546.1

Regards, Dima

 

[bookouri]

Ill take a look at that one... thanks