This content has been marked as final. Show 7 replies
When this option is selected, then there should be a text area shown right underneath the radio group with the label "Function returning colon delimited headings: (Value Required)". In that text area you should see that function - if one is defined, or enter your own PL/SQL function.
It turns out that APEX does not display the text box for the column heading function if there is a lot of columns in the query. It appears to be a bug. I tried I.E, Firefox and Chrome but all had the same problem. To fix this, I had to do the following::
- In 'Region Definition' tab, change 'Maximum number of generic report columns:' to 10. It was initially set to 200.
- Go to 'Reports Attribute' tab and the text box now appears for the column heading.
- Edit the function and change back 'Maximum number of generic report columns:' to the original value.
Hopefully this can help some one who has stumbled across this issue.
It's not a bug in the sense you think. Who in their RIGHT mind could review a report with over 60 columns (let alone 100)?
I think you need to review your requirements, since there is a know limit of columns that can be produced in a report...
If I presented a user with a report that large, how would they print it?
Just a thought here..
I would certainly agree with Tony that 60 or 100 columns are a bit much. But there should be some indication why something is not working, even if it's only a message stating that there's only a certain number of columns supported. So I'll log a bug to improve this in APEX 5.0.
Believe it or not but all the columns do get used. The users do not print these reports but they use the different data elements for various functions, mostly analytically stuff.
Thanks for logging this bug. I do agree that there should be some kind of indication why the user cannot see the text box. Thanks again for all your help.