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

Question on Report Parameters in SQL Server Reporting Services

I have a question about the Report parameters box size. Is there a way to
adjust the size for the parameter box display. I need inc. the size.
I am using Microsoft Visual Studio to create the reports.
Thanks
--
Tarun PatelOn Oct 23, 2:55 pm, TarunMP <Taru...@.discussions.microsoft.com> wrote:
> I have a question about the Report parameters box size. Is there a way to
> adjust the size for the parameter box display. I need inc. the size.
> I am using Microsoft Visual Studio to create the reports.
> Thanks
> --
> Tarun Patel
Unfortunately, there is not. There might be a way in Reporting
Services 2008, which is rumored to have better CSS control. Sorry that
I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Question on passing multi-value parameter for multiple branches

Hello. We are using asp .net and reporting services, and trying to pass a multi-value parameter into reporting services that will show data for multiple branches.

Dim paramList As New Generic.List(Of Microsoft.Reporting.WebForms.ReportParameter)

paramList.Add(New Microsoft.Reporting.WebForms.ReportParameter("BranchNumber", 1))

ReportViewer1.ServerReport.SetParameters(paramList)

pInfo = ReportViewer1.ServerReport.GetParameters()

Let me know if you have any suggestions!

Thanks.

Did you try passing "1,2,3,4" instead of "1" ?

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||We tried that also, without any luck.|||

We have already figured out how to move between seperate branches, we just want a corporate option that will show all branches as a whole.

Any ideas?

Thanks

|||There is no way to post the "All" option, you will either have to pass all values to display or use an additional (hidden) parametert which uses the "All" option behind the scenes, something like:

Where SomeVar IN (@.TheValues) OR @.TheMagicParameter = 1 (Where TheMagicParameter is the magic hidden parameter)

Jens K. Suessmeyer.

http://www.sqlserver2005.de