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

[poojasutar]

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.

[doughanna]

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.