Creating Columns for Detail Data

[mwake]

I'm using CR 2008 with an Oracle 10g db as my data source. I created a registration details report which grouped by event type and currently prints like this:

Drug Product Valium
Indication Anxiety
Package Blister 100
Shelf Life 12 months
Storage Cond Store between 2-8C
Prod Mfg Acme Co

There can be multiple packages, indications, or manufacturers. My challenge now is to create a report that groups these entry types in columns (indication, package/shelf life, mfg) for the same submission number, and still avoid duplication if one column has multiple entries. Can I use some sort of formula to parse the data into columns?? I've created a report with 3 subreports for each of the entry types but performance is bad. Any ideas??

 

[lbass]

So when there are multiple values for some field, on what basis would you be choosing the value to display? You could place these fields in the detail section, group by the submission number and then sort by each field that has multiple values in such a way that the desired value is in the first row, and then just move the fields into the group header and suppress the details. Or apply some criterion for the desired value and create a conditional formula that you then insert a maximum on at the group level. Or you could collect the multiple values into a string that is then displayed in the group footer.

-LB