Hi All Here is a Strange problem . i have a report with 3 datasets and First 2 returns Latest Date and Latest Time of the Cube and 3rd one Returns latest KPI values of that Date and Time . we have set auto refresh property for every 1 min but we are not getting the latest KPI values into the tablix but we have Text box which dispalys latest date and time is showing correctly . when we reenter ( In BIDS Go to Design Tab and Come back Preview tab and in Repoting server Refresh the IE ) the report then only we are able to see the latest KPI values in tablex . How resolve this issue , how can we get the latest data with Autorefresh only .Surendra Thota

Hi all Found the Issue . The SSRS Autorefresh property is not able to refresh the Report Parameter values . The latest date and time coming from 2 datasets are unable to update the Data and Time Report Parameters with AutoRefresh . This is Issue SSRS AutoRefresh property .Surendra Thota

Hi All, How did you refresh the data. Even i am getting the same issue.My cube has been updated with some data but this data is not showing in SSRS.How to fix this? How should i refresh the cube to get updated data in SSRS. Any help would be greatly appreciated.

Hi sandy There is a Bug in SSRS with auto refresh . Autorefresh is unable to asssign value to parameter . So dont use any parameterized Query ( if parameter value changes dynamically ) . if you let me know your case , i can help you in work aroundSurendra Thota