Report question: Need account of all Sales Orders Due within 6 months of current sales order

robert.cowart — Thu, 21 Aug 2014 20:56:26 GMT

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.

Method:Classic General Q&A

Report question: Need account of all Sales Orders Due within 6 months of current sales order