CODEWITHSUNDEEP
sql-servercrystal-reports
michael Douglas
michael Douglas

Reputation: 1

How To Sum all Records in crystal-reports-8-01

Example:

date           |   value               
------------------------------
1/19/2012      |    100              
1/20/2012      |    50              
1/21/2012      |    30              
1/25/2012      |    0              
1/26/2012      |    0

total GRAND TOTAL until now : 180

In Crystal Reports, using formula editor:

Sum ({stock.in}) ==> for total in

When I run date 1/19/2012 until 1/26/2012 the result is:

total GRAND TOTAL until now : 180 (TRUE)

But when I run date 1/20/2012 until 1/26/2012 the result is:

total GRAND TOTAL until now : 80 (the value is changed) grand total from begining until now must be 180

How do I make the value of the sum not changed from the beginning until the last date when chosen date? I need them for grand total.

Upvotes: 0

Views: 830

Answers (1)

user359040
user359040

Reputation:

If you want the total for all records, while only displaying some of them, the answer is to remove the selection condition, and instead conditionally suppress the detail section where the records fall outside the selection range.

Upvotes: 1

Related Questions