cancel
Showing results for 
Search instead for 
Did you mean: 

Previous Month, Current Month, Percent Change

Former Member
0 Kudos

Post Author: lcrawfor

CA Forum: Formula

I need to produce a report which shows, by region, the count of orders for the previous month, the current month and the percent change where current month is an input parameter.I am running Crystal reports XI against an MS SQL database.Does anyone have an example they wouldn't mind sharing?Thanks,Larry Crawford

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Post Author: lcrawfor

CA Forum: Formula

Thanks for the quick response. I've looked at some of the samples. I'll take another look. Here is a simplified example: Orders 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%

Former Member
0 Kudos

Post Author: V361

CA Forum: Formula

Hey Larry, there are some example reports in XI that may help you. Go to the start page, (or if you do not have that turned on) Program files\business objects\en\reports\financial\current period and ytd cash flow.rpt For the count of orders you and use running totals, have the evaluation section be a formula ie.... {@Month} = "January" or {@month} = 01 (depends on your data) Any way, if you could post some samples, we can provide a better answer.