Crystal reports formula
I have a need to display a running total total on the detail lines that make up the running total. is there a way to do this
10 lines and each has 1 box. running total is 10 boxes I need each line to say a total of 10 boxes on each line
Software/Hardware used:
crystal 10
10 lines and each has 1 box. running total is 10 boxes I need each line to say a total of 10 boxes on each line
Software/Hardware used:
crystal 10
ASKED:
November 18, 2009 3:42 PM
UPDATED:
November 19, 2009 3:19 PM
Answer Wiki:
In Field Explorer, select Running Total Field and click the New button to display the Create Running Total Field box
Type in a name
From the available Tables and Field list box, select the field to summarise
From the Type of Summary drop down list, select the type of summary you want
In the Evaluation section, specify the criteria
Click OK
Insert the field into the report
Hope this helps
To see all answers submitted to the Answer Wiki: View Answer History.
That does not work.. it just increments as it gets to the total. I need the full total to repeat itself on the detail lines. Exampe
a) 1 3
b) 1 3
c) 1 3
Total = 3 for shipments A,b,C I need 3 to show on every detail line
Assuming that the number is the sum of the column
I created a grand total for the column
I then created a formula field that was equal to the grand total – Sum ({OEP70.LQTY70})
I then put this field in the detail line for the report, so the grand total repeats on each line