Primary Sales Rep

how can i edit the customer list report to show Primary Sales Rep or create this report thanks hozay

Reply to
hozay
Loading thread data ...

Hi Hozay - first edit the tables queried section so it reads... TablesQueried = "FROM Customer WITH(NOLOCK) LEFT JOIN SalesRep on Customer.SalesRepID = SalesRep.ID"

Then add your rep with the following column Begin Column FieldName = "SalesRep.Name" DrillDownFieldName = "" DrillDownReportName = "" Title = "Sales Rep" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1560 GroupMethod = groupmethodNone ColFormat = "" End Column

H> how can i edit the customer list report to show Primary Sales Rep

Reply to
convoluted

Reply to
hozay

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.