Search code examples
asp.netsql-serverreporting-servicesssrs-2012ssrs-2014

Set SSRS Report Parameter value with passed Querystring value in SSRS

I have one report, in which I have 13 parameters that fetch the data from Database. I want to set only one Parameter value from Query-string URL.

For example in my case I want to set UserID value to passed Query-string value in SSRS report.

Is it possible to set only one parameter from Query-string and rest of the parameters will be bind with report's Dataset.

can anyone please suggest me the best solution to achieve. Thanks!

Solution

  • I was facing this issue because I have set two values in Available fields ="y" and ="n"

    And In default values ="y"

    This is why it was showing disabled. But after removing this " from each values it is working fine now.

    So we just need to use Y and N