Before Sum After Sum

[jajiyiko]

Hi! Friends

My Crystal Report version is 4.6

I have a problem
I have a like this a report

Name size date
===== ==== ========
a 20 2005,09,20
b 18 2005,09,18
c 12 2004,09,12

I want to sum size before today, like this

today=2005,09,20

before sum = (18+12) = 30
today sum = 20
total = 50

I will be happy if you help me

 

[IdoMillet]

Create a formula called Before_Val:
IF {Your_Date_Field} < CurrentDate THEN {Size} ELSE 0

Sum that formula to get the sum of sizes before today.

Follow the same logic to create the other sum.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com