In a SQL2005 Reporting Subscription I need to revert the parameter back to the default value "override-default."
This value was updated to a specific value and now I am unable to have the report updated daily with the new data.
Within Report Manager, drill into the specific report, click on the properites tab, and chose the second link on the left "Parameters." For the value in question (DataID) someone unchecked the "Has Defalult" button. This results in the "Use
Default" check box being removed from the UI in the Subscription tab. I can get the Use Defalut box back by entering a specific value in the 'defalut value' but the report runs against that one value (instead of updating daily.)
Before the "Has Defalult" was unchecked, the Defalut Value is a buttton, which says "Override Defalut." It is this 'button' that I am trying to get back.
I've googled this and looked thru MS kb without luck. (I think it maybe a matter of using the right language...)
Thank you for your reply.
View Complete Post