How to read NEXT

[crystal2770]

How do I Produce the following.. Ive been trying for a while and cant figure this out..

this is what is in my report detail

Client # Name Ins Type Ins
123 Ann Primay A
123 Ann Secondary B
123 Ann Tertiary C

I need..
Client # Name Primary Secondary Tertiary
123 Ann A B C

THANKS FOR HELPING

 

[lbass]

Insert a crosstab in the report footer where you use client # and name as rows, ins type as the column, and maximum of Ins as the summary field.

-LB

 

[crystal2770]

Thank you, that worked nicely