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.
| Author |
Topic |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2005-03-31 : 14:55:52
|
| Is it possible to add in a date control or calendar to parameters for reporting services? I would like to add like a button or something that the user can just click and choose the date that they wanted so that they don't have to enter it in manually. Any suggestions? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-31 : 15:04:26
|
| I think the best that you can do if you are using Report Manager to view reports is to have one parameter for year, one for month, and one for day. Then you could hard code the years, 1-12 for months, and 1-31 for days. The RS sample reports have examples of this.We don't use Report Manager to view reports, so we are able to use the calendar in ASP.NET when asking for the inputs. Then we pass those to the actual report.Tara |
 |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-03-31 : 15:34:57
|
| Yes. That is the downfall of using the Report Manager, but my boss wants everything in Report Manager and then use our group policy in to control security. Which is kind of nice, in that you set it and forget about it. Whoever belongs to that group will only be able to view that certain report. But a lot of features that can be accomplish in asp.net is now not available.I wonder if possible to have a dll calendar control and reference it that way. Would be nice though.One that I'm thinking about is the calendar control from excentric, but don't know how will xml and asp.net integrate with one another. |
|
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2005-08-09 : 16:04:01
|
| Has anybody figured out an easy way to get a calendar control into Reporting Services yet? |
|
|
|
gcowhsu
Starting Member
38 Posts |
Posted - 2005-08-12 : 17:48:49
|
| We store the dates in a database and then just run a query to get the month day and year for a parameter. |
|
|
|
|
|
|
Date Control?