I posted this in the SQL Team forum: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99696
It shows you a good way of creating a bunch of date functions so that you can use them in reporting services as date default values for any date parameter.
This article relates to a couple of articles that are on the site. The original article was "Cool Tricks With The ASP.net Calendar". You can find this here: http://weblogs.sqlteam.com/jhermiz/archive/2007/12/10/Cool-Tricks-With-The-ASP.net-Calendar.aspx. The other article you might find useful is the "Additional Tip For that Calendar Control In ASP.net" this article can be found here: http://weblogs.sqlteam.com/jhermiz/archive/2007/12/11/Additional-Tip-For-That-Calendar-Control-In-ASP.net.aspx.
Have you ever wanted to create a nice calendar control much like the sharepoint calendar control? You know the calendar control with hyperlink data directly on each calendar day. The previous articles shows you how to use the DayRender Calendar control event to add image controls. But what...
Regarding my post about the tips and tricks with the ASP.net calendar control someone emailed me asking how to add additional text / images to the calendar control to give the calendar day a more appealing visual representation.
Something to this effect:
You handle images like so in the same event as we discussed before. The event you want to use for this is the DayRender event since you want to control each day. Anytime you need to handle something that is associated with a single day cell you have to take care of it in the day render event.
How To Do...
UPDATE: Additional tips: More Tips
Been A Long Time
Hello world...sorry I haven't posted in quite some time, we've been real busy at home this Christmas season. Anyhow I thought I would share some tricks and tips with using the calendar control before you or your company spends some change to buy a control on the internet.
What Is The ASP.NET Calendar Control
The ASP.net calendar control is simply the calendar that comes prepackaged with visual studio and is available as a standard control. Here she is on the standard control:
And here is what the calendar control may look like:
You have been tasked...
Count me in this year again!
I had an excellent time last year and met some real cool folks.
I'll be in the visual studio asp.net conference along with the reporting services seminars. Bring your RS questions if you have any.
Here's some pics from last years: http://jhermiz.googlepages.com/devconnections2006
I wonder if Isaac Stubbs is still cruising in that motorcycle he won?? If you've never been to devconnections before then now is the time to go. Tell your boss you need to attend www.devconnections.com. You get a free copy of MS Visual Studio 2k8...you can easily make a case to your boss about going. Most of...
Learn how to pull a sharepoint site's list data from SQL Server, click here for more info.
Learn how to pull data from the Reporting Services database.
Learn how to pull data from SAP from a .net application and load it into sql server.
Read here for more info.