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

2 Voters

Add dynamic columns to a report

marko.granzin Public · Apr 22 2022

Idea Summary
Currently the columns are Static anerlog to a Select Statment. However, it is possible to create dynamic SQL statements with different number of columns using the table function.  Here it would be nice if Apex could do that out of the box.

(Currently we use placeholders and fill them and then rename the header via Javascript. )

Use Case
Our application contains process data of machines  unknown to us, which should be displayed in a table in a reasonable way. 

Preferred Solution (Optional)
One idea for this case would be to make a select for the query and a select for the header of the table. 
Another would be that the result of the query is a json containing all relevant data.

This request is likely a duplicate of FR-2401.

Comments

Comments

  • fac586 OP 3.9 years ago

    What is meant by “report”?

    This is currently available in Classic Reports, using a Function Body returning SQL Query region source, with the Use Generic Column Names option enabled, and a PL/SQL Function Body Heading type.

  • marko.granzin OP 3.9 years ago

    Actually we are using die interactive report, because of the calculation and visualisation feature.

  • fac586 OP 3.9 years ago

    Duplicate of FR-2401

  • svijay OP 3.9 years ago

    @fac586 do u have any implementation video. cant find the right ones on the internet