SSRS 2008 R2 SharePoint default parameter problem - by Daniel Colbert

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 777529 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/25/2013 11:54:15 AM
Access Restriction Public


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