Prev: SSRS 2005 Unable to get Forms Authentication Sample running
Next: Turn-off autoscroll when drilldown
From: Mike on 24 Jan 2008 18:23
I guess it can be nice that the reports automatically run for you but
sometimes it just causes issues with our reports, especially large
reports. They can get stuck running the SQL so I can't move around
between the tabs.

Normally I just want to see something on the History tab or security
and not run the report every time I browse to it.

So is there any way to disable this ?

thanks
From: EMartinez on 24 Jan 2008 19:39
On Jan 24, 5:23 pm, Mike <m_highto...(a)hotmail.com> wrote:
> I guess it can be nice that the reports automatically run for you but
> sometimes it just causes issues with our reports, especially large
> reports. They can get stuck running the SQL so I can't move around
> between the tabs.
>
> Normally I just want to see something on the History tab or security
> and not run the report every time I browse to it.
>
> So is there any way to disable this ?
>
> thanks


If you have report parameter(s), set the Default Value(s) to Null.
Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant
From: Mike on 25 Jan 2008 14:19
On Jan 24, 6:39 pm, EMartinez <emartinez....(a)gmail.com> wrote:
> On Jan 24, 5:23 pm, Mike <m_highto...(a)hotmail.com> wrote:
>
> > I guess it can be nice that the reports automatically run for you but
> > sometimes it just causes issues with our reports, especially large
> > reports.  They can get stuck running the SQL so I can't move around
> > between the tabs.
>
> > Normally I just want to see something on the History tab or security
> > and not run the report every time I browse to it.
>
> > So is there any way to disable this ?
>
> > thanks
>
> If you have report parameter(s), set the Default Value(s) to Null.
> Hope this helps.
>
> Regards,
>
> Enrique Martinez
> Sr. Software Consultant

Ok, so it's really just the parameters having default values that is
causing the reports to start up as you navigate to them? I'm
positive most of them have a date default. So if I can't set that to
Null then this will keep happening.

thx
From: Bruce L-C [MVP] on 25 Jan 2008 16:04
You can also have a hidden parameter with no value (you don't have to use it
for anything). That will stop it from happening.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Mike" <m_hightower(a)hotmail.com> wrote in message
news:310e1d9c-f36e-410e-ae7f-66461faff4be(a)j78g2000hsd.googlegroups.com...
On Jan 24, 6:39 pm, EMartinez <emartinez....(a)gmail.com> wrote:
> On Jan 24, 5:23 pm, Mike <m_highto...(a)hotmail.com> wrote:
>
> > I guess it can be nice that the reports automatically run for you but
> > sometimes it just causes issues with our reports, especially large
> > reports. They can get stuck running the SQL so I can't move around
> > between the tabs.
>
> > Normally I just want to see something on the History tab or security
> > and not run the report every time I browse to it.
>
> > So is there any way to disable this ?
>
> > thanks
>
> If you have report parameter(s), set the Default Value(s) to Null.
> Hope this helps.
>
> Regards,
>
> Enrique Martinez
> Sr. Software Consultant

Ok, so it's really just the parameters having default values that is
causing the reports to start up as you navigate to them? I'm
positive most of them have a date default. So if I can't set that to
Null then this will keep happening.

thx


From: Nicolas nicolasheurtevin at yahoo point on 22 Feb 2008 10:48
Hi,

I'm a french developer and i have a question about reports in Reporting
Services
How can I disable the automatically run on a report without add a hidden
parameter or a parameter with default value to null ?

Thanks a lot


--
Nicolas


"Bruce L-C [MVP]" wrote:

> You can also have a hidden parameter with no value (you don't have to use it
> for anything). That will stop it from happening.
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Mike" <m_hightower(a)hotmail.com> wrote in message
> news:310e1d9c-f36e-410e-ae7f-66461faff4be(a)j78g2000hsd.googlegroups.com...
> On Jan 24, 6:39 pm, EMartinez <emartinez....(a)gmail.com> wrote:
> > On Jan 24, 5:23 pm, Mike <m_highto...(a)hotmail.com> wrote:
> >
> > > I guess it can be nice that the reports automatically run for you but
> > > sometimes it just causes issues with our reports, especially large
> > > reports. They can get stuck running the SQL so I can't move around
> > > between the tabs.
> >
> > > Normally I just want to see something on the History tab or security
> > > and not run the report every time I browse to it.
> >
> > > So is there any way to disable this ?
> >
> > > thanks
> >
> > If you have report parameter(s), set the Default Value(s) to Null.
> > Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant
>
> Ok, so it's really just the parameters having default values that is
> causing the reports to start up as you navigate to them? I'm
> positive most of them have a date default. So if I can't set that to
> Null then this will keep happening.
>
> thx
>
>
>
 |  Next  |  Last
Pages: 1 2
Prev: SSRS 2005 Unable to get Forms Authentication Sample running
Next: Turn-off autoscroll when drilldown