| :: Error/Problem with master/slave reports :: (2) | Post a New Message | Post a Reply |
 Error/Problem with master/slave reports | Post a Reply |
since: May 25, 2005
from: somewhere
Table 1 Shopping Transactions:
customer ID
Transaction Date
ProductID
Product Price
Table 2 CSR Transactions:
CustomerID
TransactionDate
Operator
Transaction
I have the following relationship set:
[ShopCartTransaction].[CustomerID]=[OperationsTransaction].[CustomerID]
with ShopCartTransaction being the master.
So, in this scenario,if there are three records in the ShopCartTransaction table with customerID XYZ, for each record, the same number of records from the operationsTransaction table (with customerID XYZ should be shown).
However, when I run the report, I don't get the same number of operationsTransactions records per ShopCartTransaction Record.
I tried the instructions on this posting http://www.aspwebsolution.com/forums/?tid=1374 by sorting by the Customer ID column and still don't get the right report.
Any/all advice & help is appreciated.
 Re: Error/Problem with master/slave reports | Post a Reply |
from: Washington, DC
- Also make sure that you check the Set as default sort order checkbox found on the Re-Order your table fields screen.
- If the problem continues send me a link (to your reports) I can check or sample data I can test
-------------------------
Ghost