SQL Server reports how to see edits in rendered report

Question

I have a report running on SQL server 2008 R2. I used report builder 3.0 to make changes to the sub reports. When I render the report via the URL, it still shows the old report before the changes.

I was able to load the outermost report in Report Builder and run it seeing the report with all the updates. Maybe it's just a problem with the url and I'm pointing to a file other than the one I updated.

How would I know this?

thinking out loud, maybe when I open the files for edit, Report builder saves a copy locally and has me edit that? do I need to publish the changed sub reports to the server?

Answer 1

Hi @RCDA Webmaster
Yes，you need publish the changed sub reports to the server，when you open the report on URL，it points to the report you published on the server ，so when you change the report on your local，the report does not change synchronously in the URL.

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

The issue was that we have 2 servers both serving the same report. I modified one and my web application points to the other. The annoying thing was that moving the files was not simple. I could not find the directory on the server with the files so I could copy and paste them to the other server. Since I could only access the files via http, I had to open each one in report builder and save it to the other server.

Can someone let me know how to find the reports on the server using the windows explorer?

Answer 3

Hi @RCDA Webmaster
You can use rs.exe to transfer reports from server A to server B. I refer to this this thread：https://dba.stackexchange.com/questions/195007/moving-ssrs-reports-from-one-server-to-other

 rs.exe -i ssrs_migration.rss -e Mgmt2010 -s http://SourceServer/ReportServer -u Domain\User -p password -v ts="http://TargetServer/reportserver" -v tu="Domain\Userser" -v tp="password"  
      

Related links：
https://learn.microsoft.com/en-us/sql/reporting-services/tools/sample-reporting-services-rs-exe-script-to-copy-content-between-report-servers?view=sql-server-ver15
https://learn.microsoft.com/en-us/sql/reporting-services/tools/sample-reporting-services-rs-exe-script-to-copy-content-between-report-servers?view=sql-server-ver15&redirectedfrom=MSDN&viewFallbackFrom=sql-server-2014
Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.