I have a sales order report that needs a "flag" indicating if the customer had no other sales orders within the last 6 months. If they have none (or none ever), I need to do custom reporting on their SalesOrderLine.Rate amounts. I've been searching for something in the DevExpress.XtraReports.UI Namespace that may do this. Perhaps I could create a VB.Net SQLCommand query on the SalesOrder table in the Customer Header _BeforePrint event based on the current row's customer recordID.
Does anyone have an example of how I can do this easily? Thanks.