PDF generated report in Oracle Forms

10-11  Source: Network gathering  Views:3 

Advertisement
Hi folks,
I'm new in this forum and I want help on how can I generate a report in PDF format just using Oracle Forms (not Oracle Reports).
This report will be assembled using some parameters that the user will fill in a form when the program starts. When the user click on a button on the form, based on that information, the program will go to the database to recover some data, and then will assemble the report to be shown to the user in a Adobe Reader screen.
Is it necessary to use the built in CLIENT_OLE2 or anything else?
Thanks
Ricardo
Welcome to the Oracle Forums. Please take a few minutes to review the following:
<ul>
<li>Oracle Forums FAQ
<li>Before posting on this forum please read
<li>10 Commandments for the OTN Forums Member
<li>How to ask questions the smart way
</ul>
Following these simple guidelines will ensure you have a positive experience in any forum; not just this one! ;-)
Lets start with some of the basics. What is your Forms version, Client OS version; if web deployed, your browser and Java versions and any error messages you might be receiving.
...how can I generate a report in PDF format just using Oracle Forms (not Oracle Reports).What's wrong with using Oracle Reports to produce the PDF file? Manually generating a PDF file means you have to manually format your output and then write it to a PDF file. Oracle Reports is a whole lot easier than this and not prone to the errors you are going to have by manually generating the output.
If you absolutely have to create your report this way, then I recommend you let the database handle the creation of the file and then simply use Forms to transfer the output file to the client. For this, you would use the WEBUTIL_FILE_TRANSFER.DB_TO_CLIENT or DB_TO_CLIENT_WITH_PROGRESS fucntions to send the file to the client. We need to know the information I request above before we could give you assistance with this.
Craig...
Related articles
  • PDF generated report in Oracle Forms 10-11

    Hi folks, I'm new in this forum and I want help on how can I generate a report in PDF format just using Oracle Forms (not Oracle Reports). This report will be assembled using some parameters that the user will fill in a form when the program starts.

  • While generating reports in Oracle BI Publisher in pdf format, the generated pdf reports have hindi  इ matra displaced by one character. For example, रिपोर्ट is printed as रपेिोरट.  Word file generated of the same report have correct hindi इ  matra positi 10-11

    While generating reports in Oracle BI Publisher in pdf format, the generated pdf reports have hindi  इ matra displaced by one character. For example, रिपोर्ट is printed as रपेिोरट.  Word file generated of the same report have correct hindi इ  matra p

  • Calling Report from Oracle form 11g 10-11

    I am new to Forms 11g, trying to call report from Oracle forms 11g . I want to call report from oracle forms, but its giving error. Below is the code DECLARE repid REPORT_OBJECT; v_rep VARCHAR2(100); rep_status VARCHAR2(20); BEGIN repid := FIND_REPOR

  • Calling a report from oracle form 10g 10-11

    how to call a report from oracle form 10gPlease see the link: http://www.oracle.com/technology/products/forms/pdf/10g/frm10gsrw10g.pdfRead other 2 answers

  • How to print BIP reports from Oracle Forms? 10-11

    Hi all, I have a question in regards to printing BIP reports from Oracle Forms... We are aiming for a server installation of BIP with integration to Oracle Forms using SSO to handle security. We use Forms built-in web.show_document to render and view

  • Calling Crystal Reports from Oracle Forms 10G 10-11

    Hi everyone, I am trying to call a crystal report from Oracle Forms 10G. I have a button on my Form which when clicked calls a Crystal Report which the uaser then wants to save as a PDf file. Can someone please send me the code to do this and also th

  • How to call Reports in oracle forms 10g 10-11

    Dear All, How to call Reports in oracle forms 10g. I am using Oracle Forms 10g Reports 10g and Database 10 and and Operating system Windows XP. Please give me the Solution. Thanks and Regards, FaziludeenHi Omkar, Please check the following code. DECL

  • Calling Report From Oracle Forms 10-11

    Hi I am calling this one report from oracle forms, I am using global temporary table to run that report. I am first inserting data into the temporary table through oracle form and then i am calling report in that form to view the data in that tempora

  • How to Call a jasper report from Oracle Forms 6i. 10-11

    Hi Can anybody tel me how to Call a jasper report from ORacle Forms 6i. Thanks & Regards BangoForms 6i client/server? Use the HOST command to call the report. Since a Jasper report is just a call to a url, it will be something like: v_url := '<your

  • URGENT!!! calling crystal reports from oracle forms 10g 10-11

    Is it possible to call crystal reports from oracle forms 10g? Can someone help to answer how, if there is a solusion, to call crystal reports from oracle forms 10g. Please provide codes with details showing step by step. Thankshi try something like t

  • Calling reports from oracle forms 9i 10-11

    Hi I succeded to call reports from oracle forms but for I have a problem for only one report so I can't call it. this a part of the code I'm using : declare      pl_id2 ParamList;      pl_name2 VARCHAR2(30) := 'liste2';       v_rep VARCHAR2(100);    

  • Pls Help: View Crystal Report Via Oracle Form Builder 11-30

    Hi!! I want to know how to view the .rpt report (report made from Crystal Report) via Oracle Form Builder. I've to do it in my project. If you know, please tell me. Thanks in advance,I don't know how does crystal reports work, and I would guess you s

  • How to invoke crystal reports from Oracle forms 11g R2 along with passing p 11-30

    How to invoke crystal reports from Oracle forms 11g R2 along with passing parameter to it. how to pass parameters to crystal report, please help.how to pass parameters to crystal report, please help.This would entirely depend on crystal reports and y

  • Call Oreacle report from Oracle form 11-30

    Hi, I need call a Oracle report from Oracle Form and found the the following procedure from this forum. I have 2 parameters 'start_date' and 'end_date' passing to called report. The following example just have onle parameter 'departmentno' passing. I

  • Is it possible to call a Crystal Report from Oracle Forms. 11-30

    Hi Everybody, I got a Dout about Crystal Reports. Is it possible to call Crystal Reports from Oracle Forms.Hello, That depends are you running Forms via the WEB or client/server. I will assume you are running client/server since you are running cryst

  • Generating a Report from Oracle Forms 10-11

    If a want to generate a report in Oracle Reports by pressing a Button on my Oracle Forms for example for 5 text items on that form ...then how do i do it ??? plz helpwell when i create a report module in the object navigator of oracle forms its opens

  • Doubts about generating reports in Oracle 10-11

    Hi, I am Oracle DBA, but I need some instructions from you – oracle developers- related to how implement reports from Oracle 9i Application Server Enterprise built on Sun Solaris 9. Nowadays, my client is using Oracle Reports Server that comes with

  • Oracle Reports In Oracle Forms 11g Parameter problem. 10-11

    Hello techies,               I am using Weblogic server 10.3.5 with oracle forms 11g at windows 7.I have a report that is Bar_code.rdf.It has two parameters as: P_1---->character type---->accepts the options(barcode generated or barcode not generate

  • How to run an XML Report from Oracle Forms 10G 10-11

    Hello Friends, I am in need of showing a xml report output through a button press trigger in Oracle Forms10G. I have designed the report in XML Publisher and the report looks fine.I found few scripts useful in running the Oracle Report from Oracle fo

  • Calling a Report from Oracle Forms 10g 10-11

    Hi Everyone, I need assistance. Am running Oracle Forms & reports 10g. My Form module is running just fine. Inside the the Form Module I added a button with a "When Button Pressed Trigger" that has the following code declare      repid REPOR