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 |
|
learntsql
524 Posts |
 Posted - 2010-04-08 : 08:38:42
|
| Hi All,I am using FromDate and ToDate as datetime parameters in my report.I want to make that report as subscription,How can include today's date in "ToDate" parameter as default value.Any other ways?TIA. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-08 : 11:34:00
|
| just add Now() as default value in report parameters tab------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-08 : 11:34:31
|
| and make sure you strip off time part if you want only date------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
learntsql
524 Posts |
Posted - 2010-04-09 : 00:45:53
|
| ThankQ Visakh.But When I am Opening the report taking long time to load the report.How to analyze this issue? |
|
|
|
|
|
|
Default getdate() value in dateparameter