Home Dashboard Directory Help

SSRS 2008 R2 SharePoint default parameter problem by Daniel Colbert



Sign in
to vote
Type: Bug
ID: 777529
Opened: 1/25/2013 11:54:15 AM
Access Restriction: Public
User(s) can reproduce this bug


I have a report that has a date parameter. The default of that parameter is set using the expression "=Today()".

It works fine when executing the report ad hoc, but when creating a subscription it causes a problem. Normally, there is a radio button to tell the subscription to use the report default value. For this partcular parameter, the readio button is not available. The subscription will set the parameter value upon creation of the subscription, but it stays that value for each subsequent run instead of re-evaluating the expression for each successive execution.

The problem seems to be isolated to when the parameter is set by expression.

I was able to duplicate the issue on other parameters by changing them to an expression and the radio button disappeared for them, as well. I can fix the problem with the date by using a query-based default, but it doesn't really fix the problem.
Sign in to post a comment.
Posted by Microsoft on 10/22/2013 at 11:07 AM

Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product (service packs)
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available
Thanks again for reporting the product issue and continued support in improving our product

Also, the problem does not repro in SQL 2012 SP1 if you are interested to upgrade.

Mariusz cichomski
Sign in to post a workaround.