summary help (1 Viewer)

S

steve_cjl

New member

Local time

Today, 10:19

Joined

Nov 17, 2009

Messages

4

• Nov 17, 2009

• #1

hello
i was wondering if anybody can help
i have a report that has a {1Sum of ARInvoiceDetails.GrossAmount} in the report footer this is totalling every gross amount including any suppressed amounts. is there anyway to get it to only total the amounts shown on the report?
thanks
Steve

 

P

PeterOC

Registered User.

Local time

Today, 17:19

Joined

Nov 22, 2007

Messages

80

• Nov 23, 2009

• #2

Is {1Sum of ARInvoiceDetails.GrossAmount} a Running Total? If not, replace it with a Running Total which will sum up the same field, but in the Evaluate section select 'Use Formula' and use the same criteria in the formula as you're using to suppress whatever records you're suppressing.
HTH,
Peter

 

S

steve_cjl

New member

Local time

Today, 10:19

Joined

Nov 17, 2009

Messages

4

• Nov 23, 2009

• #3

PeterOC said:

Is {1Sum of ARInvoiceDetails.GrossAmount} a Running Total? If not, replace it with a Running Total which will sum up the same field, but in the Evaluate section select 'Use Formula' and use the same criteria in the formula as you're using to suppress whatever records you're suppressing.
HTH,
Peter

Click to expand...

i have changed it to a running total but i cannot find the evaluate section where is this? i did try putting this in the suppress section in format field {@Rejected savings} < 0
thanks
Steve

 

P

PeterOC

Registered User.

Local time

Today, 17:19

Joined

Nov 22, 2007

Messages

80

• Nov 24, 2009

• #4

The evaluate section that I was on about is in the 'Edit Running Total Field' dialogue box where you have the options: Evaluate:
*for each record
*on change of field
*on change of group - Or -
*Use a formula

What version of crystal are you using?

 

S

steve_cjl

New member

Local time

Today, 10:19

Joined

Nov 17, 2009

Messages

4

• Nov 24, 2009

• #5

thanks i found that now but im still having trouble getting it to suppress the rejected savings if less than 0 i have put this in the formula section but it does not like it {@Rejected savings} < 0
im running version 12.2.0.290
thanks

 

P

PeterOC

Registered User.

Local time

Today, 17:19

Joined

Nov 22, 2007

Messages

80

• Nov 24, 2009

• #6

Steve,

I've sent you a pm with my email address if you want to send me the rep.

 

S

steve_cjl

New member

Local time

Today, 10:19

Joined

Nov 17, 2009

Messages

4

• Nov 24, 2009

• #7

PeterOC said:

Steve,

I've sent you a pm with my email address if you want to send me the rep.

Click to expand...

i have just emailed it to you
thank you very much!
steve