Is there any limit on number of referenced columns in a report?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-16-2016 02:23 AM
I am creating a report on Requested Item table with type List. I am trying to add variables into the report. when the column count crosses 40, it gives me error below,
There is no access rule problem as I am able to see any variable until it crosses count of column 40. That is only in the case of Variables, because I can populate more than 40 columns if they directly from the table I am creating a report for.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-16-2016 02:53 AM
Hi,
Go to Reports > Administration > Properties and check there.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-16-2016 03:35 AM
Hi Midhun,
Thanks for your reply. But I din't find the property there related to column limit.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-16-2016 03:28 AM
Hi Pooja,
There is no limit that I am aware of, however that doesn't mean one does not exist. 40 columns on a report is a lot. You may want to reconsider your approach. If you feel your requirements validate the need for so many columns, enter a HI ticket and let them know. This could be a bug or it could be a limit that the developers need to consider raising.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-16-2016 03:33 AM
Actually, I tried with more than 40 columns as well but, those were simple columns from table and it generated report as well without any error. I am facing this issue only for Catalog Item Variables.
Anyways Thanks for your reply.