# Moving Reports **URL:** \ **Category:** Epicor ERP 10\ **Tags:** reports\ **Created:** [April 13, 2019, 5:55pm UTC](https://www.epiusers.help/t/moving-reports/54603 "2019-04-13T17:55:50Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![sweeti61](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/54ee81/32.png) [@sweeti61](https://www.epiusers.help/u/sweeti61)\ **Post date:** [April 13, 2019, 5:55pm UTC](https://www.epiusers.help/t/moving-reports/54603/1 "2019-04-13T17:55:50Z")
I am moving my reports to my live database today. In updating my datasource - do I have create a new datasource for the live database? ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [April 13, 2019, 6:21pm UTC](https://www.epiusers.help/t/moving-reports/54603/2 "2019-04-13T18:21:16Z")
I would recommend that all your instances have their own Report Folder and Database SSRS Databases: - E10\_Production\_Reports - E10\_Test\_Reports - E10\_Pilot\_Reports Basically in your Admin Console this is how Pilotwould for example look like: ![2019-04-13_1420](https://epiusers.help/uploads/default/original/3X/5/c/5c69468a4c5c91eee798766a99d2267a27021f3d.png) Then if you were to navigate to the SSRS Website it would look like: ![2019-04-13_1421](https://epiusers.help/uploads/default/original/3X/4/e/4ebb7efbd10b7ba007e0d481f12f2c9c937bacb7.png) ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [April 13, 2019, 6:22pm UTC](https://www.epiusers.help/t/moving-reports/54603/3 "2019-04-13T18:22:36Z")
You can just use “Solution Workbench” and add your Reports, once you build the .cab it will ask you if you want to include the .rdl file for each Report you are exporting, say yes… Then go to your Production and import the cab and viola. It should upload the .rdl files to the CustomReports folder ---
**Author:** ![jgehling](https://www.epiusers.help/user_avatar/www.epiusers.help/jgehling/32/78990_2.png) [@jgehling](https://www.epiusers.help/u/jgehling)\ **Post date:** [April 13, 2019, 6:23pm UTC](https://www.epiusers.help/t/moving-reports/54603/4 "2019-04-13T18:23:29Z")
And in the future if you ever need to migrate custom SSRS reports, theres some powershell scripts out there to help you out 🙂 [https://www.sqlshack.com/migrating-ssrs-content-powershell/](https://www.sqlshack.com/migrating-ssrs-content-powershell/) ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [April 13, 2019, 6:24pm UTC](https://www.epiusers.help/t/moving-reports/54603/5 "2019-04-13T18:24:22Z")
We use something like a PowerShell when we sync our “Training” Environment to match Production. ---
**Author:** ![sweeti61](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/54ee81/32.png) [@sweeti61](https://www.epiusers.help/u/sweeti61)\ **Post date:** [April 13, 2019, 6:28pm UTC](https://www.epiusers.help/t/moving-reports/54603/6 "2019-04-13T18:28:12Z")
Yes, they already do. ---
**Author:** ![sweeti61](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/54ee81/32.png) [@sweeti61](https://www.epiusers.help/u/sweeti61)\ **Post date:** [April 13, 2019, 6:32pm UTC](https://www.epiusers.help/t/moving-reports/54603/7 "2019-04-13T18:32:08Z")
Ok, so I had all custom reports in the test custom report folder. As I was moving the reports I never updated the paths in test. Would this have to be completed in test first before using the solution workbench? ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [April 13, 2019, 6:37pm UTC](https://www.epiusers.help/t/moving-reports/54603/8 "2019-04-13T18:37:22Z")
Depending what your path is… it should’nt be any different – The Instance itself prepends the Root Path before the Path, when you run the Report. It should be the same path in both instances… /reports/CustomReports/MyReport/… you don’t add the prefix in the path (Ex: Test/Pilot…) it will read the Prefix from your configuration, so you don’t add that to the Report Style ![2019-04-13_1439](https://epiusers.help/uploads/default/original/3X/5/4/540d1012b6b262fba0a1bd97dc1bfbd6761ea0c9.png) ---
**Author:** ![sweeti61](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/54ee81/32.png) [@sweeti61](https://www.epiusers.help/u/sweeti61)\ **Post date:** [April 13, 2019, 6:50pm UTC](https://www.epiusers.help/t/moving-reports/54603/9 "2019-04-13T18:50:59Z")
I appreciate your assistance with this, thank you. In my reporting server for test my custom reports I had to create a datasource for my custom reports. Currently they are pointed at /EpicorERPTest/reports/SharedDatasource. When I moved them to live - they still have this path. I need to update the path to EpicorERP. ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [April 13, 2019, 6:52pm UTC](https://www.epiusers.help/t/moving-reports/54603/10 "2019-04-13T18:52:14Z")
If you created a custom data source. I usually don’t create custom ones, since I use the RDD (Report Data Definition) to build my data source. For me I always just copy Epicor’s Report Style, make my changes and never have to deal with anything. ---
**Author:** ![sweeti61](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/54ee81/32.png) [@sweeti61](https://www.epiusers.help/u/sweeti61)\ **Post date:** [April 13, 2019, 6:56pm UTC](https://www.epiusers.help/t/moving-reports/54603/11 "2019-04-13T18:56:51Z")
Yes, when I first posted out here about creating custom reports - I was told I had to create the datasource, which I did and works great in test. It just points to epicortest/reports/shareddatasource. And yes, I download the original reports, then modified and uploaded the reports. So, mostly, I just need to figure out how to get these modified Epicor Custom Reports to my live database. ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [April 13, 2019, 7:00pm UTC](https://www.epiusers.help/t/moving-reports/54603/12 "2019-04-13T19:00:26Z")
I wonder if that was in 10.0 - perhaps I am doing it wrong in a Multi-Tenant OS… Let me try to export one and import from Test o Pilot see what my outcome is. ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [April 13, 2019, 7:09pm UTC](https://www.epiusers.help/t/moving-reports/54603/13 "2019-04-13T19:09:49Z")
1. Cloned BOLForm in E10\_Test 2. Created .cab via Solution Workbench of “Report Style” 3. Upon building the CAB I was prompted to include RDL, said Yes. 4. Imported into E10\_Pilot via Solution Workbench PS: Remember in 10.2.x your user doing the import must have SSRS Rights enabled via User Account Maintenance: (Once you enable it you must restart epicor client) ![2019-04-13_1513](https://epiusers.help/uploads/default/original/3X/6/4/6476b9aa90307aa2a1906ad39121423a23d16b8e.png) And my dataset automatically changed: ![2019-04-13_1508](https://epiusers.help/uploads/default/original/3X/9/f/9fd2d965ff61bfb080e71f90504da73aeac2ce04.png) I guess **Solution Workbench will take care of it for you** and or the SSRS Import Function under Actions in Report Style Maintenance. * * * If you don’t use Solution Workbench and you manually download the .rdl via Chrome or Explorer and Upload it, then you have to change it yourself by opening the file once uploaded via Report Builder. ![2019-04-13_1517](https://epiusers.help/uploads/default/original/3X/e/a/ea806d0dd373118604f61f5311f5f04d8d345343.png) ![2019-04-13_1518](https://epiusers.help/uploads/default/original/3X/b/d/bdda1b8ac7cf880da64499930d29e0a5804acc8f.png) OR You can just open the .rdl file via Notepad and change it… its just an XML - then upload it. ---
**Author:** ![sweeti61](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/54ee81/32.png) [@sweeti61](https://www.epiusers.help/u/sweeti61)\ **Post date:** [April 13, 2019, 7:34pm UTC](https://www.epiusers.help/t/moving-reports/54603/14 "2019-04-13T19:34:37Z")
Thanks for all the inputs, but I found and used the ReportSync Tool - this works GREAT! ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [April 13, 2019, 7:39pm UTC](https://www.epiusers.help/t/moving-reports/54603/15 "2019-04-13T19:39:31Z")
It will Sync your .RDL File but in my case I always have custom RDD’s, I also need Report Styles to be imported like StyleNum 1002, 1003… For that its best to use Solution Workbench… Unless you just literally need to sync the .rdl files - then rs is good too. Hope all goes well! ---
**Author:** ![sweeti61](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/54ee81/32.png) [@sweeti61](https://www.epiusers.help/u/sweeti61)\ **Post date:** [April 13, 2019, 7:52pm UTC](https://www.epiusers.help/t/moving-reports/54603/16 "2019-04-13T19:52:29Z")
Thank you for all your input! You may be correct on my styles. On to that part! Thanks again! ---
**Author:** ![sweeti61](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/54ee81/32.png) [@sweeti61](https://www.epiusers.help/u/sweeti61)\ **Post date:** [April 13, 2019, 9:21pm UTC](https://www.epiusers.help/t/moving-reports/54603/17 "2019-04-13T21:21:30Z")
Okay - I have a question… in test I created reports that had been changed from portrait to landscape - and now they seem to be back to the standard reports??? My names are there but it seems to have lost customizations?