I have some problem when I try to design some report by use Crystal Report. My problem is happen on Detail Section. I will tell about information first.

My Database is contain some data like this

ProductId/Amount/Members
A00001/350/N
A00001/350/Y
A00002/500/N
A00003/125/N
A00004/300/N
A00004/300/Y
A00005/75/Y

I want to report something like this

Non-Member
A00001 350
A00002 500
A00003 125
A00004 300
TOTAL 1275

Member
A00001 350
A00004 300
A00005 75
TOTAL 725
DISCOUNT 72.5


GRAND TOTAL 1927.5

How can I do it?