Adsense Ad

Friday, 24 January 2020

Oracle Reports: Compress PDF

PDFCOMP

indicates which components can use the PDFCOMP keyword.

Components That Use PDFCOMP

rwclient = yes 
rwrun = yes 
rwbuilder = no 
rwconverter = no 
rwservlet = yes 
rwserver = no
Description  
Use PDFCOMP to specify whether PDF output should be compressed.
Syntax PDFCOMP=value|{YES|NO}
Values 
  • value Any value 0 though 9. A value of 0 means PDF output will not be compressed. A value of 1 through 9 will compress the PDF output and permit users to control the compression level.
  • YES Compresses output at compression level 6.
  • NO Compresses output at compression level 0 (no compression).
Default 6

Oracle Reports: REPORTS_JVM_OPTIONS

REPORTS_JVM_OPTIONS

Description This environment variable specifies any JVM options that you want Reports Builder, Reports Runtime, or Reports Converter to consider when it starts its JVM. For example, you can use this environment variable to specify the starting heap size and maximum heap size for the JVM, additional classpath entries, and so on.
Valid Values  List of JVM options in the JVM command line syntax.
Default  -Xmx256M
Usage Notes

  • The default value -Xmx256M specifies the JVM heap size of 256 MB to avoid the Out Of Memory error when running reports with large graphs or running big reports.
  • When the Reports Engine starts up, it checks for JVM options specified in the server_name.conf file in the jvmoptions attribute of the engine element. For more information, see Section 3.2.1.4, "engine". If specified, the JVM options set in server_name.conf override the value of the REPORTS_JVM_OPTIONS environment variable. If not specified in server_name.conf, Oracle Reports uses the JVM options specified by the REPORTS_JVM_OPTIONS environment variable.
  • When running reports with Reports Server, JVM options cannot be set using the REPORTS_JVM_OPTIONS environment variable. For Reports Server, set JVM options on the command line using the JVMOPTIONS command line keyword. For more information, see Section A.3.46, "JVMOPTIONS".
  • When running reports with Reports Builder, Reports Runtime, and Reports Converter, JVM options specified on the command line with the JVMOPTIONS command line keyword override JVM options specified by the REPORTS_JVM_OPTIONS environment variable.

Oracle Reports: REPORTS_GRAPH_IMAGE_DPI

REPORTS_GRAPH_IMAGE_DPI

Description This environment variable specifies a dots per inch (DPI) value for graphs output to a PDF file or a printer. The default value for this environment variable is set at 72 DPI to minimize the time taken to generate the report as well as to reduce the report file size.
If you specify a value higher than 72 DPI, you will see an improvement in the image resolution for graphs sent to a PDF file or a printer. However, this affects the time taken to generate the report output as well as the file size.

Note:
With the value of REPORTS_GRAPH_IMAGE_DPI=250:
  • The time taken to generate a report with a graph increases 5 to 6 times when compared to the time taken to generate the same report with the value set to 72 DPI.
  • The PDF file size also increases 5 to 6 times.
Valid Values  72 through 300
Default  72
Usage Notes

  • On Windows, use the registry to specify the value. On Unix/Linux, set the environment variable in reports.sh.
  • When you set a higher DPI value, you may also need to change the JVM heap size value through REPORTS_JVM_OPTIONS to avoid the Out Of Memory error for the JVM.
  • This environment variable is not supported in Oracle Reports distribution functionality, as it is specific to PDF and printer outputs only.

Oracle Reports: REPORTS_IGNORE_IMAGE_TAG_RES

REPORTS_IGNORE_IMAGE_TAG_RES

Description This environment variable is useful when a report includes certain image formats that have the ability to store the physical size of the image, which usually includes resolution and pixel dimensions. To ensure the image is not scaled to the physical dimensions, you can set this environment variable to YES to specify that Oracle Reports should ignore image resolution information and only use the pixel dimensions of the image. This ensures that this type of image from a database column is displayed correctly instead of displaying as a thumbnail.
Valid Values 
  • YES Oracle Reports ignores image resolution information, and uses only the pixel dimensions of the image.
  • NO Oracle Reports does not ignore the image resolution information in the image.

Default NO

Oracle Reports fast processing of images

REPORTS_JPEG_QUALITY_FACTOR

Description This environment variable specifies the level of image quality desired for JPEG images. It provides control over the trade-off between JPEG image quality and size of the image. The better the quality of the image, the greater the image file size.
Valid Values  0 through 100
Default  100 (highest quality)
Usage Notes

  • On Windows, use the registry to specify the value. On Unix/Linux, set the environment variable in reports.sh.
  • If REPORTS_JPEG_QUALITY_FACTOR is not specified or incorrectly specified (for example, set to a string or an out of range value), the default value is used.
  • A value of 75 provide a good quality image, while ensuring a good compression ratio.