Forum Discussion
Not possible to edit data source in .rdl file?
I don't think you need to recreate the entire report. You should be able to create a new Data Source in the .rdl file, then edit the Datasets to point to that new source.
But be careful how you authenticate that Data Source. You may need to set it up with saved credentials that get used regardless of who is running the report. If you want the end user's credentials to get passed through to the Data Source, that is going to be a bit harder.
I don't think you need to recreate the entire report. You should be able to create a new Data Source in the .rdl file, then edit the Datasets to point to that new source.
But be careful how you authenticate that Data Source. You may need to set it up with saved credentials that get used regardless of who is running the report. If you want the end user's credentials to get passed through to the Data Source, that is going to be a bit harder.
Worked thanks 😄 a lot of manual work but finally user is happy as it was important report
Cheers