IsNull Formula for Assignee (SQL)

[cmccoy2005]

Crystal Experts,

I am trying to learn crystal XI.

I have a one-to-many relations with the assignee field. I would like to print all assignees with the criteria:

if IsNull({Asgnment.Resolution}) or (Asignment.Resolution} = " " then {Asgnmnt.Assignee}

With this statement, I will know who has not completed their task.

There could be many assignee's to one record. I placed this statement in the report header and its only printing the first assignee that meets this criteria. I would like to display all assignee's with this criteria within the Group Header. Any suggestions would be appreciated.

 

[IanWaterman]

A Group header will only show the first record set, as you have discovered. If you want all such asignees at top of report.

Create formula

@Not Completed
if IsNull({Asgnment.Resolution}) or (Asignment.Resolution} = " " then 'Not Complete' else 'Complete'

Group on this formula and set as Descending.

All such assignnes will now be at the top of the report.

Ian

 

[cmccoy2005]

Ian,

When I created - it displayed in Group Header 4

Not Complete
Complete
Not Complete
Complete

I need to see the assignee who is only 'not complete' I need to see their names (Asgnmnt.assignee).-