paramter refresh

• super48

  SSCrazy

  Points: 2682

  More actions

  March 28, 2017 at 2:09 am

  #335926

  hi,
  I have one report in that 2 parameters are cascaded.
  remaining or not.
  when I change the cascade parameter report parameters refresh(loading happens) that's normal.
  but  I change other parameter which is independent that time also report parameters get refreshed .
  my i know the reason and how to avoid this unnecessary refresh

• Thom A

  SSC Guru

  Points: 99137

  More actions

  March 28, 2017 at 3:00 am

  #1935215

  In the Paramter properties, in the advanced pane, change Refresh data when the parameter changes to never refresh. You'll have to physically refresh it then.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• super48

  SSCrazy

  Points: 2682

  More actions

  March 28, 2017 at 9:27 am

  #1935299

  its not working(may be I am doing something wrong)
  instead what I did is I moved all the cascading parameters to the top.
  and kept independent parameter in the bottom
  now if I change parameter its not refreshing anymore
  but I don't want change order.
  is there is solution or ssrs works like this.