Home » Developer & Programmer » Forms » call reports 9i
call reports 9i [message #138291] Wed, 21 September 2005 03:39 Go to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
hi
hope to get your help over calling a report (html file) generated using reports developer 9i from a form ,
i dont have an application server i use oc4j for testing
thx

Report message to a moderator

Re: call reports 9i [message #138419 is a reply to message #138291] Wed, 21 September 2005 18:55 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you got your 9iDS (Developer Server) working? Can you run the 'test' form (supplied by Oracle)? Can you run the 'test' report?

Also look at http://www.orafaq.com/forum/t/51779/67467/

David

[Updated on: Wed, 21 September 2005 18:59]

Report message to a moderator

Re: call reports 9i [message #138706 is a reply to message #138291] Fri, 23 September 2005 02:36 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
dear sir
thx for your reply,
can you plz pass me the address that i have to use to test the test report and the test form ,
im using oracle9i DS and oc4j for testing , idont have an application server
i guess its something like
http://127.0.0.1:8888/j2ee/examples/filename.html

plz dont forward me the documentation
it didnt help me a lot
thx

Report message to a moderator

Re: call reports 9i [message #138922 is a reply to message #138706] Sun, 25 September 2005 20:09 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
1) Go to 'start', 'programs', 'Oracle Forms 9i', 'Run a Form on the Web'. Does it exist?
2) Does it start?
3) Do you have your OC4J session running?
4) Do you have Oracle 6i Forms on your PC?

David

Upd: Added numbers to the questions.

[Updated on: Tue, 27 September 2005 20:57]

Report message to a moderator

Re: call reports 9i [message #139276 is a reply to message #138291] Tue, 27 September 2005 04:01 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
well i dont have reports 6i
i only have reports9i
plz help how to run the test form and the test report
the address that i should use in the browser
thx

Report message to a moderator

Re: call reports 9i [message #139408 is a reply to message #139276] Tue, 27 September 2005 21:01 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I have added numbers to my previous post. Please answer each of the questions.

The address will be something like http://mymachineid:8888/forms90/f90servlet?config=myapp where myapp has been defined in <oracle_home>\forms90\server\formsweb.cfg

David

Report message to a moderator

Re: call reports 9i [message #139688 is a reply to message #138291] Thu, 29 September 2005 03:20 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
dear sir
concerning the questions
1= no
2= no
3= yes
4= no

i need ur help over testing a report html file, whats the test report address to use in internet explorer , im using oracleDS9i
thx for ur help

Report message to a moderator

Re: call reports 9i [message #139923 is a reply to message #139688] Fri, 30 September 2005 02:01 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please have a look at http://www.oracle.com/technology/products/forms/pdf/10g/frmwebshowdoc_rep.pdf and http://www.nyoug.org/goin_live.pdf.

David

[Updated on: Fri, 30 September 2005 02:10]

Report message to a moderator

Re: call reports 9i [message #139952 is a reply to message #138291] Fri, 30 September 2005 03:01 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
thanks so much for your help
it seems i need oracle9iAS to test calling reports
hope my 512 RAM can hold the database server and the developer suite and the application server Laughing

anyway thx alot

Report message to a moderator

Re: call reports 9i [message #140344 is a reply to message #139952] Mon, 03 October 2005 19:07 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
No you should be able to run reports using the 9iDS. Are you running windows XP SP2 on your machine? If yes, then search this forum for 'SP2' and follow the instructions for changing the 'permissions' that were introduced with XP SP2.

David

Report message to a moderator

Re: call reports 9i [message #140420 is a reply to message #138291] Tue, 04 October 2005 03:13 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
thx so much david
i managed to call a report using web.show_document
thanks to your help,
hope to get your help over passing parameter from a form to a report than i call from the form
like a pass an employee id and a date to the report to filter the result
thx for everything

Report message to a moderator

Re: call reports 9i [message #140582 is a reply to message #140420] Tue, 04 October 2005 17:57 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
There are MANY threads in this forum about passing information using parameters. Some of them are currently active so you won't have to look too far.

David

Report message to a moderator

Re: call reports 9i [message #140687 is a reply to message #138291] Wed, 05 October 2005 04:12 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
hi david
plz ill be very thanksfull if u can pass a small demo
form calling a report with parameters
i know it takes time
but its easier ,
im using forms 9i and reports 9i
i really apreciate it
thx for ur time
maoro

Report message to a moderator

Re: call reports 9i [message #140844 is a reply to message #140687] Wed, 05 October 2005 19:55 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Sorry, I don't have 9i on my PC.

Go to http://www.oracle.com/forms/10g/help/. Use the search facility to look for 'pl_id'. Look at the examples under call_form, add_parameter, create_parameter_list, and delete_parameter_list. Alternatively, go to the 6i Forms reference and search it for pl_id. Teehre are numerous examples.

David

Report message to a moderator

Previous Topic: .....color issue
Next Topic: receive date of format dd.mm.yyyy HH24:MI
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Mar 06 10:55:15 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.