Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Using a Calendar Control in an SQL Report

Author  Topic 

gogetter
Starting Member

18 Posts

Posted - 2008-05-15 : 11:59:07
We have developed several reports using VS 2005 and deployed them to our SQL 2005 reporting server. As most of our reports use date parameters we would like to incorporate a calendar control to allow users to select their date range as opposed to typing them in. I have done some reseach online but can only find vague references on how to do this. Has anyone out there been able to successfully deploy a calendar control onto an SQL report? Thanks!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-15 : 12:23:27
Why do you want to use a seperate calendar control when reporting services provides you with one already? just make your parameter type datetime and reporting services automatically places a calendar control for it.
Go to Top of Page

gogetter
Starting Member

18 Posts

Posted - 2008-05-15 : 12:52:39
quote:
Originally posted by visakh16

Why do you want to use a seperate calendar control when reporting services provides you with one already? just make your parameter type datetime and reporting services automatically places a calendar control for it.



Oh wow, I didn't realize it was creating the date/time parameters as strings as opposed to date/time. Thanks for providing this very simple solution, it is working great now!
Go to Top of Page
   

- Advertisement -