Hello,

This request has nothing to do with VFP but can not find a category exclusive to Crystal Reports.

I am not very familiar with Crystal Reports but I understand (have been told) that it is great and can execute SQL statements instead of using the Data Expert links etc.

Using Crystal Reports only I would like to extract the following information in order to generate :

- A current price report of all items that have ever been bought by a client. Current price of an item bough by the client is in a seperate price list file.

For example :

If Item No, 12345 has been bough in the past by Customer ABC for Item Price at that time of $10.50 but the current price of that item for that customer ( according to the active current price list used for that customer) is $11.25, on the report result I would like:

Customer ABC
Item 12345 Current Price $11.25

Many customer share the same price list code and price list file for the same item.

------
Here are the file structures:

Table: UxDetail (Order Item History file)
Fields: cCustID, cItemCode, nPrice ($10,50)

Table: ArCus (Customer file)
Fields: cCustID, cPricListCode

Table: ICPrice
Fields, cItemCode, cPriceListCode, nCurrentPrice ($11.25)
----------

- At first I would have to extract all Items that the Customer has bought in the past, then ...

- For each unique Item and Customer found I would have to look up the Customer and get the code of the current price list code (cPriceListCode) that the customer is currently set to, then...

- I would have to look up in the ICPrice file the ItemNo and the cPriceListCode in order to get the nCurrentPrice for that item for that customer.

--------

How would I be able to do this in Crystal Reports? ( I am assuming the Data Expert can not link the files in such away that I may get the results I need and that I have to use the SQL feature in Crystal Reports? )

Thanks in advance for your help,

John