Oh I should note that I do have a copy of crystal reports XI and I'm sure I could muddle through to find the correct fields my real problem is coming up with the formulas for the filters so it only shows first part run.
--- In vantage@yahoogroups.com, "tom.bethke" <tom.bethke@...> wrote:
>
> My company is trying to create a report to find the first time every part we have manufactured was run. so if our business had manufactured 1000 different parts we would have to look at the job history on each and every part to find the fist time it was run. we need a report to search every part number ever run through our entire history or a certain timeline to find the first time a job was run for each part. They would like to have the part#, job#, order date, customer name and number and the part description
>
> Please let me know if there are any canned reports/baqs that may do this or could easily be modified for this purpose.
>
> We are not opposed to contracting a cr consultant to create the job it should be pretty easy but we need to get this done asap.
>
> Thanks,
> Tom
>