Show Recrods ColumnWise in Crystal Reports

See more:

database

reporting

Dear Experts and Fridns,
I have the following data in a table and I want to display it columnwise in Crystal Reports.

Student-ID Date  Status
10          3/6     A
10          3/7     P
10          3/8     P
10          3/9     L

11          3/6     P
11          3/7     P
11          3/8     A
11          3/9     P

I want to display in Crystal Reports the following way.

Student-ID      Month    Status
10               3         A      P       P      L
11               3         P      P       A      P

Please help me, what to do.

Thanks.