March 12, 2014 at 12:24 pm
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.
March 24, 2014 at 11:49 am
how to change report parameters dynamically
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply