[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Items per month report in SSRS (Reporting Services)

Posted on 2009-02-13
2
Medium Priority
?
677 Views
Last Modified: 2012-05-06
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!
0
Comment
Question by:jdroger2
1 Comment
 
LVL 8

Accepted Solution

by:
OBonio earned 2000 total points
ID: 23632945
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question