Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2005
    Location
    Avon Lake, OH
    Posts
    112

    Question Unanswered: Chart /crosstab by month misses months with no data

    I have a set of data with a date/time stamp on each row. I need to summarize the data (as a simple count of rows) in a crosstab and in a chart, showing the counts by month. This works fine so long as there is at least 1 data point for a month. How can I get the crosstab / chart to show months with no data points?

    E.g.

    11/1/2004 ...
    11/12/2004 ...
    1/4/2005 ...
    1/6/2005 ...
    1/9/2005 ...

    This will summarize as:

    Nov '04 Jan '05
    2 3

    but I want:
    Nov '04 Dec '04 Jan '05
    2 0 3

    I believe this is the same problem as "Kronos Workforce with CR9" (although I am using SQL Server 2000 and Crystal 8.5 and 10).
    Last edited by bcummings; 02-01-05 at 09:02. Reason: typo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •