Group by date

[mcquam]

I have a crosstab which needs to show a count of cases opened, cancelled and completed for each month by person. However I am counting date fields and if I group by the date in one field, it only returns records from another field if there is data there but I need to count even if there is no data in the first field.

I've tried creating a variable to hold a date parameter and adding a command but surely there is an easier way?

 

[Madawc]

If you could get a table (dataset) added to the database with one entry per month, you could do a crosstab on that basis.

If you can't add a table, you'll be stuck with creating a 'Mock Crosstab'. Crosstabs are fine if you don't mind the absence of rows or columns with no data, but you said you wanted empty slots to show.

A 'Mock Crosstab' is something that looks like a Crosstab, but in fact you define each column yourself, normally as a running total. This would need to go in the report footer, because running totals count as the reports 'run' and they will not be complete until then.

Crystal should have included an example along with the Crosstabs. You can save a little time by doing a paste to a dummy report, changing the name and then pasting back.

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[mcquam]

OK thanks