Question on View Report Click

Hi,
In my report, i get the data from stored procedure. Now the parameter that
i passed to the stored proc through the report has default values in that
already. When user clicks on the report name, it gets the data and
displays. I do not want the report to post and get the data automatically,
i want user to click the View Reprot Button in order to display report.
Since i have default values already filled out, some reason report executes
as soon as you click on the report name.
Any help
thanksThis behavior cannot be modified. If you supply a default value for all
parameters the report will execute automatically.
The easiest workaround is to not supply a default value for one parameter. A
request to change this behavior is already on the feature wishlist.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mayur Patel" <mayurworld@.yahoo.com> wrote in message
news:e2IsflVrEHA.2184@.TK2MSFTNGP10.phx.gbl...
> Hi,
> In my report, i get the data from stored procedure. Now the parameter
> that i passed to the stored proc through the report has default values in
> that already. When user clicks on the report name, it gets the data and
> displays. I do not want the report to post and get the data
> automatically, i want user to click the View Reprot Button in order to
> display report. Since i have default values already filled out, some
> reason report executes as soon as you click on the report name.
> Any help
> thanks
>
>|||I posted a similar question to this earlier today, and found this post.
This information does not appear to be correct. For example, I have a
report with the following parameters and settings:
Parameter Type Has Default Default Value Null Prompt User Prompt String
P1 String Y NONE N
P1:
P2 String Y Query Based Y
P2:
P3 String N Y
P3:
P4 String Y Y
P4:
P5 String Y N
P5:
P6 String Y N
P6:
These are the settings on report server, they aren't necessarily consistent
with the saved report (another annoyance :)), however, when I select Parm 3,
which is a dropdown list, and is the only parm that doesn't have a default,
the report DOES NOT automatically run. This is not consistent with the
behavior I've seen in other places, where when I select the company, the
report does run. So, something is preventing this report from running after
Parm 3 is selected. It won't run until I hit the 'View Report' button.
That's the behavior that I want and expect, the question is how to duplicate
that behavior. I don't want to change any of these settings at this point,
for fear I'll lose the desired behavior, because I don't know what's causing
it.
"Bruce Johnson [MSFT]" wrote:
> This behavior cannot be modified. If you supply a default value for all
> parameters the report will execute automatically.
> The easiest workaround is to not supply a default value for one parameter. A
> request to change this behavior is already on the feature wishlist.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Mayur Patel" <mayurworld@.yahoo.com> wrote in message
> news:e2IsflVrEHA.2184@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> > In my report, i get the data from stored procedure. Now the parameter
> > that i passed to the stored proc through the report has default values in
> > that already. When user clicks on the report name, it gets the data and
> > displays. I do not want the report to post and get the data
> > automatically, i want user to click the View Reprot Button in order to
> > display report. Since i have default values already filled out, some
> > reason report executes as soon as you click on the report name.
> > Any help
> >
> > thanks
> >
> >
> >
>
>