Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Change report parameter dynamically Expand / Collapse
Author
Message
Posted Wednesday, March 12, 2014 12:24 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 5:10 AM
Points: 25, Visits: 56
I have a dataset which has 1 column and which returns different values each time it is executed .

Now I want to have a hidden report parameter , which changes in accordance to this dataset values. (there should not be any user intervention) and the report should display a new value automatically every 10 seconds , like a moving display in Airlines, Railways etc

I have set the Report Auto-Refresh Property to true. Every time , the report refreshes, I want it to take new values for the Report Parameters. In the Report Parameter, if I set the DEFAULT Values to QUERY -->DATASET , then every time the report refreshes, it shows the same value. I want it to show different values. I have set the AVAILABLE VALUES TO NONE.

IN the Report Parameters, If I set the DEFAULT VALUES to None and AVAILABLE VAlues to Query Dataset , then it gives me the error "The Parameter X is missing a Value".
but I read in some article that WE CANNOT DYNAMICALLY CHANGE THE REPORT PARAMETER DEFAULT VALUES. (http://social.msdn.microsoft.com/Forums/sqlserver/en-US/56af8fd9-badc-4a1a-b365-630322d5c765/change-report-parameter-default-values-dynamically?forum=sqlreportingservices)

How Do I Dynamically change my PARAMETER VALUES . I am using SQL 2008 R2.

Post #1550378
Posted Monday, March 24, 2014 11:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 5:10 AM
Points: 25, Visits: 56
how to change report parameters dynamically
Post #1554173
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse