Report manager - How can I edit a query based parameter in report manager

Question

Greetings,

I have a report which has a multi-valued parameter where the default values are being assigned by a query.

There are some values that we wish to remove from the default list when we deploy the report so some sites. 

How can I select a subset of the values the parameter default query returns,  within Report Manager when deploying the reports?

What I am looking is a listing of possible values of a query based parameter,  populated into a dropdown list next to the “use this value” radio button when managing the reports parameters.

Is this possible in standard edition SQL 2008 R2 ?

All help would be graetly appreciated.

Cheers Noel

Answer 1

Hi There

You can define as hidden parameter and  based on hidden parameter you can select different default values for different sites for example for development you could have different set of values for default values and for production you could have different values

I hope this will help

Many thanks

Syed Qazafi Anjum

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Answer 2

Greetings,

Thanks for your suggestion. The objective was that on deployment at a customer site, the person deploying the reports (actually a dashboard of several reports) needed to be able to configure the default parameters entirely from Report Manager. Setting the values of the hidden parameter from report manager looked like it would have the same issues as setting the defaults on the actual parameter from Report Manager.

In the end I have left the query derived available values, but removed the setting of the query derived default values in BIDS, then set the default values in Report Manager. The disadvantage of this is that when setting the default values in Report Manager, the set of values need to be entered manually, rather than selected from the available values, but it does mean that it is all configurable from Report Manager.

Cheers Noel

Answer 3

Hi There

What I m trying to say to you

You could have a query based parameter for your all your sites where you are deploying your dashboard

And you have another table in which you have a combination of your sites and default parameters for those sites for example

You have table

Site id                    site name

1                     development

2                     testing

3                     deployment

and you have another table with default values based on your different sites

for example

site id                    default parameter id

1                                             5

1                                            6

2                                            1

3                                            3

Something like that

and you can keep grow this table based on your new clients. It is one time off you deploy this solution and next time all your parameter which are depending on your hidden parameter will get the values based on that

I hope this will help

Many thanks

Syed Qazafi Anjum

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Answer 4

Thanks for your help.