Report to look like a calendar

I have thought about this, and I cannot in my head come up with a way to create this. Maybe I am thinking about it too much, or maybe it is this difficult and I will need a 3rd party tool.

My users have requested a SQL Reporting Services report that looks like a calendar. Each page will be one month on the calendar. And then the data will fall on the calendar according to a date field in the database. It should not be all that difficult, but I cannot think of a way to acheive this.

Has anyone tried to build a report that is basically just a calendar, and each page is a month of the calendar? If so, did you build it using the standard SQL reporting services tools, or did you purchase a 3rd party vendor?

Let me know what route I should look to follow.

Thank you!

T.J.

I think you can do this in reporting service.

I havent done anythig like this but i just thought a way which i used in one of my report..

in matrix create row group

1) by year

2) by month

3) by week and keep 7 columns for each day of the week..

I will try to do this.. If i succeed i will sruely let you know.

|||

Thank you very much. If you are successful, let me know.

By "in matrix" I believe you are refering to a SQL Reporting Services "table" tool, and you will create a group by year, then a group by month, then a group by week, and the week group of the table will have 7 columns.

That sounds possible. Let me know if you are successful, and if so if you run into any unexpected errors.

Thank you for the idea!

T.J.

|||

I have been looking into this in my free time, and could not think of a way to correctly display the data on a SQL report so that it looks like a Calendar. I don't know if anyone else has had any luck with this or not.

I found a 3rd party tool named "Dundas" that appears to allow exactly what I need. Has anyone used Dundas, and if so, have you had any luck?

I also heard that Dundas as going to be included in SQL Reporting Services 2008 version. Can this be verified?

Let me know if you have used Dundas, and your thoughts on their product.

Thank you,

T.J.

|||

In terms of your initial question, I implemented something similar for someone who wanted charts layed out like a calendar. This can easily be adapted to what you want to do. Check out this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2050082&SiteID=1

Dundas is arguably the best RS charting tool out there. They have Chart, Gauge, Map and Calendar control for RS reports. The "out-of-the-box" RS charts are in fact developed by Dundas.

In terms of SQL RS 2008, you are correct. MIcrosoft have purchased the RS charting technology from Dundas and will include them out the box in 2008. There is currently still debate whether all the Dundas control will be available in the first release.

You can follow the discussions on this in the Katmai RS forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1