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 |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2008-01-07 : 12:51:59
|
| Hi:New Year, new project, I am working in a Report that requires a date Range:From: Jan 01, 2008 To: Jan 16, 2008 for example.How can I set this up in Reporting Services? The From Date will be set as the Beginning Day for each month. I already finish with that part =DATEADD(mm, DATEDIFF(mm,0,getdate()), 0) AS [First Day Cur Month], /*first day of current month, current year*/I need the second part- how to create a Date To:Thanks,Osirisa |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-07 : 12:56:13
|
| What does your requirement suggest for setting of end date? |
 |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2008-01-07 : 13:00:37
|
| User can enter any day from 1- the end of month. |
|
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2008-01-07 : 13:01:22
|
| User can enter any day starting with 1 to the end of month.Thanks,Osirisa |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-07 : 13:07:35
|
| Then you dont need to set any value. Just default the param to NULL. Just select check box stating 'allow null value' in report parameters window. Do remember to handle this passed NULL in your query for dataset. |
|
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2008-01-07 : 13:57:47
|
| Is there anyway that I can add a Calendar control without using ASP.Net page? I am using SQL 2000 and Visual Studio 2003. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-08 : 01:00:42
|
| Defining a report param as date type automatically puts a calendar control for it in Reporting services. Cant understand need of a seperate calendar control? |
|
|
|
|
|
|
|
|
New to Reporting Services