Discussion:
Can you disable auto run of Report when you go to the view tab
(too old to reply)
Mike
2008-01-24 23:23:16 UTC
Permalink
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
EMartinez
2008-01-25 00:39:52 UTC
Permalink
Post by Mike
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
Mike
2008-01-25 19:19:39 UTC
Permalink
Post by EMartinez
Post by Mike
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
Bruce L-C [MVP]
2008-01-25 21:04:49 UTC
Permalink
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
Post by EMartinez
Post by Mike
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
Nicolas
2008-02-22 15:48:03 UTC
Permalink
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
Post by Bruce L-C [MVP]
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
Post by EMartinez
Post by Mike
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
Bruce L-C [MVP]
2008-02-22 16:42:45 UTC
Permalink
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
Post by Nicolas
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
Post by Bruce L-C [MVP]
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
Post by EMartinez
Post by Mike
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
Rupert
2008-03-25 11:59:33 UTC
Permalink
Post by Bruce L-C [MVP]
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
I have added a hidden parameter of type String, with a Null default
value, but now when the report is opened I get an error saying
'parameter is missing a value' - if I make the parameter visible it
works OK! How can I get around this?

This is using SQL 2005.

Thanks,
Rupert.
dedbeat
2008-06-11 18:11:00 UTC
Permalink
Bruce,

I've tried your solution. I'm not very clear on the settings for this hidden
parameter and I can't get it to work.

What you're saying is create a dummy parameter, set it as hidden and what
are the other settings for the parameter? If you set the default value as
null then you need to set the allow null values to be on. which comes to the
same problem we were at before.

Could you maybe elaborate a bit more?

Thanks.
Post by Bruce L-C [MVP]
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
Post by Nicolas
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
Post by Bruce L-C [MVP]
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
Post by EMartinez
Post by Mike
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
dedbeat
2008-06-12 14:35:02 UTC
Permalink
This post might be inappropriate. Click to display it.
unknown
2010-06-03 18:48:34 UTC
Permalink
This post might be inappropriate. Click to display it.
SSRSBeginner
2013-02-22 23:36:43 UTC
Permalink
Figured out how to do this... Yes, I know this post is really old...


Give a default value that is not possible, like a % or - or something like that. If your are expecting from a list of values..
Loading...