I need to create a customized report, but everything I try is not even remotely close or generates an error. I need to pull data in a single report selectable for day/week/month/quarter/year.
What I'm looking for is a report that shows which specific technician (by name) logged how may minutes in journal duration overall (as a sum only) for the time period requested - as well as how much time was logged for specific programs (by name) in Service Requests and Incidents, for the same time requested period.
dbo.Journal - CreatedBy (*The creator of the journal)
dbo.Journal - Duration
dbo.ServiceReq - Program (*This is a custom field)
dbo.ServiceReq - TotalTimeSpent
dbo.Incident - Program (*This is a custom field)
dbo.Incident - TotalTimeSpent
I'm at a loss. This is not my specialty. Can we bring back Crystal Reports now? :\
Can anyone provide assistance? It is greatly appreciated.