D365 SSRS Report dynamic data source Url for multiple environments

(0) Share

Report

Posted on by Community Member

Hello,

Environment: D365, CRM online, SSRS - reporting services, Visual Studio 2015, BIDS

Problem: I have created a fetchXml report that I currently have an embedded data source pointing to my DEV environment. How can I change the data source on the report to make it dynamically point to the correct environment that the report is be run from? Eg. Test, QA, Production

Thanks~

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Nausher Sayeed 522 on at

Like (0)

Report

Hi Laura,

Did you get workaround to change the connectionstring when we want to deploy to UAT or production server.

Thanks

Was this reply helpful? Yes No
Suggested answer

Thomas David Dayman 11,323 on at

Like (0)

Report

Either you just hard code the url in the report to point at production. Or you could try writing a function in the connection string to dynamically pick up the CRM server. I personally haven't tried dynamically changing the server but you could give it a shot.

stackoverflow.com/.../ssrs-report-dynamic-connection-string-and-parameters

dynamicspeople.wordpress.com/.../ssrs-report-in-dynamics-crm

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

HI Laura,

I dont think you need to change the dataconnection to your target using an embedded datasource.

just depoly your report in the crm .

Best Regards,

David

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Add the report to the solution that is pointing to your dev environment.

Deploy that report as part of your solution to test or production.

The connection string should redirect to the new SSRS server.

Try it out.

Was this reply helpful? Yes No