I have field1 in crystal rpt as average rete , field2 totqty and field3 is
average rate * totqty in report footer i want grant total of field3
in at the end of report at report footer can anybody help
Printable View
I have field1 in crystal rpt as average rete , field2 totqty and field3 is
average rate * totqty in report footer i want grant total of field3
in at the end of report at report footer can anybody help
Insert Summary for Average Rate and TotQty fields and place them at Report Footer
Then insert a new Formula Field that calculate
and place it at Report Footer alsoCode:Sum({Table1.AverageRate}) * Sum({Table1.TotQty})
If you don't want to view the Summary fields you can Suppress them
(Change table and fields' name as needed)
JG
average rate is not field name its a average rate of group field
i am grouping the records and taking its rate fields average rate
and then making multiplication of "Rate" fields average rate into totqty
as total amount of that group record now this group grand total
i want at report footer
I figured something like that after I clicked the post button, sorry for the misunderstandig!
any crystal guru pls guid me