Grouping by Date Quarters. 1

[kovas]

I have a few reports that need to be grouped by four quarters, Jan - March, April - June, July - Sept, Oct - Dec.

The way it works now is that there is a Formula called Quarter. That looks like this.

if {term.termdate} in Date (1999,01,01) to Date (1999,03,31) then
"1999/01/01 - 1999/03/31"
else

if {term.termdate} in Date (1999,04,01) to Date (1999,06,30) then
"1999/04/01 - 1999/06/30"
else

if {term.termdate} in Date (1999,07,01) to Date (1999,09,30) then
"1999/07/01 - 1999/09/30"
else

if {term.termdate} in Date (1999,10,01) to Date (1999,12,31) then
"1999/10/01 - 1999/12/31"
else


It repeats for years 1999 - 2002. Now when 2003 came obviously this report doesnt work correctly. Of course I can go and add the year 2003 and so on but I was looking for a way to make it automatic. Basicly the question is how can I automaticly group the report by the Quarters and Years.

Hope this makes sense. Thanks!

 

[cmpgeek]

i think this will work:

right click on your group and pick CHANGE GROUP
the 3rd drop box down defaults to "for each day"... scroll down those options and pick "for each quarter"...

i believe that will automatically keep them chronologically in order...

good luck ShannonLea
Computer Coordinator 4 Surgical Services
Athens Ga

 

[Naith]

Right click your date group and select Change Group. Use the drop down menu for "This section will be printed:" to select "for each quarter".

Naith