how can i edit the customer list report to show Primary Sales Rep or create this report thanks hozay
- posted
15 years ago
how can i edit the customer list report to show Primary Sales Rep or create this report thanks hozay
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
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.