Crosstabs

[EmmaL]

Hi

I have a report which is a crosstab and looks at employee's start dates for different locations (locations in the rows and dates in the columns). The columns are then grouped by month.
The users have now said that what they want to see is not who started in which month, but who was working in each month, therefore that person would be counted in every month that they had worked.
Is it possible to do this using the crosstab or will I have to use running totals instead?

Thanks

Emma

 

[kenhamady]

You could use running totals. However, I would use a manual cross-tab (see faq149-243) with conditional formulas. There would be a detail formula for each month that checks to see if the person was working during that month, something like this for July:

If Start <= Date (2002,7,31)
then 1
else 0

Then you can subtotal each of these formulas by month. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com