Solved

Courious Problem with Report Server

Posted on 2004-08-06
4
7,332 Views
Last Modified: 2012-06-21
hi experts,

i have done a report from scratch with the reportbuilder 6i,
as allways.

after transport this report to the report server on the web and calling this report with my 6i web-app, the reportserver geneartes a defective pdf-file. usual it looks like the file is truncated somewhere because the end-sequence of the pdf is missing
--> %%EOF

usual the problem seems to be on the report self, because older and other reports
are produced correctly.

can give me anyone a hint about this problem?

Thanks

meikl ;-)
0
Comment
Question by:kretzschmar
  • 2
  • 2
4 Comments
 
LVL 4

Accepted Solution

by:
ramumorla earned 350 total points
ID: 11735083
Pretty simple-- Reports on C/S works fine with whatever fonts you worked on But once you exported the same report onto web your fonts will be disturbed- So you need to set them right

0
 
LVL 27

Author Comment

by:kretzschmar
ID: 11735122
well, thanks for this suggestion, i know about this font,
so i use only one font there, but i will check the the font-metrics
i have used in this new report

will be back soon

meikl ;-)
0
 
LVL 27

Author Comment

by:kretzschmar
ID: 11735270
yep, its a font problem, did not know which part, after as i replaced all used fonts/heights/weights the report works, but looks of course very ugly

i raised the points a bit and thanks for your fast help

meikl ;-)
0
 
LVL 4

Expert Comment

by:ramumorla
ID: 11735311
ORACLE REPORTS 6i RESTRICTIONS:
===============================  

COMPRESSION
-----------

In Oracle Reports 6i and previous releases, it was identified that very large PDF report files were created when they contained a  compressed image (.jpg) or an uncompressed image (.bmp).  In Oracle  Reports 6i, there is no capability to compress the images in the PDF  file.  Oracle Reports has its own PDF driver that does not use  many of the additional Adobe facilities such as compression.  An enhancement request was accepted to incorporate more Adobe  features in the Oracle PDF driver.    

MULTIBYTE
---------

Oracle Reports Developer and Reports Server 6i Release

Notes
 --  

Supported PDF Version Reports supports PDF 1.1.            

The Adobe Acrobat Reader cannot read .PDF report files generated            by Report Builder if the report contains certain types of non-            English character set languages (typically multi-byte) or            Unicode character set.  However, you could generate the            Postscript from Reports (making sure that Reports is referencing            the correct fonts in the Postscript output), and then feed the            resultant Postscript file into Adobe's Distiller program with            the "Embed all fonts" option enabled.  This should result in a            PDF file that has the subset fonts embedded.  Then use Acrobat            to generate the Postscript with the embedded fonts.  

ORACLE REPORTS 9i:  PDF ENHANCEMENTS OVERVIEW =============================================  

Adobe's PDF has long served as the output medium of choice for  'Board Room' quality reports, so we have upgraded our driver to  version 1.4 of the standard.  

COMPRESSION
-----------

Reports 9i makes use of enhanced data compression. This means: ·      Smaller PDF files        - Compressed files about 1/5 the size of original file.  ·      Makes viewing and downloading quicker  ·      Saves space       - Amount of space saved varies based on the contents of report       - Some of the factors that contribute to compression rate:             - Number of images versus the amount of text.             - Items like images are typically already compressed,                    so report containing large number of images will not see               much compression as those without images.             - Large amounts of data can achieve higher compression rates             - Multiple fonts, styles and templates can achieve higher                compression rates although will vary  ·      PDF output will be compressed by default.         -Can be switched off or varied with command line options.         -There is a command line parameter, PDFCOMP, to accommodate           outputting PDFs as non-compressed.  

MULTI-BYTE CHARACTER SUPPORT
 ---------------------------- ·

Reports9i supports displaying of multi-byte characters in PDF.  ·      Can produce reports that display text in:       - Chinese Simplified       - Chinese Traditional       - Japanese       - Korean  ·      For this to work, the Adobe Asian font packs must be installed on          your system.               - These font packs can be downloaded from Adobes Web site.                  http://www.adobe.com:80/products/acrobat/acrrasianfontpack.html  

