Dynamically Creating Columns 2

[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

 

[anandkuppa]

hi
i have the same problem..wud also be helpful if u have found any solution for this ...
thanks
anand

 

[FoxG]

Hi
this is basically the same approach as creating a list of all detail values in a group footer.

This can be achieved using a running total resetting to zero for each group, and formulae to build the list of headers / values.

You may be able to follow it better from a sample report
which I could send you.

Geoff Fox (Senior IT Services Officer)
Email: geoff.fox@salford.gov.uk

 

[anandkuppa]

hi foxg
it would be such a big help if you could send me a sample report. My email id is : anandk@transputec.com

thanks much

 

[3678156]

hi foxg
it would be such a big help if you could send me a sample report. My email id is : arif.vohra@aimmax.com

thanks much

 

[FoxG]

Email sent to Arif
Hope it will be useful.

Geoff

 

[FoxG]

Email sent to Rod Grosman
Hope it will be useful.

Geoff