Oracle Reports PDF showing boxes instead of new line character

Fahd Bahoo

Oracle Reports 11.1.2

Oracle Database 11g

Operating System: WINDOWS ( Both server and client )

DB Character set NLS_CHARACTERSET = AR8MSWIN1256

Windows Register NLS_LANG =AMERICAN_AMERICA.AR8MSWIN1256

New line character is showing as boxes when report is generated in PDF. Font is Arial.

In my report builder report is showing fine without these boxes, but when i

Can any one help please.

Thanks

Matej D.

Check this document and apply patch to fix the issue:

Reports PDF Output Displays a Squared Character When a Carriage-Return is in a DB Column (Doc ID 1296245.1)

Regards

Fahd Bahoo

Which document ?

Fahd Bahoo

Is there any workaround other then applying patch ?

Thanks

Matej D.

A workaround would be to remove the carriage returns in the select statement itself, for example:

-   SELECT replace(replace(COL1,CHR(13),''),CHR(10),' ') FROM TAB1

where COL1 is the problematic column and TAB1 is the table.

Regards

Fahd Bahoo

A work around i used to get rid of boxes, is to get the report in .RTF , in RTF boxes are not shown. this solved my problem.

Thanks for helping.