Monthly Count

[tdavis72]

I am new to Crystal and 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.

 

[synapsevampire]

The solution is based on the fields available in the database, so posting technical information is required, in general succcessful posters include:

Crystal verison
Database/connectivity used
Example data
Expected output

The generic answer is that you would use Insert->Group and use the date field as the group and select for each month, then place a formula in the details of:

if isnull({table.terminateddate}) then
1
else
0

Then right click that formula and select insert-summary->sum and select for the date/month grouping.

Of course this is all conjecture because I don't know how you determine who is active or not, and I don't know what you expect the output to be. In future posts consider that we need to know technical information, afterwards you can supply decriptions if you feel it helps.

-k

 

[tdavis72]

Thanks Synapsevampire, I actually figured out how to do it. What I had was correct it was a Lawson issue as far as storing history information.