Post reply

setting default value of a parameter depending on the value of a hidden parameter

  • December 5, 2010 at 9:23 pm

    #229847

    I am facing an issue with setting default value of a parameter in SSRS 2008.

    In my report i have a parameter 1 which has list of department codes and parameter 2 which is a hidden parameter and has id of the user. I have hardcoded the default value for parameter 2.

    I have two datasets for parameter 1, one populates the available departments and the other dataset for fetching the default value.

    The dataset that is fetching the default value uses parameter 2 in a sql query to fetch the value. i.e. SELECT PU from tbl_Access where Email_Id = @Parameter 2

    The issue is that i am not able to get any default value for parameter 1 on my report.

    Thanks.

  • December 5, 2010 at 10:53 pm

    #1258886

    Hi,

    Can you make sure that the Default value that you are expecting is one among those in the available values?

    i,e for example if the available value list is A,B,C,D,E then you can set the default value(by another dataset or specify value ) either A or B or C of D or E , but if you are trying yo show some value other than this then it wont appear.

    The reason is when you say default value the you are showing one value out of the available list of values as default.

    Thanks & Regards,
    MC

  • December 5, 2010 at 10:56 pm

    #1258887

    Hi

    Thanks for your response.

    Yes the default value is there in the available values. Available values is the master set of all the values.

    But the available values and the default value are being fetched from different tables. and there is no link between the two tables.

    thanks.

  • December 5, 2010 at 11:04 pm

    #1258889

    Ok , then can you try one thing, in the table form where you are getting the default value, make sure that that column value is same for all the columns .(ie all the row should have your Default value , if it not just add a column to that table and update with the default value and test it)

    Thanks & Regards,
    MC

Viewing 4 posts - 1 through 3 (of 3 total)

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