ReportServer Forum

jmag

Member

Registered: 2024-10-15

Dynamic Datasource and url parameter

i have a report that I want to point to diffferent datasources (environments).
Let's say
  i have datasource-dev which points to my database-dev
  I have datasource-prod which points to my database-prod

How can i do url parameter for datasource so I have

http://server/reportserver/reportserver/httpauthexport?id=160593&  "DataSource" = "datasource-dev"

http://server/reportserver/reportserver/httpauthexport?id=160593&  "DataSource" = "datasource-prod"

Thanks
Peter

Felix

Moderator

Registered: 2022-08-01

Re: Dynamic Datasource and url parameter

Hi jmag,

there is currently no url parameter to control the datasource of a report directly.

This desired behaviour can be implemented using a groovy script.

kind regards

Felix

---

Softwareentwickler bei Infofabrik

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Dynamic Datasource and url parameter

Hi jmag,

also, pls take a look at database bundles: https://reportserver.net/de/dokumentati … -guide-4-7
4.27 Datasource Bundle

This might be interesting for your use case.

Regards,
Eduardo