I've built a SQL report in MS SQL Server Report builder for our ticketing backend. I want to be able to do custom reporting. I've created this report by using the following query:
SELECT SR_Service.Date_Closed ,SR_Service.Date_Entered ,SR_Service_SLA_Workflow.Responded_Minutes ,AVG(SR_Service_SLA_Workflow.Resolved_Minutes) AS Avg_Resolved_Minutes ,SR_Service.Hours_Budget ,SR_Service_SLA_Workflow.SR_Service_RecID AS [SR_Service_SLA_Workflow SR_Service_RecID] ,SR_Service.SR_Service_RecID AS [SR_Service SR_Service_RecID] ,SR_Service.Company_RecID AS [SR_Service Company_RecID] ,Company.Company_RecID AS [Company Company_RecID] ,Company.Company_ID FROM Company INNER JOIN SR_Service ON Company.Company_RecID = SR_Service.Company_RecID INNER JOIN SR_Service_SLA_Workflow ON SR_Service.SR_Service_RecID = SR_Service_SLA_Workflow.SR_Service_RecID GROUP BY SR_Service.Date_Closed ,SR_Service.Date_Entered ,SR_Service_SLA_Workflow.Responded_Minutes ,SR_Service.Hours_Budget ,SR_Service_SLA_Workflow.SR_Service_RecID ,SR_Service.SR_Service_RecID ,SR_Service.Company_RecID ,Company.Company_RecID ,Company.Company_ID
With a few filters set on company must not equal (some inactive companies i dont care about)
Obviously, you cannot tell this is a correct query because you don't see my database. However... it works. the report builds and I have a 2 line table, one with Customer names and the second is average time it takes to close our tickets by hours (taken minutes/60)
What I need: The ability to, when I run this report, have it ask for a date range. This can be either a few options (last week, last month, running thirty dates) OR just a place where they select a date range.