Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to summarize a summary field

Status
Not open for further replies.
Yumster

Yumster

Programmer
Apr 3, 2002
12
US
Since Crystal doesn't allow me to summarize a summary field how would I get a report summary.

I have a detail line for a CASE with a newvalue field and an originalvalue field. I have 2 formulas that for each value.
@NEW:
if newvalue then
1
else
0

@ORIG:
if originalvalue then
1
else
0

I then have summarized these by the CASE since there can be several detail lines for each case. I have another formula:
SUM_VAL:
if sum(@NEW,case) >= sum(@ORIG,case) then
sum(@NEW,case)
else
sum(@ORIG,case)

I now want to summarize the @SUM_VAL at report level but of course Crystal does not allow this. Does anyone have a suggestion for a alternate. I could write a stored procedure but I'd like to see if I can do it through Crystal first.

Thanks for any help
 
Sort by date Sort by votes
Right click on your formual field in the details section and select "insert gradn total". Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com
 
Upvote 0 Downvote
The formula (@SUM_VAL) I want to summarize at report level is not in the detail, it is in the CASE group. Summarizing the @NEW or the @ORIG gives the incorrect number.
 
Upvote 0 Downvote
Create three formulas:

1) Reset
whileprintingrecords;
numbervar total := 0

place this in the report header. You can supress printing using the format dialog box.

2) Accum
whileprintingrecords;
numbervar total := total + @sum_val

Place this in the group footer for CASE.

3) display
whileprintingrecords;
numbervar total ;
total

place this in the report footer.

You could have also created a running total that had the same logic. Make sure you accumulate once per group.

Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com
800-783-2269
 
Upvote 0 Downvote
Thanks a lot Howard. This worked great.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
285
hilfy
hilfy
socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
357
socalvelo
socalvelo
tlbrown88
  • Question
How does one get the results of a Calculation (SharedVar) on the same line as the Sub Report?
Replies
4
Views
252
tlbrown88
tlbrown88
Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
373
Cpreston
Cpreston
SarahSCPDAdmin
  • Locked
  • Question
Can I format data in a memo field? 1
Replies
5
Views
448
SarahSCPDAdmin
SarahSCPDAdmin

Part and Inventory Search

Sponsor

Back
Top