Information générale
Catégorie:
Gestionnaire de rapports & Rapports
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement