We're using a multi-select list to populate the column types of our re

[amsthompson]

We're using a multi-select list to populate the column types of our report.&nbsp;&nbsp;So while designing the report, I don't know how many columns I need.&nbsp;&nbsp;Is there a way I can create a collection or set of this field, and group it horizontally, similar to how crystal allows for vertical grouping?<br><br>So for example, if the list is:<br><br>Please Select Football Team:<br>Redskins<br>Cowboys<br>Eagles<br>Giants<br>Cardinals<br><br>and the user selects the Redskins and Cowboys, I need the report to look like<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Redskins&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Cowboys<br>Group 1<br>&nbsp;&nbsp;&nbsp;&nbsp;Sub group a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;xx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;xx <br>&nbsp;&nbsp;&nbsp;&nbsp;Sub group b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;yy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;yy<br>&nbsp;&nbsp;&nbsp;&nbsp;Sub group c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;zz&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;zz<br>Group 2<br>&nbsp;&nbsp;&nbsp;&nbsp;Sub group a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XX<br><br>etc.<br><br>Any help would be appreciated<br>Thanks<br>&nbsp;&nbsp;&nbsp;&nbsp;<br><br>

 

[amsthompson]

We're using a multi-select list to populate the column types of our report.&nbsp;&nbsp;So while designing the report, I don't know how many columns I need.&nbsp;&nbsp;Is there a way I can create a collection or set of this field, and group it horizontally, similar to how crystal allows for vertical grouping?<br><br>So for example, if the list is:<br><br>Please Select Football Team:<br>Redskins<br>Cowboys<br>Eagles<br>Giants<br>Cardinals<br><br>and the user selects the Redskins and Cowboys, I need the report to look like<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Redskins&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Cowboys<br>Group 1<br>&nbsp;&nbsp;&nbsp;&nbsp;Sub group a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;xx&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;xx <br>&nbsp;&nbsp;&nbsp;&nbsp;Sub group b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;yy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;yy<br>&nbsp;&nbsp;&nbsp;&nbsp;Sub group c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;zz&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;zz<br>Group 2<br>&nbsp;&nbsp;&nbsp;&nbsp;Sub group a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XX<br><br>etc.<br><br>Any help would be appreciated<br>Thanks