Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2003
    Posts
    10

    Unanswered: calling reports from forms

    I have been trying to call my report from form through this code but neither it gives me any error nor its showing any report.

    declare
    report_id Report_Object;
    report_job_id VARCHAR2(100);
    BEGIN
    report_id:= find_report_object('REPORT5');
    report_JOB_ID:=run_report_object(report_id);
    END;

    Comm Mode : async
    desctype : screen
    Ex mode: runtime
    file name : F:\Docs\Forms\vivek.rdf

    report5 is the name of report object in the navigator.

    What could be the problem??

  2. #2
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    Does Your report works fine? Is it fetching the required records ?
    SATHISH .

  3. #3
    Join Date
    Nov 2003
    Posts
    10
    Yep perfectly !

    Originally posted by satish_ct
    Hi,

    Does Your report works fine? Is it fetching the required records ?

  4. #4
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127
    Try using RUN_REPORT(<<filename>>)

  5. #5
    Join Date
    Nov 2003
    Posts
    10

    Wink

    Originally posted by shelva
    Try using RUN_REPORT(<<filename>>)

    RUN_REPORT runs only from report as SRW.RUN_REPORT and not from form.

  6. #6
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127
    Hey sorry u r right
    its ALL_REPORT(<<FIILE NAME>>) from forms

    Or in ur method, just give full path of the reports file name

  7. #7
    Join Date
    Nov 2003
    Posts
    10

    Red face

    Originally posted by shelva
    Hey sorry u r right
    its ALL_REPORT(<<FIILE NAME>>) from forms

    Or in ur method, just give full path of the reports file name
    Never heard of it and neither it works.

  8. #8
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127
    Oye again typing mistake

    its CALL_REPORT.. sorry again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •