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 |
|
yomi
Starting Member
25 Posts |
 Posted - 2014-05-19 : 05:55:52
|
| Hi Guys,I want to set Default paramter value in ssrs like \[Calendar\].\[Fiscal Week\].&\[WEEK-9 2015\]the week should be current week and year will be also current year.Yogesh |
|
|
yomi
Starting Member
25 Posts |
Posted - 2014-05-19 : 07:55:07
|
| When i am hardcoding value \[Calendar\].\[Fiscal Week\].&\[WEEK-9 2015\] for current week it is showing proper data and and WEEK-9 2015 by default selected in drop down but when i am geting same value from query WEEK-9 2015 is not bydefault selected in drop down list.Yogesh |
 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-05-20 : 07:55:11
|
| you can set the default value of a parameter from an expression. An expression has access to the built-in parameters (which includes the current date) and function to manipulate values (e.g. extract the year from a date) |
|
|
|
|
|
|
SSRS Set Parameter value.