Question on Running Totals
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17846
Printed Date: 01 Apr 2025 at 8:18pm
Topic: Question on Running Totals
Posted By: achandana01
Subject: Question on Running Totals
Date Posted: 25 Oct 2012 at 12:33pm
I have following Data
Age Pat_ID Balance Owner
326.00 1001 399.00 5,502
326.00 1001 399.00 5,502
326.00 1001 399.00 5,502
239.00 2002 1,110.005,502
239.00 2022 1,110.005,502
239.00 2002 1,110.005,502
500 3003 2000 5505
I need a Total of 1509 for owner 5502 and age > 4,2000 for ownder 5005 and age > 6.I am using running totals for this
Fields to Summarize --> Balance
Tyoe of Summary -- > Sum
Evaluate --> Use formula owner = 5502 and age > 4
Reset --> Never
However I am not getting the desired Result.Age criteria needs to be there cuz There are some records which has age < 4.Please help.
Thanks,
-------------
chand
|
Replies:
Posted By: comatt1
Date Posted: 26 Oct 2012 at 2:48am
|
group by owner, and reset on that group
|
Posted By: achandana01
Date Posted: 26 Oct 2012 at 9:01am
Thank you but what about Age field how do I age as a criteria in RT?
-------------
chand
|
Posted By: comatt1
Date Posted: 26 Oct 2012 at 10:00am
you could do this, make a formula to flag age > 4
if age > 4 then
'1'
else
'0'
----
second formula
just have
totext(owner)+totext(@ageformulaabove)
-----
evaluate for the formula to look like this -> @ownerageformula = '55021'
|
Posted By: DBlank
Date Posted: 29 Oct 2012 at 4:09am
|
Your RT design looks fine...where did you place the Running Total on the report? RT's must be on or below that last row of data that is included in the evaluation (they dont work in headers).
|
|