Gererate report using 1 to many table

[ColdPolarBear]

we are using CR-2008 with SQL-2005
I am trying to build a report using a one to many table.

Sample table:
RowID UserID Decision Decision_Date
1 23 8 1/5/2009
2 23 12 2/5/2009
3 41 16 2/10/2009
4 41 16 4/15/2009

Report Requirements:
UserID Decision8 Decision12 Decision16
23 1/5/2009 2/5/2009
41 2/10/2009
41 4/15/2009

Any assistance woud be appreciated.

 

[kenhamady]

This method might help:

http://www.kenhamady.com/form16.shtml

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/