Hi ,
I am facing a data model problem.
I have two Tables Product Master and Product SalesData.
Product Master contains ProductID, Sales Rep Name and Date. Here the date indicates date on which the product has been created.
ProductSalesData contains ProductId,Date and SalesAmt. Here the date indicates transaction date.
I need to created two reports. New Product Report and Product Sales Report.
I am linking the ProductMaster and ProductSalesData with ProductID and Year,Month and Day of the dates in both the table.
But I am not getting SalesRepName correctly due to this linking. Please look into the attachment and let me know if you can help me out.
Deepak
