Report for Monthly ,Weekly ,Daily

Posted Date: 30 Nov 2009 Posted By:: Amal anthony Member Level: Silver Member Rank: 1034 Points: 1 Responses: 6

I need to create report from SQL Server 2005 Reporting Services that shows the following:

Daily Report
Details

Date Opened Resolved
1/3/2006 26 20
1/4/2006 87 90
1/5/2006 2 2
1/6/2006 26 24
1/7/2006 15 15
1/8/2006 19 10
1/9/2006 10 9
1/10/2006 7 4

Weekly Report
Week Ending Opened Resolved
3/5/2006 22 21
3/12/2006 64 50
3/19/2006 27 26
3/26/2006 50 30
4/2/2006 50 25

Monthly Report

Month Opened Resolved
February 150 145
March 526 500
April 89 88

All three of these reports are based on the entered(date) field and the closed(date) field in a table called calls.

Thanks in Advance.

Responses

#448579 Author: Alwyn Duraisingh Member Level: Gold Member Rank: 11 Date: 30/Nov/2009 Rating: Points: 2
How will your Calls table looks like? Enter atleast two rows of data. Regards, Alwyn Duraisingh.M << Database Administrator >> Jesus saves! The rest of us better make backups...

#448657 Author: anbu Member Level: Gold Member Rank: 529 Date: 30/Nov/2009 Rating: Points: 2
SELECT Date, Opened, Resolved FROM table1 order by DATE desc SELECT Date, Opened, Resolved FROM table1 WHERE DATE BETWEEN GETDATE()-7 AND GETDATE() SELECT Date, Opened, Resolved FROM table1 WHERE DATE BETWEEN GETDATE()-30 AND GETDATE()

#448764 Author: Alwyn Duraisingh Member Level: Gold Member Rank: 11 Date: 01/Dec/2009 Rating: Points: 2
Anbu, we have to calculate the opened and resolved from calls table, there are no such fields present in the calls table. Regards, Alwyn Duraisingh.M << Database Administrator >> Jesus saves! The rest of us better make backups...

#448869 Author: Amal anthony Member Level: Silver Member Rank: 1034 Date: 01/Dec/2009 Rating: Points: 2
Thank you so much for your reply Anbu and Alwyn. Here i have provided some sample data and required output . You just copied the below contents and paste into notepad or query analyser to have better view. Date Name Status 22-Oct-2009 Amal Closed 22-Oct-2009 Amal Closed 22-Oct-2009 Mani Closed 22-Oct-2009 Mohan Closed 22-Oct-2009 Amal Open 22-Oct-2009 Amal Open 22-Oct-2009 Amal Open 23-Oct-2009 Mohan Closed 23-Oct-2009 Mohan Closed 23-Oct-2009 Mohan Open 27-Oct-2009 Amal Closed 27-Oct-2009 Amal Open 24-Nov-2009 Mani Closed 24-Nov-2009 Amal Open 24-Nov-2009 Amal Closed 24-Nov-2009 Mani Closed 24-Nov-2009 Amal Closed 1-Dec-2009 Mani Closed 1-Dec-2009 Mani Closed 1-Dec-2009 Amal Closed 1-Dec-2009 Mani Closed Monthly Report Daily Report Name October November December 22-Oct-09 23-Oct-09 27-Oct-09 24-Nov-09 1-Dec-09 Open Closed Open Closed Open Closed Open Closed Open Close Open Close Open Closed Open Closed Amal 4 3 1 1 0 1 3 2 0 0 1 1 1 2 0 1 Mani 0 1 0 0 0 3 0 1 0 0 0 0 0 2 0 3 Mohan 0 1 0 0 0 0 0 1 1 2 0 0 0 0 0 0

#448872 Author: Amal anthony Member Level: Silver Member Rank: 1034 Date: 01/Dec/2009 Rating: Points: 2
Sorry. View is not in a proper way. So I have attached the excel sheet which contains the data and required output Sample-Data.xlsx

#448878 Author: Amal anthony Member Level: Silver Member Rank: 1034 Date: 01/Dec/2009 Rating: Points: 2
Here Name Should come as row while month and date should come as column. Awaiting your reply.

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Cannot resolve the collation conflict ??? What is this ERROR
	Previous : Doubt in SQL Report
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages

Follow us on Twitter: https://twitter.com/dotnetspider

Active Members
Today

Last 7 Days

more...

Awards & Gifts

Email subscription