Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
randheer
Starting Member
15 Posts |
 Posted - 2010-08-12 : 11:17:09
|
| Hi,I have 3 parameters say A,B,C. I want that when I select values in A and B only then C comes alive. I am using cascading parameter in SSRS 2005.I know that in cascading parameters, one parameters passes a value to other one and it comes alive. But I want that 2 parameters pass the value to a single one.Please dont say to use multi select as multi select is used only when we have to multi select from one parameter.Also one thing how can I use radio buttons in SSRS 2005 and how to hide null checkbox when allowing null values in calender control.Please answer quickly and tell the whole procedure as my TL will throw me out as I am new to SSRS. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-12 : 12:29:23
|
| you can add both A and B as two arguments when you're selecting values for C then it will become alive only when A and B has a value------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
randheer
Starting Member
15 Posts |
Posted - 2010-08-13 : 04:59:15
|
Thanks I got it working as you said.  I am doing like there are 4 parameters A,B,C,D. When A,B are selected then C or D comes alive. It depends on value of A & B. D parameter is datetime. Now can you tell how to pass null in datetime parameter as default. I want if the user doesn't selects the date then it should be passed as null. I have made null in stored procedure but the SSRS requires to enter one. I have made Allow null value in D parameter but it comes with a checkbox on the report and my TL does not want that checkbox. I tried to make it a string parameter and pass default date but then the calender doesn't comes.  |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-14 : 02:46:32
|
| no standard way to do that I'm afraid. If you want it to have date popup then only way you can pass NULL value is by that checkbox. Alternatively if you're making it string type then calendar popup wont come. also making it string means you need to validate if value passed is valid date before you use it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
randheer
Starting Member
15 Posts |
Posted - 2010-08-14 : 23:44:59
|
| I did it by passing a default date in it always. Now the default date shows everytime and when if user wants to change then click the calender.Like I said that I have 4 parameter A,B,C,D. Can it be done like when I click C then D becomes disabled or when I click D then C becomes disabled.Thanks for the help. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-15 : 03:10:42
|
| have you set any dependency between C and D?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
randheer
Starting Member
15 Posts |
Posted - 2010-08-16 : 03:30:57
|
| No, there is no dependency between them. C is datetime filled and D is dropdown filled from database. I want when I click C then D is disabled and when D then C is disabled. Please tell me how to make C or D disable at the click of each other. |
|
|
|
|
|
|
|
|
SSRS 2005 question