Has anyone had success bringing in the SaleRep Table in this report? The SalesRep table does exist in the RDD, but this does not have any data in it to work with.
When the SalesRep table was added how was the relationship setup?
Because the field hold multiple values, I normally only join by Company and thenuse SSRS to split the value(s).
In the RDD for JobTrav I can see a datasource for Salesrep. Not sure how this is tied to the OrderHed Sales Replist though. I tried to create a new relationship for the SalesRep table linking on Company thinking that at least I could pull all the Records in to my SSRS and then create another DataSet with this query and use a lookup function:
=“SELECT T1.SalesRepCode, T1.Name FROM SalesRep_” + Parameters!TableGuid.Value + " T1"
This returns no Data?
Also, I am wondering why the field SalesRepList in the RDD > Linked tables > Description Fields is not available for the ordered Datasource. It is available on the OrderDtl though.
Linking the Tables Company>SalesRep using the Key:PK_Company does work. I am able to bring in all the SalesReps from the RDD and create another Database. The only question is why is the SalesRepList only on the OrderDtl?