Home » Developer & Programmer » Forms » URGENT!!! FORM BUILDER WITH REPORT BUILDER
URGENT!!! FORM BUILDER WITH REPORT BUILDER [message #191626] Thu, 07 September 2006 06:18 Go to next message
jamesrussell15
Messages: 16
Registered: September 2006
Location: philippines
Junior Member

HOW TO VIEW REPORTS (FROM REPORT BUILDER) WHEN I PRESSED THE PUSH BUTTON (FROM FORM BUILDER)...?

web.show_document('path');

ERROR: INVALID URL

HELP ME FOR MY THESIS! URGENT!!!

THANK YOU VERY MUCH!

[Updated on: Thu, 07 September 2006 06:19]

Report message to a moderator

Re: URGENT!!! FORM BUILDER WITH REPORT BUILDER [message #191709 is a reply to message #191626] Thu, 07 September 2006 19:29 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Web programming?
I so, try to use the syntax:
e.g. Web.Show_Document(‘www.abc.com’, ‘_self’);

If not, just use RUN_PRODUCT()
Re: URGENT!!! FORM BUILDER WITH REPORT BUILDER [message #191740 is a reply to message #191626] Fri, 08 September 2006 00:22 Go to previous messageGo to next message
sandeepk7
Messages: 137
Registered: September 2006
Senior Member

There is PL/SQL library is provided by oracle named rp2rro.pll. It basically runs the reports with Destype File and then uses the Web.show_document to put it on browser. Download this Pll from Oracle Web Site and use it.

Sandy
Re: URGENT!!! FORM BUILDER WITH REPORT BUILDER [message #192942 is a reply to message #191626] Thu, 14 September 2006 05:45 Go to previous messageGo to next message
raizen_underground
Messages: 28
Registered: September 2006
Location: Manila, Phillipines
Junior Member
have you solve your problem????how?please post the code in this forum....tnx in advance...


raizen.....
Re: URGENT!!! FORM BUILDER WITH REPORT BUILDER [message #193007 is a reply to message #191626] Thu, 14 September 2006 09:34 Go to previous messageGo to next message
Liza79
Messages: 74
Registered: September 2006
Member
There should be a report server running on your machine.
You didn't tell what environment you are using?

anways, just create a report object in the form, mention the report file path, destination to CACHE, and report server= name of your report server.

now code like this in yur form.
declare
   a varchar2(200);
begin
   a := run_report_object('name_of_the_report_object');
web.show_document('http://server_machine:7778/reports/rwservlet/getjobid'||replace(a,'reportServerName_','')||'?server=reportServerName','_blank');
end;


You need to know the report server name and place it instead of "reportServerName" in the code.

Coma back if you face any trouble.

Liza
Re: URGENT!!! FORM BUILDER WITH REPORT BUILDER [message #193533 is a reply to message #193007] Mon, 18 September 2006 02:40 Go to previous messageGo to next message
raizen_underground
Messages: 28
Registered: September 2006
Location: Manila, Phillipines
Junior Member
Liza....

There is a problem with the code...Error:You did not specify report....and when the report show...Error:report_server_name failed..I dnt know if the problem is from the report object or from the report server name....pls I desperately need the answer soon....tnx in advance....


raizen....
Re: URGENT!!! FORM BUILDER WITH REPORT BUILDER [message #193609 is a reply to message #191626] Mon, 18 September 2006 07:54 Go to previous messageGo to next message
Liza79
Messages: 74
Registered: September 2006
Member
Your REP file for the report should be mentioned in the Report Object Properties in the form.

and is there any report server configured on your machine, if so what is the name of the report server?
What is the name of the report you are running?

give me answer for this questions, i will try to get you a solution.

Liza
Re: URGENT!!! FORM BUILDER WITH REPORT BUILDER [message #194040 is a reply to message #193609] Wed, 20 September 2006 09:15 Go to previous messageGo to next message
raizen_underground
Messages: 28
Registered: September 2006
Location: Manila, Phillipines
Junior Member
my report server is 'rep_rm207_26', and my report object is 'my_report'....where can I find the rep file nd the report server cause i think my report server is wrong?plssss i need an imediate answer.....tnx in advance....
Re: URGENT!!! FORM BUILDER WITH REPORT BUILDER [message #194143 is a reply to message #194040] Wed, 20 September 2006 23:37 Go to previous messageGo to next message
sandeepk7
Messages: 137
Registered: September 2006
Senior Member

please go through this link, might it can help u.

http://www.oracle.com/technology/products/forms/pdf/frm9isrw9i.pdf


Sandy
Re: URGENT!!! FORM BUILDER WITH REPORT BUILDER [message #194649 is a reply to message #194143] Sat, 23 September 2006 09:21 Go to previous messageGo to next message
raizen_underground
Messages: 28
Registered: September 2006
Location: Manila, Phillipines
Junior Member
ei....
tnx for the URL...I can now run my report from form...
Re: URGENT!!! FORM BUILDER WITH REPORT BUILDER [message #223015 is a reply to message #191626] Wed, 07 March 2007 03:42 Go to previous messageGo to next message
lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD
Senior Member

Hi ,
How do we know the report server name and where is the report object properties in the form.

I desparately need the solutions.

quick response is really appreciated,

thanks,
Surya
Re: URGENT!!! FORM BUILDER WITH REPORT BUILDER [message #225412 is a reply to message #223015] Mon, 19 March 2007 22:20 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: WEB.SHOW_DOCUMENT
Next Topic: Form Problem
Goto Forum:
  


Current Time: Wed Mar 12 15:39:37 CDT 2025