For me, I'm running an Attendance report.  I need to pull all entries that match a list of attendance codes and group them.  But I would also like to have a blank entry for anyone that has no codes.  Using the IsNull pulled them all up as entries in the group tree under their various categories, but I don't actually see anything in the report itself. 

 

 I don't have access to the dbase that I'm querying outside of Crystal, so I can't do anything interesting there before I make the report, so I'm stuck with filters.

 

My select statement looks thusly:

 

local datevar StartDate:=date(dateadd("d",-180,{?End Date}));

 

date({DET_SEG.NOM_DATE})  in StartDate to {?End Date} and
({SEG_CODE.CODE} in [....]  or IsNull({SEG_CODE.CODE})) and
if left({EMP_GRP_NODE.CODE},2) = "CS" and right(left({EMP_GRP_NODE.CODE},5),1) in [....] and {?Department} in ["CS", "All"] then true else
if left({EMP_GRP_NODE.CODE},2) = "PD" and right(left({EMP_GRP_NODE.CODE},8),1) in [....] and {?Department} in ["PD", "All"] then true
else false

 

There are a lot of extra pieces that might be getting in the way (selecting dates, selecting certain codes, selecting the teams, selecting the departments - replaced the data itself with .... in places), but I think they're all external to this issue....