Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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.