Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trying to create a quarter report
- Thread starter spachuca
- Start date
synapsevampire
Programmer
Please be a bit more descriptive.
When you say a quarter, is that to say that the report starts with the current month, and you'd like to see future months?
If so, you've some bad news forthcoming, though there are tricks to help.
If you're just trying to view several months of data, set your selection criteria to equal whatever months you'd like, as in.
if month(currentdate) = 3 then
{yourdatefield} > date(1,1,year(currentdate)
else
if...
Don't take this as the actual syntax, I'm just describing one method, and I've too many languages in this fuzzy ole noggin to do that well.
Also, companies have different quarters, so if this is intended for other audiences, keep that in mind.
As an aside, if you can build a period table (containing year, quarter, month, week, day), you'll simplify this type of thing immensely, offload the rule from your report (always a plus!+!, and all for many future things in life.
-k kai@informeddatadecisions.com
When you say a quarter, is that to say that the report starts with the current month, and you'd like to see future months?
If so, you've some bad news forthcoming, though there are tricks to help.
If you're just trying to view several months of data, set your selection criteria to equal whatever months you'd like, as in.
if month(currentdate) = 3 then
{yourdatefield} > date(1,1,year(currentdate)
else
if...
Don't take this as the actual syntax, I'm just describing one method, and I've too many languages in this fuzzy ole noggin to do that well.
Also, companies have different quarters, so if this is intended for other audiences, keep that in mind.
As an aside, if you can build a period table (containing year, quarter, month, week, day), you'll simplify this type of thing immensely, offload the rule from your report (always a plus!+!, and all for many future things in life.
-k kai@informeddatadecisions.com
Whenever you group by a date field, you are prompted for how often you want the group section to be printed. Quarter is one of the valid choices here. Look into this, it may be what you need. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
dgilsdorf@mchsi.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question