Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Selection formula Post Reply Post New Topic
Author Message
gizmosilly
Newbie
Newbie
Avatar

Joined: 04 Aug 2009
Location: United States
Online Status: Offline
Posts: 26
Quote gizmosilly Replybullet Topic: Selection formula
     Posted: 07 Oct 2009 at 1:45pm
I am trying to write a formula to pull all the open invoices for a vendor if they have a credit amount in the Open Amount field. (basically exclude a vendor if they do not have an open credit on their account) So far all I have gotten my formula to do is pull only the credits for that vendor. here is my formula so far
if {Accounts_Payable_Ledger.AmountOpen}<0 then {Accounts_Payable_Ledger.AddressNumber}
then I have this linked in the record selection to address #
Can some one please help me with this
IP IP Logged
Jyothi Yepuri
Senior Member
Senior Member


Joined: 11 May 2009
Location: Australia
Online Status: Offline
Posts: 127
Quote Jyothi Yepuri Replybullet Posted: 07 Oct 2009 at 3:35pm
try this in record selection
{Accounts_Payable_Ledger.AmountOpen} > 0


Jyothi
IP IP Logged
gizmosilly
Newbie
Newbie
Avatar

Joined: 04 Aug 2009
Location: United States
Online Status: Offline
Posts: 26
Quote gizmosilly Replybullet Posted: 08 Oct 2009 at 7:46am

Thanks for replying,

I tried your formula but that only pulls the credits in the open column, I need it to pull all of the open amounts if the account has a credit in the open amount.
Please let me know if you can help me with this.
Ali
IP IP Logged
Jyothi Yepuri
Senior Member
Senior Member


Joined: 11 May 2009
Location: Australia
Online Status: Offline
Posts: 127
Quote Jyothi Yepuri Replybullet Posted: 08 Oct 2009 at 3:05pm
your explanation is little bit confusing..can you post sample data...

Jyothi
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum