Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Find absence of record Post Reply Post New Topic
Author Message
KH2000
Newbie
Newbie


Joined: 03 Aug 2010
Online Status: Offline
Posts: 2
Quote KH2000 Replybullet Topic: Find absence of record
     Posted: 04 Aug 2010 at 8:01am

I have a request to look throught the tables and find any employee that does not have a particular license code in there file.

 
The table contains a record for each employee and a license tpye. example
 
EMPID
Liccode
Start Date
End Date
Notify (0/1)
Required (0/1)
 
There are mulitiply records for each employee one for each lic code.
 
How do I create a report that will show me thoses employees that are missing a certain license code.
 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 04 Aug 2010 at 8:39am
group on empid
create a formula field to flag employees thaty do have the license named flag as...
if table.liccode=specificcode then 1 else 0
use the insert summary function on tis formula as a SUM at the emplid group level
in the select expert change the select toggle to 'Group Selection'
insert the  formula of
SUM({@flag, table.empid)=0
IP IP Logged
KH2000
Newbie
Newbie


Joined: 03 Aug 2010
Online Status: Offline
Posts: 2
Quote KH2000 Replybullet Posted: 05 Aug 2010 at 9:28am
Thanks!!  worked great
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.