Need to point back to previous record

[newCrystalgirl]

Hello -

I am trying to build a Crystal report that calculates a person's quality and am having trouble relating errors back to the original editor. Here is an example of the data:

ID User Task Task Result Error
ABC 1 Edit Done
ABC 2 QC Fail N01
ABC 1 Edit Done
ABC 2 QC Pass
DEF 1 Edit Done
DEF 2 QC Pass
GHI 1 Edit Done
GHI 2 QC Fail N02
GHI 2 QC Fail N01
GHI 1 Edit Done
GHI 2 QC Pass

So, from this data I would like to do 2 things:
1. Show that user 1 edited 3 documents (ABC, DEF and GHI) and had 2 of them fail.
2. Show User 1 the actual errors made and probably some other data as well.

So, my challenge is to relate the error back to the original editor's user name. For example, for document ABC above, I show an error code of N01 on the second record. However I want the error tied to User 1 from the first record.

Is there a way to say in simple terms something like: If error is not null then give me the user from previous record containing the same ID and the task of Edit?

Hopefully this question makes sense. I'm new so be easy on me!

Thanks!

 

[IdoMillet]

Add the same table a 2nd time to the report (give it an alias of QC).

Join on ID.

In the record selection take care or restricting one side to Tasl of "Edit" and the other side to Task of "QC".

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com