Treat the first record only.

[MarsianStar]

Crystal 11, Heat, SQL server,
tables calllog assignmts

For each call there is either one assignment and it is resolved by first level.
Or it was reassigned to second level.

I would like to list the re-assigned calls only along with rest of the assignments.


sample data

CallID Date Resolution ResolutionNotes

11234 Nov-1 Reassigned Need Admin Rights
11234 Nov-1 Resolved Provided Admin Rights

11235 Nov-2 Reassigned Hardware Failure
11235 Nov-2 Reassigned Building Maintenance issue
11235 Nov-3 Resolved Socket replaced

11236 Nov-2 Resolved Reset Printer, tested OK.

I do not want to see call 11236 but would like to see the other two.

Thanks in advance for your help.

 

[lbass]

Insert a group on {table.callID} and then create a formula {@reassigned}:

if {table.resolution} = "Reassigned" then 1

Then go to report->selecton formula->GROUP and enter:

sum({@reassigned},{table.callID}) > 0

If you need to use any calculations across calls, you will need to use running totals, since non-group selected records will contribute to the more usual inserted summaries.

-LB

 

[MarsianStar]

I will try that and let you know, thanks a lot for you help.