Post Author: lcrawfor
CA Forum: Formula
I need to create a report which shows the count of orders for the previous month, the current month and the percent change. An example follows.I suspect I need to use sql expressions but I can't figure it out. Anbody else know how to do this?Crystal Reports X1, SQL Server 2005Orders tableCUSTNUMB VARCHAR(15)ORDER_DATE DATETIMEREGION VARCHAR(10)ORDER_NUMB INTOrders Monthly Summary ReportRegion 2007 - 07 2007-08 Percent ChangeEast 3,478 4,568 31%North 2,364 2,578 9%South 7,634 7,189 -6%West 1,891 2,231 18%Total 13,665 16,566 21%