Weekly Activity Chart -- sql server reporting services

Bethany
5/18/2005 11:16:07 AM

I need to create a chart that tracks activity on a weekly basis. I am using

SELECT
MIN (datecompleted), COUNT(activity)
from table
GROUP BY DATEPART(ww,datecompleted), DATEPART (yy,datecompeted)

This gives me a date for the beginning of each week and the amount of
activity for all weeks where there was activity. However, on a week with no
activity, the date will not display and therefore won't display on my chart.

Robert Bruckner [MSFT]
5/18/2005 11:19:18 AM

On way to achieve this is to turn on "numeric or time scale value" for the
x-axis. Make sure that your category grouping expression evaluates to a
DateTime object.

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

sql server reporting services : Weekly Activity Chart