Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export to Excel doesn't shown line break in APEX classic report

PradoshApr 4 2016 — edited May 30 2016

Hi ,

APEX version is : 5.0

I have a classic report whose column headers are generated using dynamically. The headers are actually APEX items whose values are determined during report runtime and accordingly the Column headers are generated.

For example : One of the column header is like this : &P30_X1.</br>&P30_X1_UTIL.%

This works fine when the report is rendered in web browser . But when i export the report to Excel , the </br> doesn't seem to work .

Any pointer here ?

Thanks

Comments

Mahmoud_Rabie

Hi

If you could convert the classic report to interactive report, this plugin would help you much in formatting the exported Excel. Moreover, it will export it as XLSX.

- Process Type Plugin - (IR) Report to Excel (xlsx)

Please take a look at its demo here

https://apex.oracle.com/pls/apex/f?p=23131:LOGIN::::::

demo/demo

I hope that helps you or solves your problem

Regards

Mahmoud

unknown-851512

Also check Region2XSLTReport plugin: www.mirmas.si.

Demo: http://apex.mirmas.si/apex/f?p=111:34:

You can modify XSLT that ships with plugin to convert <br> to line break in column header.

TexasApexDeveloper

Because Excel doesn't handle HTML very well..  You could modify the way you build your labels such that if the report is being downloaded versus displayed to use a CHR(10) instead of <br> ..

Thank you,

Tony Miller
Los Alamos, NM

TexasApexDeveloper

This suggestion will incur more issues for the poster, since they probably had a reason to use a standard report versus an interactive report..

Thank you,

Tony Miller
Los Alamos, NM

Mahmoud_Rabie

That's why I said

If you could convert the classic report to interactive report,

Regards

Mahmoud

Pradosh

Thanks Tony, i will give it a try

Pradosh

Hi Mahmoud,

This is a classic report and the search fields are dynamically created , so converting them to a IR report is difficult .

Anton Scheffer

Why should you convert the report? The description says "This plugin uses the source queries of all report regions on a page, either a clasic or interactive"

1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 27 2016
Added on Apr 4 2016
8 comments
1,597 views