i am trying to design the report for 3 main tables. Voucher - item - material .

 

the report will have three level of groups. 1.Voucher - 2. item - 3. material

 

Voucher no: ReferenceNo:			VoucherDate: Client Name:
Itemno		Name	Qty	Wt
AB001		Ant lab	100	125.102
MtrCode MtrName Qty Wt Rate M001 MtrName1 10 10.10 100 M002 MtrName2 20 20.10 200 Total   30 30.20 300
AB002		Black lab	150	125.000
MtrCode MtrName Qty Wt Rate M002 MtrName2 30 20.10 200 M004 MtrName2 20 20.30 200 Total   50 40.40 400
Item Total:			250	250.102

 

i am not getting the sum of item (250) here, properly. it gets duplicated the no of times the material records are there.

 

please give me solution to it.

I am tryig to avoid sub report. let me if i can do it better way then using sub report.

 

 

  Some times getting problem when sum the group fields. noproblem we are solve it easyly.

 First think you use the Qty field is formula or column_filed?

 

  Want to know that direct column means u use summarise group

or use the following formula

 

 item grp header formula

------------

shared numbervar shtotal;

local numbervar liTotal;

shTotal:=(shTotal+{Command.Qty_value});

liTotal:=shTotal;

shTotal=0;

 

 

drag the formula and paste it header and suppress. this formula get simmarise the every one of the group.

 

then use another formula for footer for summarise

 

shared numbervar shtotal;

shtotal;

 

You get the sum total clearly.

 

Regards

 

 

 

 

If you have not resolved the problem I would suggest creating a RunningTotal put it in the group 1 footer, evaluate it on the change of field qty_value and reset on each change of group 1.

 

If that does not work you can always create manual formulas such as you were working on. You can find this described in detail under Crystal Reports Help -> Running Totals -> Using Formulas. You will see you need to put in pieces of the formula in three places. The header, the detail section and the footer.

 

Hope one of these options help

 

Regards,

 

John W.