Page refreshing after the parameter selection in SSRS report

Question

Hi,

I have couple of parameters in my SSRS report. some are multivalued and some are regular with drop down list. each time while selecting a different parameter value the page is getting refreshed. Is there any way to avoid this page refreshment on each parameter selection.

Thanks in advance. Maria

Answer 1

Not easily unless you willing to roll your own report viewer control. This is done because SSRS has parameters which can be used to determine the value of other parameters. For example imagine your looking at website users and your first option is OS, perhaps it has Vista, XP, and Mac.

When you select Vista the page refreshesh to get a list of all the various versions of Vista.

If you are using thing like this, then you won't be able to prevent the refresh.

Answer 2

In this example i have tried for the datetime parameter postback

Hope it works for you as well

:)

For the Datetime field in the Parameters make fisrt a parameter as dummy Date value & then assign this datetime value to the actual datetime parameters of the report Supposse we have a SP where we have to supply From Date & To Date

STEPS:1 Go to the Report Parameters Add a dummy Datetime Parameter as Datetime_Dummy the Name & Datetime as Datatype Make it Hidden

STEPS:2 In the Default value selection select Non-queried & give value as =Today

STEPS:3 Make sure that this is the First datetime parameter in the datetimes parameter

STEPS:4 Now take the FromDate Parameter assign its datatype as Datetime & Now in the Default value selection select Non-queried & go to the Expression Give the expression as =Parameters!Datetime_Dummy.Value

STEPS:5 By doing this it ensures that the page will not post back when From date is selected.

cheers, Smitha.......

Answer 3

Hi All,

I have done this many times ago this was just removal of parameters dependency with various permutation and combinations as per need in projects.

Just do following things.

1> Remove all dependency of parameters from the drop down population of data. 2> Pass default values under each report parameters.

I hope it will helpful.

Thank You.

Answer 4

I am facing the same issue. How to stop refreshing the report on changing a parameter value. I am using ssrs 2008 and parameters are datefields From and To

Answer 5

Has anybody found a solution to this? I'm facing this problem on a SSRS 2008. I've managed to find a partial solution with creating parameters from TSQL and transforming them and passing to MDX with custom code. But it seems to work only for a specific number of params. When I've added all the params the report suddenly start to refresh again....