CODEWITHSUNDEEP
asp.netsql-serverreporting-servicesssrs-2012ssrs-2014
Pedram
Pedram

Reputation: 6508

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!

Upvotes: 2

Views: 1317

Answers (3)

Pedram
Pedram

Reputation: 6508

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

Upvotes: 0

vcraigc
vcraigc

Reputation: 91

This is possible as long as you have default values for the other 12 parameters.

Upvotes: 0

Dhana
Dhana

Reputation: 11

It is possible to have some query parameters and some dataset parameters...but its always good idea to create in backend itself. The reason is your fetching all data from backend and filtering out in frontend..if data is more every time report need to pull all data from backend.

Upvotes: 0

Related Questions