Fiscal Year Calendar

[tdavis72]

Help!!!!!!!!!!!!!!!!!I need to create a report that will count records based upon the fiscal year (i.e October 2005 -up to the last full month up to September 2006) How do I code the date for this in Crystal?

Thanks

 

[synapsevampire]

Count records...

Well, you can limit the rows returned by selecting Report->Select Formula->Record and placing something like:

(
if month(currentdate) > 9 then
(
{table.date} >= cdate(year(currentdate),10,1)
and
{table.date} <= cdate(year(currentdate)+1,9,30)
)
else
(
{table.date} >= (year(currentdate)-1,10,1)
and
{table.date} <= cdate(year(currentdate),9,30)
)

If you're returning data for a greater period than the current fiscal year, then you can use the same logic as the criteria to perform aggregates for the currrent fiscal year.

-k

 

[tdavis72]

THANK YOU!!!!!!!!!!!!!! You are wonderful.

 

[tdavis72]

I have to create a report that captures the number of active employees each month and then sum that total to get the average number of employees based on the report date. How can I set my Begin date variable and ending date variable to do this. (i.e if report month is April, then I need active employees for the month of April, March, February and January). Any advice is greately appreciated.