Items per month report in SSRS (Reporting Services)

I have a database with trouble tickets, each one having a date and an amount of billable time spent on the ticket.  I am trying to create a report in ssrs that will show how how many tickets / billable time there are per month.  I am stumped on how to accomplish this seemingly trivial task.  What should my data query look like and does the report do the math or the query?

Thanks!
LVL 1
jdroger2Asked:
Who is Participating?
 
OBonioCommented:
I would try and do as much of the math(s) in the query as possible.  The query could look something like this :

select datepart(m, iddatetime) AS [Month], count(*) AS TicketCount, sum(BilledAmount) AS TotalBilled from TicketBillable
group by datepart(m, iddatetime)

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.