How to get different values from the same field without grouping

[icdu]

I have a problem where i have a field with multiple information in it. I have 2 databases, 'RptASample' and 'RptTrendDefinitions'. 'RptASample' hase fields 'TrendNdx', 'Date' & 'Value'. 'RptTrendDefinitions' has 'TrendID' & 'CellNumber' (and some others that aren't relevant to what i am doing). The linking fields are 'TrendNdx' and 'TrendID' (they are the same thing, just named different). The field 'Value' in the RptASample database has information A, B & C which i want to display on a page next to each other under headings A, B & C (with the date in front of them). The field 'CellNumber' in 'RptTrendDefinitions' is what differentiates these items from each other (eg. CellNumber = 200 is for A, CellNumber = 779 is for B, CellNumber = 763 is for C).
Can anyone help. I don't want to group these as they would all appear on different pages. I need to see all of the values for a particular date.

 

[cmpgeek]

have you tried creating a cross tab report?
it has been a while since i have done a cross tab, but it might be an option...

good luck

 

[icdu]

Thanks, i will give it a try.