I have a report with 4 parameters. 2 of them are dates. Both date paremeters have default values calculated by expressions (based on the current date). The date parameters are the 1st and 3rd parameters in the parameters list (so that they appear in the order I want) In other words, there is a non-date parameter in the parameters list in between the two date parameters.
When I run the report, the 2nd date parameter is blank and grayed out, even though the expression formula is valid.
However, if I move the 2nd date parameter (which is third in the parameter list) up one place in the parameter list, so that it is in second place and directly behind the 1st date parameter, it works correctly when I run the report!
Moving the 2nd date parameter back to where it was as the third paremeter in the list causes the problem again.
The problem occurs whether I run the report in BIDS (XP Professional x32) or publish it to a report server (Win 2008 Server x64).
I've copied the report and stripped out everything except the parameters - still does the same thing- and will submit it with this feedback.