Crystal report Problem in C#

See more:

C#2.0

C#

Windows

hello,

i created crystal report in vs 2005 C#.

report is for daily allotment report.

DailyAllotement is table name contains (date,zoneId,CustomerId,MilkType,MilkSubtype,Qty......)


O/p i want is as follow

Customer's Name | Milk Type | Milk Sub Type | QTY

AAA Cow Chitale 2
BBB Cow Chitale 3
CCC buff Thorat 4
DDD buff chitale 3


Total Qty // at report footer,(summary)
Cow chitale 5
Buff thorat 4
Buff chitale 3

for both the o/p if i used query wizard (inbuilt) then only one o/p can i get ,on selecting record if i want to keep counter on each subtype & type of milk then how i used formula?


what should i use crystal report inbuilt formula, or through data source.
please reply
it quit urgent ..................