cascading parameter

hi,

i need to have cascading parameter ,

there is 1 boolean parameter,if i click on true,the other parameter's drop- down should enable.If i choose false

it will be disable.

How to do that?

Enabling or disabling parameters based on the value selected in another parameter is not really possible, at least in the versions I work with.  What I would do instead is create a single parameter (your second parameter) with a value of "None" or something like that so the user can choose not to use any values from the parameter.  Your SQL gets a little tricky this way but it is possible, and it works.

ok.how to get none in the parameter,i am not getting it

hi daniel,

this is just simple question.

i need to put in my parameter like this, group name - value

so when i run report there should already be group name,not any drop dpwn ,just in text box.(user do not ned to select ,there should be already grouop name,just single line,now any drop - down box

i need to do in parameter.

anyt idea?

To get None as a selection option in your parameter use Union like this

SELECT 'None' AS columnName

UNION

SELECT the rest of your parameter data here

For your second question, I am not sure I understand.  If the user does not need to select a group, then why do you need it to be a parameter?  If you really need it to be a parameter, but you don't want the user to select it, you want the value hard coded or something, then make your parameter hidden or internal.