Search code examples
crystal-reports

crystal report showing sub total after each date

i am not able take sub total depend upon date..i want to show my report like this:i mean i want to show subtotal after each date my report is coming like this:

LocName   Date          un1     un2      carcount
-------------------------------
Address  2013-01-10      compl  compl      10
                         compl  compl       12
                                          --------
                                     SubTotal  20
         2013-01-15      comple   comple      5        
                         comple   compl       10
                                           -------   
                                           SubTotal  15

                                      Grand Total 35
             i am not able to give sub total after each date
Solution

  • What you are after is a running total rather than a standard summary field.

    Go to the field explorer and right click on Running Totals:

    Step 1

    In the next screen add carcount to the fields to summarise, set the summary type to sum and set Evaluate to 'For each record'

    Now you can add the new running total to the report and it should calculate correctly

    Edit:

    To display field types right click on 'Database Fields' in the field explorer:

    Types