Can not Run the Report over the web
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Can not Run the Report over the web

  1. #1
    Join Date
    Oct 2002
    Posts
    23

    Can not Run the Report over the web

    I have this code to run a reprot from a form over the web but i get this error.
    The Report is already added to the reports node in the form moudule.
    In Alert :
    REP-0503 You did not specify the name of a report
    In status Bar:
    Frm-40738 Argument 1 to builtin REPORT_OBJECT_STATUS cannot be null

    My Code:

    DECLARE
    rep_id REPORT_OBJECT;
    rep_server VARCHAR2(40);
    rep_job_id VARCHAR2(200);
    rep_status VARCHAR2(100);
    BEGIN
    rep_id:=FIND_REPORT_OBJECT('report');
    set_report_object_property (rep_id,report_destype,cache);
    rep_job_id:=RUN_REPORT_OBJECT(rep_id);
    rep_status:=REPORT_OBJECT_STATUS(rep_job_id);
    Message('after reprot job status--> report_job_id:= '||rep_job_id);
    if REP_STATUS = 'FINISHED' then
    WEB.Show_Document('http://jalal:8888/reports/rwservlet?Getjobid='||rep_job_id||'&server=test&','_blank');
    -- WEB.Show_Document('http://jalal:8888/reports/rwservlet?report=test.rdf&userid=vmsuser/oracle@orcl&destype=cache&desformat=html&pagestream=yes&server=test&','_blank');
    else
    message('report failed with error message:'||rep_status);
    end if;
    END;

    why i am getting this error message ?

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Are you finding 'report'? Is "report" the name of your report? If not, the value is null.

  3. #3
    Join Date
    Oct 2002
    Posts
    23

    Yes

    Thanks for your replay.

    yes my report name in reports node in the object navigator is report

    please replay
    thanks

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    I see you've followed the coding example used in Forms Reference. However, with "Frm-40738 Argument 1 to builtin REPORT_OBJECT_STATUS cannot be null," that says the report name or report id is not found. Put in some alert messages to output values (a troubleshooting technique). For example, after "rep_id:=FIND_REPORT_OBJECT('report');" put in a test to see if rep_id is null

    rep_id:=FIND_REPORT_OBJECT('report');
    IF rep_id is NULL then
    change_alert_message('NOTE','rep_id is null');
    ELSE
    change_alert_message('NOTE','rep_id is NOT null');
    END IF;
    btn_id := show_alert('NOTE');
    and so on

Posting Permissions

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


Click Here to Expand Forum to Full Width