Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: crystal xi how to exclude group Post Reply Post New Topic
Author Message
felice
Newbie
Newbie
Avatar

Joined: 13 Oct 2009
Location: United States
Online Status: Offline
Posts: 2
Quote felice Replybullet Topic: crystal xi how to exclude group
     Posted: 13 Oct 2009 at 3:15pm
i have data for client billing. if a denial is recieved a payment amount of 0 is entered and a code(ZZ12) is place in type field. I created a report in crystal that shows me  all transactions for any client who has had at least one zz12 in the type field and a payment has also posted for the same visit. however i only want to see the group if the zz12 code was posted before the payment. As of now i see it if a payment was recieved before or after the code was entered:
 
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 14 Oct 2009 at 6:48am
section expert for the group/suppression button
{table.zz12date}>{table.paymentDate}
 
HTH
IP IP Logged
felice
Newbie
Newbie
Avatar

Joined: 13 Oct 2009
Location: United States
Online Status: Offline
Posts: 2
Quote felice Replybullet Posted: 14 Oct 2009 at 7:57am
that worked...thank you so much.
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