Page Refresh After Parameter Entry

I've been seeing an issue with several of my reports where it will
refresh the page after any parameter is entered or changed. Has anyone
else witnessed this or found a way to keep it from refreshing until the
'view report' button is clicked?
Cheers,
BenIf there are parameter dependencies, then the parameter valid values will
update. For example if parameter a is a catalog, and parameter b is a list
of products. parameter b uses 'a' as input for the query, then the page
requires a postback to run the parameter query. Is this what you are
seeing?
Thanks,
Steve MunLeeuw
"sullins602" <ben.sullins@.gmail.com> wrote in message
news:1154541094.061852.59400@.p79g2000cwp.googlegroups.com...
> I've been seeing an issue with several of my reports where it will
> refresh the page after any parameter is entered or changed. Has anyone
> else witnessed this or found a way to keep it from refreshing until the
> 'view report' button is clicked?
> Cheers,
> Ben
>|||Thanks for the reply Steve...
Yes that is how it appears, the issue here is that there are no
parameter dependencies...any idea's?
Thanks,
Ben
Steve MunLeeuw wrote:
> If there are parameter dependencies, then the parameter valid values will
> update. For example if parameter a is a catalog, and parameter b is a list
> of products. parameter b uses 'a' as input for the query, then the page
> requires a postback to run the parameter query. Is this what you are
> seeing?
> Thanks,
> Steve MunLeeuw
>
> "sullins602" <ben.sullins@.gmail.com> wrote in message
> news:1154541094.061852.59400@.p79g2000cwp.googlegroups.com...
> > I've been seeing an issue with several of my reports where it will
> > refresh the page after any parameter is entered or changed. Has anyone
> > else witnessed this or found a way to keep it from refreshing until the
> > 'view report' button is clicked?
> >
> > Cheers,
> > Ben
> >|||Hmmm, if there are no parameter dependencies, then you are correct the page
shouldn't reload. I've had trouble of parameter definitions not getting
updated when overwriting during the publish. I'm just grasping at straws
here, but I'd rename the report and publish it and test. If that doesn't
work I'd test with just a single parameter and start building them up from
there.
Steve MunLeeuw
"sullins602" <ben.sullins@.gmail.com> wrote in message
news:1155951876.839117.289800@.i3g2000cwc.googlegroups.com...
> Thanks for the reply Steve...
> Yes that is how it appears, the issue here is that there are no
> parameter dependencies...any idea's?
> Thanks,
> Ben
> Steve MunLeeuw wrote:
>> If there are parameter dependencies, then the parameter valid values will
>> update. For example if parameter a is a catalog, and parameter b is a
>> list
>> of products. parameter b uses 'a' as input for the query, then the page
>> requires a postback to run the parameter query. Is this what you are
>> seeing?
>> Thanks,
>> Steve MunLeeuw
>>
>> "sullins602" <ben.sullins@.gmail.com> wrote in message
>> news:1154541094.061852.59400@.p79g2000cwp.googlegroups.com...
>> > I've been seeing an issue with several of my reports where it will
>> > refresh the page after any parameter is entered or changed. Has anyone
>> > else witnessed this or found a way to keep it from refreshing until the
>> > 'view report' button is clicked?
>> >
>> > Cheers,
>> > Ben
>> >
>|||Do any of the parameters have their default values set to an expression? If
a parameter has an expression of any type as its default, reporting services
assumes that it could potentialy rely on other parameters, so every time a
parameter before it in the parameter list is changed, the page refreshes.
I ran into this when trying to set the default for date parameters to the
beginning and end of the current month. I found that if I created a new
dataset and calculated the default values in sql and returned each of them as
a separate column, I could set the parameter defaults to the dataset and
prevent the page from refreshing.
Hope this helps.
David
"sullins602" wrote:
> Thanks for the reply Steve...
> Yes that is how it appears, the issue here is that there are no
> parameter dependencies...any idea's?
> Thanks,
> Ben
> Steve MunLeeuw wrote:
> > If there are parameter dependencies, then the parameter valid values will
> > update. For example if parameter a is a catalog, and parameter b is a list
> > of products. parameter b uses 'a' as input for the query, then the page
> > requires a postback to run the parameter query. Is this what you are
> > seeing?
> >
> > Thanks,
> > Steve MunLeeuw
> >
> >
> > "sullins602" <ben.sullins@.gmail.com> wrote in message
> > news:1154541094.061852.59400@.p79g2000cwp.googlegroups.com...
> > > I've been seeing an issue with several of my reports where it will
> > > refresh the page after any parameter is entered or changed. Has anyone
> > > else witnessed this or found a way to keep it from refreshing until the
> > > 'view report' button is clicked?
> > >
> > > Cheers,
> > > Ben
> > >
>|||ok so the problem turned out to be that the parameters were out of
order. In the data set definition they went in A,B,C,D and in the
report definition they went D,C,B,A. Now that the two are in order it
runs w/o doing any page refreshes between paramater entry.
Thanks!
David Siebert wrote:
> Do any of the parameters have their default values set to an expression? If
> a parameter has an expression of any type as its default, reporting services
> assumes that it could potentialy rely on other parameters, so every time a
> parameter before it in the parameter list is changed, the page refreshes.
> I ran into this when trying to set the default for date parameters to the
> beginning and end of the current month. I found that if I created a new
> dataset and calculated the default values in sql and returned each of them as
> a separate column, I could set the parameter defaults to the dataset and
> prevent the page from refreshing.
> Hope this helps.
> David
> "sullins602" wrote:
> > Thanks for the reply Steve...
> >
> > Yes that is how it appears, the issue here is that there are no
> > parameter dependencies...any idea's?
> >
> > Thanks,
> > Ben
> > Steve MunLeeuw wrote:
> > > If there are parameter dependencies, then the parameter valid values will
> > > update. For example if parameter a is a catalog, and parameter b is a list
> > > of products. parameter b uses 'a' as input for the query, then the page
> > > requires a postback to run the parameter query. Is this what you are
> > > seeing?
> > >
> > > Thanks,
> > > Steve MunLeeuw
> > >
> > >
> > > "sullins602" <ben.sullins@.gmail.com> wrote in message
> > > news:1154541094.061852.59400@.p79g2000cwp.googlegroups.com...
> > > > I've been seeing an issue with several of my reports where it will
> > > > refresh the page after any parameter is entered or changed. Has anyone
> > > > else witnessed this or found a way to keep it from refreshing until the
> > > > 'view report' button is clicked?
> > > >
> > > > Cheers,
> > > > Ben
> > > >
> >
> >