How to change connection type of SSRS report Data source dynamically <p>I have an application that binds the RDL file on report server to Report viewer control to produce reports. We use embedded data source in the RDL file. We have used expression based connection string for our embedded data source So that we will be able to change the data source dynamically.</p> <p>We wanted to access the report using both windows integrated security and SQL server authentication. Now if our data source is configured to use windows integrated security and we wanted to access the report using SQL authentication, then we are modifying the RDL file using web methods before producing the report.</p> <p>Is there any other way to do this?</p>