I'm a very occasional Crystal user (8.5).  I need to produce a report which will list part numbers down the page and the machine names used in the manufacture of the part horizontally beside each part.

 

I started by reporting out the part number, the operation number, the machine code and the machine description which obviously gave me an entry of the part number for each operation number and machine code, like this:

 

partno1     10     7    stores

partno1     20     19  laser

partno1     30     6    deburr

partno1     40     12  press

partno1     50      996 subon

partno1      60     13  inspection

 

etc. etc. etc.

 

what I'd like to be able to report is:

 

partno1  stores   laser   deburr   press  subcon   inspection etc

 

I thought I might be able to use a crosstab report but I think it wants to report each machine in the database as a column header, list every part number and then try to produce a sum of the machine descriptions.

 

Can anybody suggest a solution?

 

Thanks