One way of doing this is to put the data into an array, then put fields down on the report that reference your array.

You can then load the array based on your users preference. This work as well for data grouping.

Simon