Help with Running a Quarterly CR8 Report

[gennaroalpha7]

Not sure, what is the best method of running a report on the 1st after every business quarter?

So the report would run Apr 1st, July 1st, Oct 1st, of this year and next. The report will also run data from the previous (Jan 1st - Mar 31st) quarter only, not an accumulation of data from the previous quarters.

Thanks, please be specific.

Alpha7

 

[BobSuruncle]

You could try this in your Record Selection formula:

If Month(CurrentDate) in 1 to 3 then
{Orders.Order Date} in Date(Year(CurrentDate)-1,10,1) to Date(Year(CurrentDate)-1,12,31)
else If Month(CurrentDate) in 4 to 6 then
{Orders.Order Date} in Date(Year(CurrentDate),1,1) to Date(Year(CurrentDate),3,31)
else If Month(CurrentDate) in 7 to 9 then
{Orders.Order Date} in Date(Year(CurrentDate),4,1) to Date(Year(CurrentDate),6,30)
else If Month(CurrentDate) in 10 to 12 then
{Orders.Order Date} in Date(Year(CurrentDate),7,1) to Date(Year(CurrentDate),9,30)

I think that this works in CR version 8, but it's been awhile.

Bob Suruncle

 

[gennaroalpha7]

Hi Bob -

Thanks for your help...it will give it a shot!

G.