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!

How to display the column dynamically in IR?

Navyashree K CNov 17 2023 — edited Nov 20 2023

Hi ,

I have a Interactive grid report when I select one row in IG the data related to it should display in the below region i.e IR .

Column names are displaying dyamically ..

Example

I have 2 records in IG

When I select ID 1 IR region will display below data

when I select ID 2 IR region should display

The query is returning the correct value dynamically in the DB.

But when I am selecting ID 2 I am getting below error.

ORA-00904: "D"."18-Aug-25": invalid identifier .

When I check in the developer page I could see 18-Aug-25 column . But we don't want 18-Aug-25 when i select the ID 2 . How can I change the column names and columns dynamically?

Added on Nov 17 2023

#apex, #apex-discussions, #apex20-2, #oracle, #oracle-apex

7 comments

823 views

1 mention