If you are joining straight to the tables in the database, the best that I can think of is to bring a comma delimited or tab delimited string of the various fields.  This would be done by appending the field desired into a shared stringvar that would be displayed in the group footer (the detail would be suppressed)

 

You might be able to do it with self joins, but that doesn't fun at all.

 

The last option is to use stored procs to create the data table that you want.  If the number of fields that will be displayed across the report is unknown or limitless, this is not an option as the format of the datatable must be known before hand or CR will not be happy and the report will not work...which kind of leads us back to the first option, since a field can be set to can grow, but it is all up how the data lays out and what is acceptable in the final report.

 

HTH