I'm running MOSS 2007 with SSRS 2008, and I'm encountering an issue with an SSAS-backed report that has four parameters, all of which are attributes on the same dimension. When I run the report from MOSS, it works just fine. When I change the parameters from the default values to specific values, the report still runs fine. When I try to create a subscription for the report, however, I encounter issues with setting parameters on the subscription page.
If I override the default value for the first parameter, the screen will refresh to give me more focused values for the other parameters. If I then override the default value for the second parameter, the screen will refresh again, but the second parameter's value will not appear in the box. Moreover, the third and fourth parameters will be completely greyed out, including the radio buttons.
The maddening part of this is that we have a dev server with three different SSRS integrated MOSS sites. For all three of these sites I don't see the behavior indicated above. It is only on our production site that I see this behavior. I know we recently installed MOSS 2007 SP 2 in dev, but we can't move this to production because it would break a few "undocumented features" in Excel Services. Besides, I don't see anything in the MOSS 2007 SP 2 notes about patches to the SSRS add-in. Does anyone else encounter this issue? If so, can you point me to the specific patch for this issue?
UPDATE: this is fixed in SQL 2008 SP 1 CU 3, which was applied to our dev environment and not to production.