hide parameter field

Is it possible to hide or disable some fileds of parameters on report?
Thanks.You could always call the report from a URL and NOT show the parameter
bar... and in SP1 you may hide individual parameters.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<AG>; "NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
news:E55FF6A7-3BDD-411B-87FB-AE4EF548E053@.microsoft.com...
> Is it possible to hide or disable some fileds of parameters on report?
> Thanks.
>|||Hi AG:
Make sure you have SP1 for reporting services:
http://www.microsoft.com/downloads/details.aspx?familyid=580febf7-2972-40e7-bccf-6cd90ac2f464&displaylang=en
From the SP1 readme:
"Previously, the only way to hide a parameter value was to clear the
Prompt User check box in the Parameters properties page. However, a
side effect of clearing the check box was that you could no longer
specify a parameter value for the report at run time. This limitation
has been removed. In SP1, you can clear the Prompt User check box to
hide the parameter fields and values in the report. Doing so does not
introduce restrictions on how you subsequently set the parameter value
externally at run time."
HTH,
--
Scott
http://www.OdeToCode.com
On Mon, 2 Aug 2004 02:15:03 -0700, AG, NLB d.d.
<AGNLBdd@.discussions.microsoft.com> wrote:
>Is it possible to hide or disable some fileds of parameters on report?
>Thanks.
>

Hide / Disable Report Parameter

Hi

I am using reporting services 2005. (sql server 2005 Sp2).

I have two parameters on the reports. Both parameter are not related to each other.

If user selects first parameter value I want to Hide or Disable second parameter drop down.

Is it possible in Reporting services?

Thanks for everyone's help.

Regards

Swam

I am guessing a big NO

You could simply not use the 2nd parameter in the report

and have a text with "2nd parameter will not be used if 1st parameter is used"

|||

Swam wrote:

If user selects first parameter value I want to Hide or Disable second parameter drop down.

You can't do that, but what you can do is make the default value and even the *contents* of the second parameter dependant on what is selected in the first parameter. I would have the second dropdown default to null or an empty string if a value was selected in the first dropdown.

|||Thanks for your help..|||Thanks for your help....