Is there any limit on number of referenced columns in a report?

poojasutar
ServiceNow Employee
ServiceNow Employee

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,

find_real_file.png

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.

10 REPLIES 10

Midhun1
Giga Guru

Hi,



Go to Reports > Administration > Properties and check there.


poojasutar
ServiceNow Employee
ServiceNow Employee

Hi Midhun,



Thanks for your reply. But I din't find the property there related to column limit.


Chuck Tomasi
Tera Patron

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.


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.