Don't use the data expert. You can send the SQL statement directly to your database.

Also, don't use any version of CR after XI, R2.

There are a couple of white papers on my web site that may help you get started.

www.craigberntson.com

>Hello,
>
>This request has to do with Crystal Reports. I figure many VFP programmers with Crystal Report/ Report Manager experience might be able to help me.
>
>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