Skip to Main Content
Feature Request FR-2401
Category Page Components
Status IN REVIEW
Tags

25 Voters

Allow me to define headings in my IR/IG (like in a Classic Report)

Mar 24 2022

Idea Summary
The Classic Report allows me to add generated headings. It gives 5 options: Column Names, Column Names (InitCap), Custom Headings, PL/SQL Function Body, None:  

I love this powerful feature and I'd like to have the same flexibility for the Interactive Report and Interactive Grid.

Use Case
Any use case that would apply to a Classic Report would apply here too. Let's say I want to use one report to display the fields and results of a variety of queries. I can do this with a Classic Report but I'd like to be able to do with an IR/IG because these reports have obvious advantages over the Classic Report.

IN REVIEW : This submission is currently in review by the Oracle APEX product management team.

Known Duplicates

FR-2458
Add dynamic columns to a report

Comments

Comments

  • jorge rimblas 3 months ago Edit

    I've always been disappointed that this feature was missing from the IR

  • ino.laurensse 3 months ago Edit

    Absolutely. I've created variable IR column headings using hidden page items, but it is a pain to do that.

  • gemma 2 months ago Edit

    Great feature in classic reports which should be universally available in other report types.

  • fac586 2 months ago Edit

    Let's say I want to use one report to display the fields and results of a variety of queries. I can do this with a Classic Report but I'd like to be able to do with an IR/IG because these reports have obvious advantages over the Classic Report.

    What is the actual use case for this? As Oracle have repeatedly pointed out, those “obvious advantages” are predicated on IR and IG data sources returning an immutable set of columns: same number, same names/aliases, same data types.

    There are situations where dynamically labelling the columns would be useful—e.g. matrix reports and reports on APEX collections—but a single report region returning heterogeneously shaped data is not feasible.

  • jsheppard 3 weeks ago Edit

    Here is a use-case…

    There might be a hundred columns of data in a table. Each user may only have an interest in half a dozen columns out of the full set of 100 and a different half dozen for each user.

    Imagine a page on which the user can choose which columns are of interest to them out of that 100. The requested data, for a range of rows, is to be displayed to the user in a table/grid AFTER the user has selected which columns they like.

    The SQL query's SELECT clause cannot be a hard-coded list of columns since it is determined by the user at runtime.

    However, a PL/SQL method could be defined that accepts the list of columns of interest selected by the user as a parameter. The method could dynamically build SQL for the columns specified and then return only that data wrapped up in a single JSON/XML CLOB.

    The CLOB could contain not only the rows of data, but their column labels. Apex then presents a table with the column labels defined in the CLOB as well as the rows of the data, also found in the CLOB.

    Apex would need to define the structure of the JSON/XML it expects to receive to build the table. Developers would need to adhere to that structure when defining the CLOB returned by their PL/SQL method.

  • jayson hanes Admin 3 weeks ago Edit

    @jsheppard thanks for the detailed use-case

  • anton nielsen 3 weeks ago Edit

    @fac586 and @jayson hanes

    The video below shows the use case that allows a single report (classic or IR) to report on every table available in the schema. 

    https://www.youtube.com/watch?v=fuA8_RbFk00

    If you start at 2 minutes 15 seconds and watch it will show how to do this with both a classic report and an IR.

    You can also install the APEX application from my Git repo

    https://github.com/ainielse/rando

    It is the f_one_report.sql file.

    A single IR works for every table in  you schema.

  • ino.laurensse 3 weeks ago Edit

    @anton: that is just the problem with the IR: you created 60 hidden items.

  • anton nielsen 3 weeks ago Edit

    @ino.laurensse

    Exactly! That's why this is a good idea. So that I don't have to do that.