It sounds like you're encountering an issue when trying to create a report with more than 25 form fields selected via a slush bucket interface, specifically when dot walking to variables for a catalog item.
Yes, there are typically limitations when working with large numbers of columns in ServiceNow reports (assuming you're working with ServiceNow based on your description). Here are some potential causes and solutions:
Column Limit Restrictions: Many platforms have built-in limits on the number of columns that can be included in a single report. ServiceNow typically has limits around 20-25 columns in some contexts.
Query Timeout: Complex queries with many dot-walked fields can time out, especially if they're traversing multiple tables.
Performance Optimization: When you dot walk through variables, each one creates additional database joins, which can significantly impact performance.
Solutions you might try:
- Split your report into multiple smaller reports with fewer columns
- Use a scripted report instead of the standard reporting tool
- Create a custom table that consolidates the data you need
- Check if there are any system properties that can be adjusted to increase the column limit (would require admin privileges)
- Consider using a different approach like exporting the data to Excel and manipulating it there
I'd recommend checking your instance's documentation or reaching out to your ServiceNow administrator to confirm the exact limitations for your specific setup, as these can vary based on version and configuration.
