Crystal Report 9.0 - How Do I Calculate Weekly, Monthly, Yearly Report

[shivalisv]

My Report Needs Weekly,monthly and yearly Report on the Totals(Filed in Database) Sales for each Agent (Filed in Database) in their respective region(Filed in Database). I donno how to do it? PLZ let me know as early as possible.

Thanks
Shivali.

 

[MJRBIM]

Please post a sample of your data with headers, and an example of how you would like them to be formatted for the report display.

 

[lbass]

You might want to try this as a crosstab with region and then salesperson as the columns and inserting the date field three times, each time highlighting it, choosing group options, and then choosing "yearly" for the first one, "monthly" for the second, and "weekly' for the third. Then choose sales for the summary field.

Or, you could do a regular layout, maybe grouping by region, salesperson, date(yearly),date(monthly), date(weekly) and then inserting sums on the sales field for all groups and the report footer.

-LB