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

‎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,

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.

Preview file
30 KB
  • 4,416 Views
10 REPLIES 10

doughanna
Tera Contributor

‎06-29-2023 08:00 AM

Agreed - this issue is problematic for us as well.  We've had to resort to column windowing/chunking.  Where we use multiple reports to grab sections of the columns and coalesce on sc_req_item.number or sc_task.number in Excel.  Adding insult to injury - this requires multiple scheduled reports (one for each report that needs to be run), and is a total pain with the miniscule window sizes for Available and Selected.  No, the new reporting UI isn't more helpful in that it displays more columns - actually less because your constantly popping having to reselect the variable set to make adjustments.

 

Seriously - The entire reporting tool needs (and has needed) a foundational rewrite for several years now.  Not just new lipstick on the pig that the new UI has - but a rethinking of customer's needs and how it foundationally operates.