This content has been marked as final. Show 3 replies
With Interactive Report, it does not seem possible. With non-interactive version, it is possible using PL/SQL function to return colon delimited string of column headings.
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
That is great to hear. Thanks for sharing that idea. I am sure Alex will be able to follow your direction, and create dynamic headers.