Skip to Main Content
Feature Request FR-3849
Product Area Page Components
Status CLOSED

1 Voters

IR: show selected columns when no data found

mos Public · Jun 20 2024

Idea Summary
for Interactive Reports, it would be nice to have an option to get columns even executed query returns no row.

Use Case
end user will get a better idea about the result on the page. 

Preferred Solution (Optional)
a "show/hide column names when no data returns" switch on report attributes tab.

We reviewed this idea carefully, and while it was interesting, we concluded that it is unlikely to make its way into APEX in the foreseeable future.

Comments

Comments

  • fac586 OP 1.4 years ago

    Who or what requires this?

    Rendering report headings when no data is returned violates accessibility standards. Visually impaired users do not want to listen to a screen reader reading a list of column headings for which there is no data.

  • mos OP 1.4 years ago

    @fac586 well why is it there on IG then?

  • fac586 OP 1.4 years ago

    @fac586 well why is it there on IG then?

    Interactive grids support data editing and my understanding is that the column headings are rendered to efficiently facilitate creation of initial rows where none previously exists.

    I remember there being a thread about that somewhere but I can't find it at present.

  • mos OP 1.4 years ago

    @fac586 in other words; you can have it without violating accessibility standarts. I suggested an on/off switch, not a forced behaviour.

  • fac586 OP 1.4 years ago

    That was Oracle's opinion, not mine, and it doesn't apply as justification for doing so on read-only reports (or read-only IGs for that matter).

    Accessibility requirements override almost all other considerations, so you need to provide compelling reasons for doing so. What benefit is there in displaying column headers with no data, instead of a clear, concise, easily accessible message that no relevant data exists?

  • vincent morneau Admin OP 1.2 years ago

    @mos we are closing this idea for now, but may revisit in the future. This work would be quite involved and other priorities don't allow us to put it in the roadmap.