Can you disable auto run of Report when you go to the view tab

[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

[EMartinez]

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

Regards,

Enrique Martinez
Sr. Software Consultant

[Mike]

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]]

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_hig...@hotmail.com> wrote in message
news:310e1d9c-f36e-410e...@j78g2000hsd.googlegroups.com...

[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

[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

"Nicolas" <nicolasheurtevin at yahoo point fr> wrote in message
news:5DF74990-384F-410E...@microsoft.com...

[Rupert]

On Feb 22, 4:42 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@hotmail.com>
wrote:

> 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]

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.

[dedbeat]

looks like these so called MVP's really have no clue about the software they
design....

tsk tsk. anyone out there have a solution to stopping reports automatically?

I finally had to resort to setting a visible dummy parameter which says run
report?
and it has a drop down to select run report.

how redundant...this is just gonna piss the users off..
there has to be a way to make something behind the scenes...

[gregkawinski]

On the report server, go into the report properties - parameters. Uncheck the 'has default value' checkbox for a parameter. This prevents the autorun.

If you redeploy the report, you do NOT need to redo this.

Personally, I'm blown away by how crappy SSRS is. How many decades will it take Microsoft to catch up to Crystal? The answer is undefined because they never will.

dedbea wrote:

looks like these so called MVP's really have no clue about the software they

12-Jun-08

looks like these so called MVP's really have no clue about the software they
design....

tsk tsk. anyone out there have a solution to stopping reports automatically?

I finally had to resort to setting a visible dummy parameter which says run
report?
and it has a drop down to select run report.

how redundant...this is just gonna piss the users off..
there has to be a way to make something behind the scenes...

"dedbeat" wrote:

Previous Posts In This Thread:

On Friday, January 25, 2008 4:04 PM
Bruce L-C [MVP] wrote:

You can also have a hidden parameter with no value (you don't have to use it
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_hig...@hotmail.com> wrote in message
news:310e1d9c-f36e-410e...@j78g2000hsd.googlegroups.com...
On Jan 24, 6:39 pm, EMartinez <emartinez....@gmail.com> wrote:

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

On Tuesday, February 05, 2008 12:35 AM
Mike wrote:

Can you disable auto run of Report when you go to the view tab

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

On Tuesday, February 05, 2008 12:35 AM
EMartinez wrote:

Re: Can you disable auto run of Report when you go to the view tab

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

Regards,

Enrique Martinez
Sr. Software Consultant

On Tuesday, February 05, 2008 12:35 AM
Mike wrote:

Re: Can you disable auto run of Report when you go to the view tab

On Jan 24, 6:39=A0pm, EMartinez <emartinez....@gmail.com> wrote:

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

On Friday, February 22, 2008 10:48 AM

nicolasheurtevin at yahoo point fr wrote:

Hi, I'm a french developer and i have a question about reports in Reporting
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:

On Friday, February 22, 2008 11:42 AM
Bruce L-C [MVP] wrote:

You need one parameter without a default.
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...@microsoft.com...

On Friday, March 28, 2008 12:51 AM
Rupert wrote:

Re: Can you disable auto run of Report when you go to the view tab
On Feb 22, 4:42=A0pm, "Bruce L-C [MVP]" <bruce_lcNOS...@hotmail.com>
wrote:
a

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.

On Wednesday, June 11, 2008 2:11 PM
dedbea wrote:

Bruce,I've tried your solution.
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.

"Bruce L-C [MVP]" wrote:

On Thursday, June 12, 2008 10:35 AM
dedbea wrote:

looks like these so called MVP's really have no clue about the software they
looks like these so called MVP's really have no clue about the software they
design....

tsk tsk. anyone out there have a solution to stopping reports automatically?

I finally had to resort to setting a visible dummy parameter which says run
report?
and it has a drop down to select run report.

how redundant...this is just gonna piss the users off..
there has to be a way to make something behind the scenes...

"dedbeat" wrote:

Submitted via EggHeadCafe - Software Developer Portal of Choice
Producer/Consumer Queue and BlockingCollection in C# 4.0
http://www.eggheadcafe.com/tutorials/aspnet/7d10d73c-321c-446e-8b6d-b81ee8d9b314/producerconsumer-queue-a.aspx

[SSRSBeginner]

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..