Avoid Page refreshment on each parameter selection in 2008 R2

  • hi..

    any one know how to avoid this page refreshment on each parameter selection???

    Thanks,

    Komal

  • Don't use cascading parameters

  • hey...I am not using any cascading paramters!!!

  • If there are 4-5 drop down list into my report then on selecting any values from drop down list whole report get refresh and slow down the process.I dont want this.Instead of this i want to refresh report after slection of all values from diff drop down list at last moment when i am clicking on the view report button.

    The solution i got is :report paramter properties -> Advanced -> Never refresh.I dont think this is right solution.

    Any solution is appreciated.

  • If you have multiple parameters, say parameter 1 is Country, parameter 2 is City, and you add a where clause to parameter 2 dataset (City), to check Country first, then supply City, then parameter 2 (City) will jump slightly, its normal. You will also notice that for parameter 1 dataset (no where clause), there is no slight jump. This is normal SSRS behaviour.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply