Post reply

Passing two different parameters in one cascading parameter in SSRS 2005

  • August 12, 2010 at 9:10 am

    #225821

    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.

  • August 12, 2010 at 10:34 am

    #1206189

    So you want the selected values of parameter C to be constrained by the A & B parameter? Can't you just add them both to the where clause in the query that builds the available values for C?

  • August 13, 2010 at 1:21 am

    #1206437

    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.

    Tell me. :crying:

  • August 13, 2010 at 9:21 am

    #1206726

    Sorry, I don't have an easy answer for that one.

  • August 14, 2010 at 9:48 pm

    #1207070

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

  • August 17, 2010 at 9:18 am

    #1207957

    hi,

    Reports datetime parameter doesnt allow without a values or with NULL selection.

    you can use it with string without a calendar or give date, month and year in separate combo's.

    this may be silly but still i cant find other solution.

    Regards
    Durai Nagarajan

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply