Report Column Limitations Workaround
From SmartWiki
You are currently restricted to a maximum of 30 columns in a report. If you need more that 30 columns you may be able to use the following workaround.
1. Create a new custom field at the entity level and set the field type to calculated field.
2. Set the expression of the field to concatenate the values of multiple fields to be combined into this single field for reporting as in the example below:
frm.cf_12345.value+'|'+frm.cf_12346.value+'|'+frm.cf_12347.value+'|'+frm.cf_12348.value+'|'+frm.cf_12349.value+'|'+frm.cf_12350.value
In this example, six fields are combined into the calculated field.
The fields to be concatenated are referenced by the field id e.g. CF_12345 and the form object (the actual page) frm.
The "+" operator functions as the concatenation operator.
In this case the fields will be separated by a bar "|" character.
3. When creating the report using this field and you will not need to reference the six fields that were used to create this field.
Important Notes
Do not suppress this field via a role permission or display on a tab.
This field must be displayed on the page when the entity is saved, otherwise the concatenated value will not be saved and the report will appear to be incorrect.
If associated with UTA level 2 entities that are edited in List View this field must also be included.
