# Mass SSRS Data Source Change?

**URL:** <https://www.epiusers.help/t/mass-ssrs-data-source-change/70207>\
**Category:** Epicor ERP 10\
**Tags:** sql, e10, reports, ssrs\
**Created:** [August 22, 2020, 3:19pm UTC](https://www.epiusers.help/t/mass-ssrs-data-source-change/70207 "2020-08-22T15:19:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Will79](https://www.epiusers.help/letter_avatar_proxy/v4/letter/w/ea666f/32.png) [@Will79](https://www.epiusers.help/u/Will79)\
**Post date:** [August 22, 2020, 3:19pm UTC](https://www.epiusers.help/t/mass-ssrs-data-source-change/70207/1 "2020-08-22T15:19:43Z")

</div>

With SSRS, there is the CustomReports folder. Obviously, we keep our Custom Reports in here. I have had to move things around and the Shared Data source is no longer the same. However, we have a LOT of reports in this folder.

Is there a way to change the Shared Data Source path for all reports at one time in this folder?

We are running Sql Server 2012.

---

<div class="post-metadata">

**Author:** ![Aaron\_Moreng](https://www.epiusers.help/user_avatar/www.epiusers.help/aaron_moreng/32/745_2.png) [@Aaron\_Moreng](https://www.epiusers.help/u/Aaron_Moreng)\
**Post date:** [August 22, 2020, 3:26pm UTC](https://www.epiusers.help/t/mass-ssrs-data-source-change/70207/2 "2020-08-22T15:26:00Z")

</div>

Move them with solution workbench, that should take care of it

---

<div class="post-metadata">

**Author:** ![Will79](https://www.epiusers.help/letter_avatar_proxy/v4/letter/w/ea666f/32.png) [@Will79](https://www.epiusers.help/u/Will79)\
**Post date:** [August 22, 2020, 11:26pm UTC](https://www.epiusers.help/t/mass-ssrs-data-source-change/70207/3 "2020-08-22T23:26:52Z")

</div>

Well, it worked for most, but not all. I selected all reports, so not sure why. BUT, it did get the vast majority. I’m thinking I will just wait and see who screams first! LOL!

---

<div class="post-metadata">

**Author:** ![chaddb](https://www.epiusers.help/user_avatar/www.epiusers.help/chaddb/32/89855_2.png) [@chaddb](https://www.epiusers.help/u/chaddb)\
**Post date:** [August 24, 2020, 1:26pm UTC](https://www.epiusers.help/t/mass-ssrs-data-source-change/70207/4 "2020-08-24T13:26:33Z")

</div>

I’ve had some mixed results with the solution workbench. Overall, great tool and works 99% of the time. Sometimes it misses things or things don’t move just right. Not 100% sure why.