Hi all, I'm new to SSRS. I have a report that has an integer parameter on it where the user needs to input YEAR to get the report for the said year. I would like to set the default to the current year but every time I set an expression "=Year(Today())" to set the default value, when i preview the report, the parameter textbox is disable with no value on it. Can anyone help me with this? Thanks in advance

Hi,Can you tell me which version of SSRS you're using (e.g. 2005, 2008)and how you are building and viewing the report (i.e. which tools are you using)?Thanks,PaulThis posting is provided "AS IS" with no warranties, and confers no rights.

Hi, Can you tell me which version of SSRS you're using (e.g. 2005, 2008)and how you are building and viewing the report (i.e. which tools are you using)? Thanks, Paul This posting is provided "AS IS" with no warranties, and confers no rights. I'm using SSRS 2008 and building the report using report designer through Business Intelligence Development Studio in Visual Studio 2008. I'm using Stored procedure on the dataset.

Hi,It might be caused by the current year out of the range of the available parameter values. If the parameter is from a query, make sure you could find the current year in the dataset. The defualt parameter valueshouldexist in the available values for the parameter.If there are any more questions, please let me know.Thanks.***Xiao Min Tan***Microsoft Online Community***

Change the order of your parameters. At the very least, parameters with dependencies on other parameters need to be below them in the list. There may be other subtleties I'm not aware of. Just disabling parameters without any kind of warning or other indication of what's going on is, in my opinion, a quite nasty thing for the product to do. I'd love to give the person or team that decided that a piece of my mind. :)

Hi jay.jose, I too faced this problem. i.e. when you want to display current year as default and if you put an expression in parameter default value then this parameter is disabled. this is by design or a bug not sure but there is a work around.. 1. Create a hidden parameter and put the expression (" =Year(Today()) ") in default value. 2. Move this parameter on top in the list. 3. Call this parameter in your original Year parameter default value. This way your year parameter can display current year as default. Please feel free to ask if you have any questions.. Regards, Senthil