Open tickets with closed assignments only

[gennaroalpha7]

Hi -

This is a continuation of thread thread767-1733072 - I would like some help from more experienced Crystal Developers please.

I have 4 fields on my report. They are CallLog.CallID, CallLog.RecvdDate, CallLog.CallStatus, and Asgnmnt.AssignStatus

I would like the report to pull Open Tickets that only have "Closed Assignments", but its pulling tickets with Active Assignments too.

I have grouped on CallLog.CallStatus and Asgnmnt.AssignStatus and added this code, {Asgnmnt.AssignStatus} <> "Active", to Report > Selection Formulas > Group and added this code, Date ({CallLog.RecvdDate}) in Lastfullmonth and {CallLog.CallStatus} = "Open", to the Report > Selection Formulas > Record.

Is there something I have to do to make this work or something I am missing?

Thx in advance for your help.

G.

 

[briangriffin]

You're suppressing some detail records, which made sense before you grouped on Call ID.

Remove this from the section expert, details section:

{CallLog.CallID}= previous({CallLog.CallID})

Then everything will be visually consistent, and it should be apparent which groups should be suppressed.

 

[gennaroalpha7]

Thank you. I will keep trying and get back with you. Thanks for hanging with me...

Have a good 4th.

G.