Search

SSRS 2008 R2 SharePoint default parameter problem by Daniel Colbert

Active

1
0
Sign in
to vote
Type: Bug
ID: 777529
Opened: 1/25/2013 11:54:15 AM
Access Restriction: Public
0
Workaround(s)
0
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.
Details (expand)

Product Language

English

Version

SQL Server 2008 R2 SP1

Category

Reporting Services

Operating System

Windows Server 2008 Enterprise

Operating System Language

US English

Steps to Reproduce

Develop a report with a parameter with a default set by expression.
Deploy the report to a SharePoint integrated environment.
Create a subscription - this is where the problem exists.

Actual Results

There is no radio button available for "Use Report Default Value"

Expected Results

The radio button should exist.

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.