Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Monthly buckets Post Reply Post New Topic
Author Message
Hank
Newbie
Newbie


Joined: 21 Dec 2007
Location: United States
Online Status: Offline
Posts: 1
Quote Hank Replybullet Topic: Monthly buckets
     Posted: 21 Dec 2007 at 4:59am

We are using Crystal 9.2

Trying to create a report that has monthly buckets.
First bucket would be Current Month Orders
Then Next Month Orders
Current Month +2 etc
Current Month +3
 
Any assistance would be appreciated on what the formula should be
 
thanks
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 21 Dec 2007 at 5:22am
I find the term "bucket" interesting....

I'm pretty sure that what you want is to simply group the report on the date.  When you do a group by date, Crystal allows you to group by common "buckets," such as week, month, or quarter.  Open Group Expert.  Add a group based on a date.  Click on the Options button.  At the bottom of the dialog box, you will see the option to group by one of a variety of date ranges.

If you need to group by a slightly more unconventional range, such as every 30 days before and/or after today's date, look at the date range constants in the help file (or, better yet, in Brian's book).  A lot of these are predefined in Crystal, so that you can write the formulas using them very easily.


IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum