on 12-11-2007 4:45 AM
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
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%
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.