×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

calling oracle reports in forms

calling oracle reports in forms

calling oracle reports in forms

(OP)
I'm using Oracle 9i forms. How do i call an oracle report in forms. I have heard about run_report_objects & tried using it but didn't work.
I have created a button in form & on when button click trigger, I tried using the run_report_objects ( the example
as given in help) but didn't work.

TIA

Raj

RE: calling oracle reports in forms

Have you attached the report to the form?

RE: calling oracle reports in forms

(OP)
I'm getting error FRM-41219: Cannot find report-Invalid ID
& FRM-40738 : Argument 1 to builtin RUN_REPORT_OBJECT cannot be null.

I have done all this -
====================================
Created a simple form with button for calling that report.
Created a new reports server service as following (in Command Prompt):
     c:> rwserver -install repserver90 autostart=yes
Created a Report object and in the Property Palette for Reports object, enter the following:
Name: rep_name(This name is given in Run_Report Object
Filename: C:\reports\rep.rdf
into REPORTS_PATH environment variable
Report Destination Type: CACHE
Report Destination Format: HTML
Report Server: repserver90

In the form on when_button_pressed trigger, I've put the following code:-
===================================
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
BEGIN
repid := FIND_REPORT_OBJECT('REPORT10');
v_rep := RUN_REPORT_OBJECT(repid);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status := report_object_status(v_rep);
END LOOP;
END;
======================
Please let me know if I have to anything more ?

RE: calling oracle reports in forms

I can't tell from your description if the report attached to your form is called 'REPORT10' or something else.

Check for the reports existence using ID_NULL(v_rep) before the call to run_report_object.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close