Customer last visit report

[gerlandog]

there you go… search “customer report” and you will find a lot of info…

to get started

Ticket List by Customer report

This report lists tickets that have a selected customer and displays custom field values. ###@@XTicketListByCustomer select     T.TicketNumber,     min(convert(nvarchar,T.Date,105)) as Date,     min(convert(nvarchar,T.Date,108)) as Time,     COALESCE(min(TE.EntityName),'-') as [Entity Name],     COALESCE(min(cast(TE.EntityCustomData as nvarchar(4000))),'-') as [Custom1],     COALESCE(min(cast(TE.EntityCustomData as nvarchar(4000))),'-') as [Custom2],   min(T.TotalAmount) as TotalAmount from …

Customer Purchase History Reporting

This is a Report to show Historical Purchases on a per-Customer basis. You can select a Date Range to Report on and use Entity Search to load any Customer Purchase History. [image] This Tutorial uses to SQL scripts to pull data from the [Orders] table and the [Tickets] table. The data in the [Orders] table does not include Additional costs or Discount values that might be applied via Order Tag Prices, so the Item Total Prices could be incorrect (too high or too low). Note in th…

hope this helps

G