Hi

I am using crystal X1.

I have to create a report to total up the number of book sales we are making on a certain project.

My issue is;

-we have 50 different books we sell

-For each order the customer could order up to 3 different books

-In the data the book they have ordered will write to one of 3 fields

so my data headers looks like:

customerinfo | order1 | order2 | order3 |

So my actual data would look like:

Mr Jones | Book1 | Book2|Null|
Mr Smith | Book 7 | Book 4|Null|
Mr Toms | Book3 | Book 8 | Book 2|

etc etc etc

I need to create a report that tells me how many of each book have been sold.

So my report would look like:

Book 1 = 5 sales

Book 2 = 3 sales

Book 3 = 7 sales

and so on and so fourth for up to 50 publications.

I though one solution would be to join the 3 order fields and make an array in Crystal, but in truth I dont know how to do that or then how to create my required output.

Any help on a solution would be most appreciated.

Thanks

Thanks so much Lockwelle, that has worked perfectly :) Many Thanks