Skip to Content
0
Former Member
Oct 28, 2009 at 12:30 PM

Variable to show ALL days of the month

33 Views

I have a data provider that looks like this:

OID Name Occurence

1 Lemons 20/10/2009

2 Apples 21/10/2009

3 Pearss 24/10/2009

4 Lemons 20/10/2009

5 Apples 21/10/2009

I want produce a cross tab that INCLUDES the count for each day of the month even if an occurence has not happened on that date:

Date 01/10 through to 30/10

Lemons

Apples

Pears

er how do I do this?