This content has been marked as final. Show 7 replies
how many columns do you have in your report? Is it dynamic (using collections) or static?
There a some limits in IR reports and this depends which version you are using.
Check this link for limits for version 4.1 (same limits apply for 4.0)
i have set up a small test case on apex.oracle.com and I receive the same error if I use download format.
I have a table
test_blob (id number, name varchar2(10), blobcont blob)
If I create IR like
and then I define download format I hit the error.
select id, name, blobcont from test_blob
If you want this to work you have to change your query to
And then again define download format for blob on blobcont column.
select id, name, dbms_lob.getlength(blobcont) blobcont from test_blob
I am getting same error for table returned collection. Basically I have defined a collection and my function returns collection used like this
select col1,col2,col3 from TABLE(MY_FUNCTION);
in IR report. Error is..
"The number of display columns in the report reached the limit. Please click Select Columns under Actions menu to minimize the report display column list. "
Please help me.