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!

Apex Report - How to display a report column (name column with static values) when the report is not

SACH!N-OracleFeb 14 2017 — edited Feb 20 2017

Hi,

I've a requirement.

i developed an apex report, with columns say A, B, C.

A - Name Column (say 'Phase Names)

B - Status of column A (say, 'Phase Status')

C - Description/Notes

Phase NamePhase StatusNotes
Starterxxxxxx
Installxxxxxx
Provisionxxxxxx

As per the current settings, when there is no data in the report, it'll display the:

'No data found'

message, in the report page.

But i need to display the report in the below format during the 'No Data Found' case:

Phase NamePhase StatusNotes
Starter
Install
Provision

That is, the 1st column of the report should display always, even if there's no data.

Kind of hard coded case. I didn't find any report template supporting this.

So i thought of creating an 'Interactive Table' region, with hard coded values in the 1st column (col A) & dynamic values in the 2nd & 3rd column (col B & C).

But i couldn't find any template for TABLE in my Apex Application.

Is there any template in Apex for these kind of TABLE STRUCTURE

(or)

Is the TABLE template is available in any other Apex PLUGIN (s)

(or)

Is there any REPORT TEMPLATE supporting my requirement

Please advice/help.

Thanks,

Sachin

This post has been answered by Sven W. on Feb 14 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2017
Added on Feb 14 2017
11 comments
6,777 views