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!

Adding HTML Tables into output of Classic Report

Richard LeggeSep 23 2014 — edited Sep 24 2014

Good Day all.

APEX 4.2.5 XE 11.2 Theme 26.

Im trying to produce a classic report that looks like an invoice.. Letterhead at the top, and several embedded separate table areas that contain a mix of static text, and data retrieved.

No matter what I try, I cannot seem to get embedded table borders to show up..  The data shows up, and its all formatted and aligned correctly, but no borders.   Ive tried pretty much all of the report templates..

An example of my SQL is as follows:  (obviously I'd be inserting data into the tables at various points..)

select '<table border="3" cellpadding="1" cellspacing="1" height="134" width="381">

    <tbody>

        <tr>

            <td colspan="2" style="text-align: center;"><span style="font-size:18px;">Invoice</span></td>

        </tr>

        <tr>

            <td>

            <p style="margin-left: 40px;">Date:</p>

            </td>

            <td style="text-align: center;">

            <p style="margin-left: 40px;">23-Sep-2014</p>

            </td>

        </tr>

        <tr>

            <td>

            <p style="margin-left: 40px;">Invoice No:</p>

            </td>

            <td style="text-align: center;">123456</td>

        </tr>

    </tbody>

</table>'

from dual

If anyone knows how I can achieve this, (or ideas on how to create and invoice type report)   I'd be grateful.

Kind Regards

Richard

This post has been answered by fac586 on Sep 23 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 22 2014
Added on Sep 23 2014
11 comments
2,854 views