Skip to Content
0
Former Member
Dec 27, 2007 at 11:18 PM

Previous Month, Current Month, Percent Change

45 Views

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%