sql server - SQL Reporting Services 2005 - Non-queried Report Parameters -

I am working on a report of reporting services and I did not know if I should report the non- / P>

I am trying to get the current year and have tried:

  = YEAR (today ()) = DATEPART ("yyyy", today ()) < / Code> 

I have tried today instead of today ()

All of these start to break the year's dropdown on my report. I thought if something was wrong then Correct him That will not ... but no, it breaks the whole region.

Any thoughts? Article?

Update: Wait, wait, wait ... The strange thing is the year's parameter is the second parameter of this report. And its gray (no value) until I select the first parameter (my case "category"). Am I going to tell the ultimate of the year to do this? Or does SSRS process 2005 processes in sequence? I do not think I've ever seen it before.

Update 2:
Please see all comments

Edit: Bruno - "post-lesson" itemprop = "text"> <<> = date time.Today << / code>

The same behavior as you see I have a string before A sample report is prepared with a default value with parameters, and with string 2 parameter = default = DateTime.Today.Year when I have the default in the form of 2 parameters Land, it is empty and appear disabled.

I was able to correct this problem by 2 ways: first = by adding the default of string. My first parameter is empty, and the second way was to change the order of the parameter only.

Not sure whether this behavior is with design or bug - but as you said, I have not seen it till date when you told it in your question.