This might be dumb question. But why do get this error with a IR report? and what is the solution for this. Please help me with this.
Error 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.
Oh.. And also i have a blob column.. if the format is not given, then the table is fine.. but happen to get this error only when the blob download format is given.
Thanks and regards
Edited by: JB on Mar 30, 2012 11:08 AM
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)
Thanks for the response. sorry for the delay too. I think your post really worked as a charm. its just this statement dbms_lob.getlength which did the trick. Thank you once again.
Thanks and Regards,
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.
James, could you post the solution to your problem? I have an IR using the select xxxx from Table(collection) also and am getting the same error.
Edited by: BillArms_GS on Oct 19, 2012 3:43 PM