Ad:

Oracle Discussion Thread
Unsolved
Views: 3163

Permalink

Jun 20th, 2009

calling oracle report from form builder

Expand Post »

how to call oracle report using form builder on which command button.If i press command button report should be run.

Similar Threads

Report Form Queries, pls.. help in Visual Basic 4 / 5 / 6
Need help in showing the report on Vb form in Visual Basic 4 / 5 / 6
Crystal Report + Stored Procedure returns no data in Visual Basic 4 / 5 / 6
Can you stop oracle storing < as < from a JSP inputText form field? in JSP
Need Crystal report calling Oracle forms 10G in Oracle

imranmahmood_3

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2009

Permalink

Jun 24th, 2009

Re: calling oracle report from form builder

You need to use the function RUN_REPORT_OBJECT

Oracle Syntax (Toggle Plain Text)
DECLARE 
	repid REPORT_OBJECT; 
	v_rep  VARCHAR2(100); 
	rep_status VARCHAR2(20); 
BEGIN 
	repid := find_report_object('report4'); 
	v_rep := RUN_REPORT_OBJECT(repid); 
	...... 
END;
DECLARE 
	repid REPORT_OBJECT; 
	v_rep  VARCHAR2(100); 
	rep_status varchar2(20); 
BEGIN 
	repid := find_report_object('report4'); 
	v_rep := RUN_REPORT_OBJECT(repid); 
	...... 
END;

debasisdas

Featured Poster

Reputation Points: 665

Solved Threads: 427

Posting Genius

Offline

6,406 posts
since Feb 2007

Permalink

May 9th, 2011

help im new

and then what i should do to call my report with a push button in oracle form builder 10.1.2.2

georgeskayal

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since May 2011

Permalink

May 9th, 2011

Re: calling oracle report from form builder

Put debasisdas' code in your When-Button-Pressed trigger.

hfx642

Reputation Points: 236

Solved Threads: 101

Posting Pro

Offline

506 posts
since Nov 2009

Permalink

May 12th, 2011

Re: calling oracle report from form builder

thanks but that code dosn't worked on my 10g 12.1.2.2 forms builder
this is what i use :
DECLARE
rep_url varchar2(2000);
BEGIN
rep_url:='/reports/rwservlet?'
||'&report=C:\Documents and Settings\Administrator\Desktop\Report\rep1.jsp'
||'&desformat=htmlcss&destype=cache'
||'&userid=tawkissa/tawkissa@xe';
WEB.SHOW_DOCUMENT(rep_url,'_blank');
END;

georgeskayal

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since May 2011

Permalink

Sep 24th, 2011

Re: calling oracle report from form builder

Thanks "georgeskayal". The code is working......

deveshdashora

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Sep 2011

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Oracle Forum Timeline: SQL Substitution

Next Thread in Oracle Forum Timeline: registration date 2 days or more after enroll date

DaniWeb Message

Cancel Changes

User Name
Password