1. Can I generate full Rich Text Oracle Reports with the PDF Generator in Oracle Forms?

The Sferyx PDF Generator for Oracle Forms is a new product which resolves exactly this problem - it allows a fully formatted rich text generation of Oracle Reports in PDF from Oracle forms - it is capable of rendering everything inside the report - images, text, tables, lists - anything done automatically and exported in PDF. It works with all existing oracle reports and oracle forms and is quite simple to use. Furthermore you can use it to generate any kind of PDF documents directly from Oracle Forms using the available API.
 

2. How can I integrate the PDF Generator in Oracle Forms?

As any other java bean is integrated in Oracle Forms designer. Place the jar file in the designer's classpath and it will be automatically detected by the Oracle Forms Designer. You can add it after that easily as a bean area.

• copy the PDFGenerator.jar file in the <ORACLE_HOME>/forms/java directory
• edit your /forms/server/formsweb.cfg file to add the PDFGenerator.jar as follows:
  # Forms applet archive setting for JInitiator
  archive_jini=f90all_jinit.jar,PDFGenerator.jar
  # Forms applet archive setting for Microsoft Internet Explorer native JVM
  archive_ie=f90all.cab,PDFGenerator.jar
  # Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)
  archive=f90all.jar,PDFGenerator.jar
• open the PDFGenerator-reports-example.fmb module (Oracle Forms module)
• compile all and run the module
• Into the Oracle Forms Visual designer insert a Bean area and set the implementation property to sferyx.administration.pdfgenerator.PDFGeneratorOracleBean

3. How to generate a report with the PDF Generator in Oracle Forms?

Declare
hArgs FBEAN.ARGLIST;
Begin
hArgs:=FBEAN.CREATE_ARGLIST;
FBEAN.ADD_ARG(hArgs,'http://'||host||'/reports/rwservlet?'||report_string);
FBEAN.ADD_ARG(hArgs,'Letter');
FBEAN.ADD_ARG(hArgs,'PORTRAIT');
FBean.Invoke('PDFGENERATOR_AREA',1,'generatePDFFromReport',hArgs);
 

please consult the available examples for major details.

4. Available methods accessible directly from the sferyx.administration.pdfgenerator.PDFGeneratorOracleBean - you should use the same rules for accessing those methods as described above in the OracleForms PL/SQL script examples:

public void generatePDF(java.lang.String sourceURL, java.lang.String destinationFile) -Generates a pdf file from given URL and saves it to a given filename using default paper size and orientation

publiv void generatePDFFromContent(java.lang.String content, java.lang.String destinationFile, java.lang.String standardPageFormat, java.lang.String orinetation) - Generates a pdf file from given html/text content and saves it to a given filename, using paper size and paper orientation such as LANDSCAPE or PORTRAIT

public void generatePDFFromReport(java.lang.String sourceURL, java.lang.String standardPageFormat, java.lang.String orinetation) - Generates a pdf file from given URL and saves it to temporary file showing the ready PDF document into the available PDF viewer

public void generatePDFFromURL(java.lang.String sourceURL, java.lang.String destinationFile, java.lang.String standardPageFormat, java.lang.String orinetation) - Generates a pdf file from given URL and saves it to a given filename using paper size and orientation

public void addReportParameter(java.lang.String name, java.lang.String value) - Adds parameters to be used for generation of the report - this method can be used multiple times to add multiple parameters. Please note that this is persistent and once added the parameters will be used until cleared. See clearReportParameters method.

public void clearReportParameters() - Clears all the report parameters set previously using addReportParameter.

5. Screen illustrating the setting of the properties inside the Oracle Forms builder

You can note on the screenshot  below the bean implementation property of the Bean Area is set to sferyx.administration.pdfgenerator.PDFGeneratorOracleBean:

Our Services and assistance

All Sferyx products are assured with continuous e-mail support. With the retail products is included in the price 30 days startup support. Additionally, you can purchase annual support subscription tickets from our web store.

Sferyx offers also a wide range of customization services for its products in order to satisfy any customer requirement. We can adapt our products to fit the customer needs and any kind of integration requirements. We execute also express developments, customization under request, development of new features on demand. You can request a quote at sales@sferyx.com or support@sferyx.com indicating your requirements and the terms of delivery.

 

Copyright © 2002-2010 Sferyx Srl. All rights reserved. Sferyx and the Sferyx logo are registered trademarks of Sferyx Srl. http://www.sferyx.com