Fiscal Year with crystal reports

[jodilyn]

hi
I desperatly need help with crystal reports.
i am trying to create a report that counts the number of full-fiscal years that a FULL-TIME employee has worked.
Variables:
status: can be either fulltime, parttime or temporary
begindate: date that the job began
enddate: date that the job ended

fiscal year runs from July 1 to june 30

if an employee works just 1 day during the fiscal year as parttime that fiscal year does not count.

If an employee begins a job position on july 2 that fiscal year doesn't count because it was missed by 1 day.

i am using 1 table and each time an employee changes job positions a new record is created and added to that table
Any help would be appreciated!!!!!!
jodilyn =)

[ExcalibursZone]

non-gregorian fiscal years really tick me off too. I just finished a set of reports that work on a fiscal year from May 1 to April 30 ... The only way I could get this to work was to set up 4 seperate sub reports, one for each quarter. I passed the date to each one. The reason I did this is due to the fact that 1: the client wanted it to look like excel, and 2: the client wanted a listing of all their folks.

In each quarter, just set up a group based on the username, and set the supress formulas for all the groups members (header, details, footer) to true if there is anything but a full-time criteria.

If {Table.FullTime} <> 'Full Time' Then True Else False;

I guess in your case, you'd be setting up a running total or summary operation, counting the hours worked full time or whatnot in the details ... that would be a hidden field, you'd need that formula in the group footer of your subreport which would hide information that doesn't match.

Hope this helps or gives you an idea of what you need to do.