I am using Microsoft Reporting Services 2005 with SP1 on Windows 2003 server. I have also installed a HotFix that puts "Select All" back into the parameter option list.
My report has 4 parameters, all of them have multi-select enabled. Sometimes when I run the report, if I choose every option from one of the parameters, when I hit the view button, the following happens:
1)it clears that box for the parameter and nothing happens.
2) It gives me an error:
"Default value or value provided for the report parameter 'MyParam' is not a valid value."
This is really weird because sometimes it works and sometimes it does not work. I have been trying to find a sequence that makes it happen, but so far I cannot put a reason to it. The fact that the same report runs with the same parameters, makes me think that the report code and data are fine and this is bug.
Any help is appreciated,
Thanks,
Shab
My report has 4 parameters, all of them have multi-select enabled. Sometimes when I run the report, if I choose every option from one of the parameters, when I hit the view button, the following happens:
1)it clears that box for the parameter and nothing happens.
2) It gives me an error:
"Default value or value provided for the report parameter 'MyParam' is not a valid value."
This is really weird because sometimes it works and sometimes it does not work. I have been trying to find a sequence that makes it happen, but so far I cannot put a reason to it. The fact that the same report runs with the same parameters, makes me think that the report code and data are fine and this is bug.
Any help is appreciated,
Thanks,
Shab