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

Hi, where do I ask SSIS related questions

Hi, Can you please direct me to the correct news group.
In case this is the correct place......
Problem:
I need to extract all employees with state='CA' from a sqlServer 2005.
Solution so far:
What we have done is created a
1) "DataReaderSource" to the DB
2) Then a "conditional split" filters the state="CA"
My questions is...
is it that I first get all the data from the DB and then discard all that is
not "CA".
is this the correct method, or is there a way to extract on the state='CA'
from the DB?
Any help is deeply appreciated.
NalakaAFAIK there is no SSIS group created yet, try the DTS one instead
microsoft.public.sqlserver.dts
http://sqlservercode.blogspot.com/|||Try:
microsoft.public.sqlserver.integrationsvcs
-Sue
On Wed, 22 Feb 2006 09:22:44 -0800, "Nalaka"
<nalaka12@.nospam.nospam> wrote:

>Hi, Can you please direct me to the correct news group.
>In case this is the correct place......
>Problem:
>I need to extract all employees with state='CA' from a sqlServer 2005.
>Solution so far:
>What we have done is created a
> 1) "DataReaderSource" to the DB
> 2) Then a "conditional split" filters the state="CA"
>
>My questions is...
>is it that I first get all the data from the DB and then discard all that i
s
>not "CA".
>is this the correct method, or is there a way to extract on the state='CA'
>from the DB?
>
>Any help is deeply appreciated.
>Nalaka
>

Hi, where do I ask SSIS related questions

Hi, Can you please direct me to the correct news group.
In case this is the correct place......
Problem:
I need to extract all employees with state='CA' from a sqlServer 2005.
Solution so far:
What we have done is created a
1) "DataReaderSource" to the DB
2) Then a "conditional split" filters the state="CA"
My questions is...
is it that I first get all the data from the DB and then discard all that is
not "CA".
is this the correct method, or is there a way to extract on the state='CA'
from the DB?
Any help is deeply appreciated.
NalakaAFAIK there is no SSIS group created yet, try the DTS one instead
microsoft.public.sqlserver.dts
http://sqlservercode.blogspot.com/|||Try:
microsoft.public.sqlserver.integrationsvcs
-Sue
On Wed, 22 Feb 2006 09:22:44 -0800, "Nalaka"
<nalaka12@.nospam.nospam> wrote:
>Hi, Can you please direct me to the correct news group.
>In case this is the correct place......
>Problem:
>I need to extract all employees with state='CA' from a sqlServer 2005.
>Solution so far:
>What we have done is created a
> 1) "DataReaderSource" to the DB
> 2) Then a "conditional split" filters the state="CA"
>
>My questions is...
>is it that I first get all the data from the DB and then discard all that is
>not "CA".
>is this the correct method, or is there a way to extract on the state='CA'
>from the DB?
>
>Any help is deeply appreciated.
>Nalaka
>sql

Hi, where do I ask SSIS related questions

Hi, Can you please direct me to the correct news group.
In case this is the correct place......
Problem:
I need to extract all employees with state='CA' from a sqlServer 2005.
Solution so far:
What we have done is created a
1) "DataReaderSource" to the DB
2) Then a "conditional split" filters the state="CA"
My questions is...
is it that I first get all the data from the DB and then discard all that is
not "CA".
is this the correct method, or is there a way to extract on the state='CA'
from the DB?
Any help is deeply appreciated.
Nalaka
AFAIK there is no SSIS group created yet, try the DTS one instead
microsoft.public.sqlserver.dts
http://sqlservercode.blogspot.com/
|||Try:
microsoft.public.sqlserver.integrationsvcs
-Sue
On Wed, 22 Feb 2006 09:22:44 -0800, "Nalaka"
<nalaka12@.nospam.nospam> wrote:

>Hi, Can you please direct me to the correct news group.
>In case this is the correct place......
>Problem:
>I need to extract all employees with state='CA' from a sqlServer 2005.
>Solution so far:
>What we have done is created a
> 1) "DataReaderSource" to the DB
> 2) Then a "conditional split" filters the state="CA"
>
>My questions is...
>is it that I first get all the data from the DB and then discard all that is
>not "CA".
>is this the correct method, or is there a way to extract on the state='CA'
>from the DB?
>
>Any help is deeply appreciated.
>Nalaka
>