Prev: SSRS 2005 Unable to get Forms Authentication Sample running
Next: Turn-off autoscroll when drilldown
From: Bruce L-C [MVP] on 22 Feb 2008 11:42
You need one parameter without a default. That is the only way, it can be a
visible or a hidden parameter. There is no other way.

You do not have to use the hidden parameter, it just has to be there.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Nicolas" <nicolasheurtevin at yahoo point fr> wrote in message
news:5DF74990-384F-410E-9F8F-8809EDD2871A(a)microsoft.com...
> 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
>>
>>
>>


First  |  Prev  | 
Pages: 1 2
Prev: SSRS 2005 Unable to get Forms Authentication Sample running
Next: Turn-off autoscroll when drilldown