ReportServer Forum

rajup

Member

Registered: 2016-08-17

DataSource Bundle

Hi,
can you please explore how to use "key Provider:Parameter" in dataSource bundle.

Thanks

Thomas Davies

datenwerke

Registered: 2016-05-18

Re: DataSource Bundle

Hi Rajup,

the Parameter key provider allows the user to select the database to use via a parameter. Consider that you have the following setup for the Datasource Bundle:

Key Provider: Paramater
Parameter Key: DS

Mapping Provider: Static

A: Datasource 1
B: Datasource 2
C: Datasource 3

In order to use this bundle at a report you would need to define a parameter with key DS. Then, the value of the parameter is used to choose the datasource. So, if the parameter value is B then the report is run on Datasource 2.

Hope this helps,
Thomas

rajup

Member

Registered: 2016-08-17

Re: DataSource Bundle

hi Thomas,
can you please tell me what is the type of parameter DS. is it Text parameter or DataSource parameter or else.

Thanks

Thomas Davies

datenwerke

Registered: 2016-05-18

Re: DataSource Bundle

Hi Rajup,

this can be any parameter that can return a string. That is, it could be a Text parameter, a DataSource Parameter (this is probably the most common case as this allows you to have a drop down box), or even a user variable or script parameter.

Regards,
Thomas