crystal-reportscrystal-reports-2008crystal-reports-2010crystal-reports-xi

Crystal Report Running Totals


I need to customize running total in crystal report

Sample Report

Following I show my evaluation formula of Running total

If {spPet_DailySummery;1.HPetVouNo} = {spPet_DailySummery;1.HPetVouNo} Then
    True

Following I show my reset formula of Running Total

If Previous({spPet_DailySummery;1.HPetVouNo}) <> {spPet_DailySummery;1.HPetVouNo} then
    True
Else
    False

Someone, please let me know how can I got report as above.


Solution

  • Follow the steps below which worked for me

    1. Group you report by V/No it will create Footer

      enter code here

    2. Insert summery

      enter code here

    3. Add Running Total

      enter code here

    4. Right Click on running total go to formate object

      enter code here

    5. now suppress your footer group sum field

      enter code here

    6. This has been tested and confirmed on my local machine.