Thanks y'all... That got me there!

Month() gave me the number of the month but Datename(m,...) gave me the name of the month so I went with that one.

Thank you for your suggestion.

I'd tried that, and it does in fact count for each day, but what I'm looking for is a count by month not day.

Solved:

I removed the parameter references from my query (@StartDate, @EndDate) but left them in the Report Parameters dialogue and made them Hidden. This removed the parameters fields from the subscription...

You are the Man... THX!!!

I tweaked your query a bit and it works perfectly:

SELECTdescription as [Plan Name],

per.first_name + ' ' + per.last_name as [Patient],

substring (plan_start_date, 5,2) + '-' +

substring...

Hi sdvoranchik,

Thank for your reply. I tried your suggestion but it failed because appt_date was still included in the order by. Once I removed it it returned the expected results....

Anybody... anybody..... Bueller?