DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to print to PDF directly from Reports

  1. #1
    Join Date
    Dec 2001
    Posts
    96

    How to print to PDF directly from Reports

    Hello,

    I am calling a Oracle report from Oracle Forms. I want the report to be generated directly in PDF and displayed. How to do that?

    Thanks

  2. #2
    Join Date
    Dec 2001
    Posts
    96
    I got the solution for that
    * DESFORMAT could be HTML, HTMLCSS or PDF here*/
    SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,'HTML');

    But,when i run the report from forms, the report sucessfully runs and opens a PDF,but upon closing the report pdf, i get an error in Oracle Forms FRM-41219: Cannot find report:invalid id

    why is that, it can find that report and is running it. can anybody tell me why.

    the code in the forms is
    Declare
    pl_id paramlist;

    begin
    pl_id := CREATE_PARAMETER_LIST('rep_paramlist');
    RUN_PRODUCT(REPORTS,'C:\acctreports\test',SYNCHRONOUS,RUNTIME,FILESYSTEM,pl_id,NULL);
    SET_REPORT_OBJECT_PROPERTY('c:\acctreports\test',REPORT_DESFORMAT,'PDF');
    end;

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