Home > Archive > MS SQL Server Reporting Services > June 2005 > How do you prevent report from executing automatically?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author How do you prevent report from executing automatically?
N.F.

2005-06-30, 3:23 am

Hi all, I have a report that has 4 parameters but all of them can accept
null values. Currently report defaults all of them to null and first time
accessing the page, it will run the report. The problem is it will try to
return the whole DB in that case. How do I prevent it from running unless I
put in some values in some of the fields?

Thank you for your answers.


Ailil

2005-06-30, 3:23 am

Hi!

Try please checking an "allow blank" instead of "allow null". If you don't
want to put there any defaults - i think it's the only way.

Regards, Ailil

"N.F." wrote:

> Hi all, I have a report that has 4 parameters but all of them can accept
> null values. Currently report defaults all of them to null and first time
> accessing the page, it will run the report. The problem is it will try to
> return the whole DB in that case. How do I prevent it from running unless I
> put in some values in some of the fields?
>
> Thank you for your answers.
>
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com