crystal report (chart)

[henli]

I have this data:

Name Status
-----------------------
Jhon 1 = 1 for Immediate Upload
Katerine 0 = 0 for Not In Terminal
Susan 2 = In Terminal
Rika 3 = Remove from terminal
Eddie 2

I want to display sum of each status in crystal report with this format:

Not In Terminal = 1
Immediate Upload = 1
In Terminal = 2
Remove from terminal = 1

I am using standart crystal report that came with visual.NET package.

Could anybody help me how to do this? and I need to put that into chart? I have tried with formula in report fields but not success.

Thanks you.

[Lunatic3]

If you still need help, be more clear and I will be able to help you. I dont know what you exactly mean, though i can guess.

[henli]

I already solved it by do the calculation/data manipulation with coding first and the result I dump into one table. the crystal report will easy grab the data from this table and displayed it.

Any way, Thanks