SSRS dataset refresh
Posted on 2009-04-16
Hi, I have a report parameter. I pass that value to a stored procedure that populates my table, the dataset for my table on the report. The first time it runs great. However, when I go back to the report parameter and choose a different value, and execute the report (the procedure), it seems as if it is not refreshing the report. In Access I remember there was a property to repaint the screen or requery. Is there such a property in SSRS to ensure the values are all current with each parameter choice?
I tried the refresh icon and it is hit or miss. If I do it a few times, then regardless of the choice I make for a parameter, the value defaults to null.