FONT EMBEDDING  
-------------- ·      

Can embed fonts into the report itself.       - Makes the font portable to another system where the target font            does not.  In other words, font does not have to be installed on            every machine where report is run.       - Establishes and maintains a standard look and feel for report no            matter where it is distributed.  ·      Embedding is only supported for Type1 single byte fonts       - Cannot embed the following fonts:             * TrueType             * Multi-byte              * Unicode       - Multi-byte and Unicode fonts are not supported due to the             megabyte sizes required to accommodate these fonts, which would            make report size unreasonable.  ·      It is implemented in the uifont.ali file and enables developers to          embed a font that is installed on the system in a PDF report.   ·      You can specify which fonts you need to embed and/or subset in          uifont.ali in the newly created sections called PDF:EMBED and          PDF:SUBSET to make it effective in Reports.  You don't need          Acrobat Distiller to embed.  ·      This feature requires Acrobat 4.0 or higher.  ·      An example is barcode fonts. You can embed the specific barcode          font directly into the PDF document so the client does not have to          have the barcode font installed in order to view the document          correctly.  

FONT SUBSETTING
 --------------- ·      

Fonts are included in the report itself (similar to embedding).  ·      Subsetting includes only those characters used in the report.  ·      Have a custom font set created and stored in the report consisting          of those characters in the report.  ·      You can view the fonts contained in your PDF file using Adobe Acrobat          Reader by choosing File>>DocumentInfo>>Fonts.       - Shows dialog box with all fonts contained within the open document.  

FONT ALIASING
 -------------

 Font aliasing has been supported for some time in Reports (uifont.ali).   Now, in Reports 9i, font-mapping can be provided for PDF fonts. Font-aliasing  is supported for single and multi-byte fonts.  

ADA, SECTION 508
 ----------------- ·      

The American's with Disabilities Act requires that output is          accessible to users using screen readers.  ·      Adobe added features in PDF 1.4 allowing screen readers to "read"          PDF documents with Adobe Acrobat Reader 5.0 and an accessibility          plug-in.  ·      Reports added properties to allow developers to specify the tags          to use when producing PDF output.  

EXAMPLE
=========

Problem:  How do you generate PDF output for the Korean characterset?  

Answer: There are three solutions available for this in Reports 9i.  

a) PDF Multi-Byte font aliasing  

b) PDF font subsetting  

c) PDF font embedding  

              a) PDF Multi-Byte font aliasing     You can choose option "a" if you don't want to embed the fonts inside     the PDF document. It means the person seeing the PDF document has to     have the fonts installed on his/her machine. You will need to download     the AsianFontPack from Acrobat site (free download) which contains the     CID fonts for Chinese, Japanese and Korean. This would get installed in     the Acrobat Reader directory.      You can now mention the CID font name to be used for Korean character     set in uifont.ali file in the [PDF] section.     .....ko16ksc5601="HYSMyeongJoStd-Medium-Acro"      (set your NLS LANG for example american_america.ko16ksc5601 for Korean      character set)      There is good amount of details given in the Uifont.ali with samples.     You can refer to them.   b) PDF font subsetting      You can choose this option if you want to generate your PDF output     fully portable, meaning you can view across the platforms and no need     of having the fonts installed in the machine where this PDF document     is being viewed. In this solution, subset of the font information (for     the used characters only) is embedded with the document itself      You have to specify the TrueType font files for the font names you     have used in your report in the uifont.ali file under [PDF:SUBSET]     section like:    Arial = "Arial.ttf"     and ensure you have added the path of your fonts directory to the     REPORTS_PATH.    Please refer the notes in the uifont.ali for more details.      Font subsetting is supported for TrueType fonts. To view the subsetted     PDF in the Reader with a better resolution, use the Acrobat's workaround     mentioned in the Reports release notes.   c) PDF embedding     This is meant for postscript Type1 single byte fonts and would embed     the whole font with the document, and for this you would need to specify     the AFM and PFA files in [PDF:EMBED] section. However, for MultiByte      characterset, the option "a" or "b" is recommended since embedding     whole fonts in option "c" for MultiByte characters would increase the     file size to very large value.  
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now