Skip to Content
0

if else statement in crystal reports 2016

Nov 02, 2017 at 04:26 PM

29

avatar image

Hello All

I have a column as "Source" in that data is

REC,PAY,PAY,REC,REC,REC,PAY like this

now i wanted to divide the data for payments and receipts.i have to write 2 formulas

if source is "rec" then it should display sum of Receipts in report footer based on amount field.

if source is "pay" then it should display sum of Payments in report footer based on same amount field.

can anybody tell me how to write the formula please.

Thanks

Paturi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Nov 03, 2017 at 11:11 AM
0

Create two formula

@REceipts
If Source = 'Rec' then ReceiptField else 0

Repeat for Payments, you can then sum these formula in either Group or Report Footers
Ian

Share
10 |10000 characters needed characters left characters exceeded