We are integrating APEX reports with our exisitng appln. Is it possible to display the report labels dynamically from another table?
For eg report query select budget_fy, div from PROJECTS;
We have table where we store label for budget_fy as label and div as Division
So is it possible to show the label for the columns as year and division.
( We do not want to change it from the builder)
Like Ravi explain, it's not possible to do it at the column attributes using PL/SQL.
I found a work around for this one.
Use items to store the labels and reference those items in the column attributes.
ex.: item P1_RPT_01_LBL_COL_01 contains the following text : column 1
set for the column attribute heading this value : &P1_RPT_01_LBL_COL_01.
result: the column heading will display column 1
Now you need a Process before Header to set values into the items used for the column headings. (User can input those values using a form...)
Homepage : http://www.insum.ca
Blog : http://insum-apex.blogspot.com