When using APEX 4.2.1 with the Instance Setting: Report Printing: Print Server = Oracle APEX Listener. I use an after processing branch call to PRINT_REPORT=REPORT_PDF. The Report Query for REPORT_PDF has Source Query: "select 'A & B' DESCRIPTION from dual" which uses Report Layout "LAYOUT_7".
When I choose Output Format="XML" for the Report Query, the description field is returned as 'A & B' which is rendered as 'A & B' in browser.
When I choose Output Format="PDF" for the Report Query, the description field is returned as 'A %26amp; B' which is rendered as 'A %26amp; B' in Adobe Reader.
How do I get the Adobe Reader to output 'A & B'?
Thanks for the quick reply!
I should have mentioned that I used an example to demonstrate the issue. The actual query is pulling the value 'A & B' from a table where the VARCHAR2(240) column. It is populated by a free form text field which means that I need a solution for all special characters as well.