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
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.
To get None as a selection option in your parameter use Union like this
SELECT 'None' AS columnName
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.