September 6, 2011 at 4:17 pm
Hello All,
Can someone advise me on the best way to modify an existing SSRS 2008 R2 report. The report is published. I am not the author of the report, I didn't publish it. I am using BIDS/Visual Studio 2008.
I was expecting to be able to retrieve the published report from BIDS modify it and then re-publish it.
In a multi-developer/publisher environment is is best policy to store the actual project files in a centralized location where all the developers can access the latest project, modify and then publish. I don't currently have source control in place.
Thanks if you can provide some guidance.
September 6, 2011 at 4:40 pm
Without source control, it would be best to have those projects centrally available. Make sure you back them up frequently. I would also implement a folder system with version numbers in case of a need to rollback.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 6, 2011 at 4:45 pm
Ok, thanks I'll set up a central location. The revision folder naming scheme souds good.
I'll set up this structure and create the projects. My remaining question is how would I populate these folders from already published reports.
September 6, 2011 at 4:54 pm
Since you don't have them already - start with this article. It will help you retrieve all of the reports quickly.
http://jasonbrimhall.info/2011/08/08/ssrs-export-en-masse/
Next, once you have the reports downloaded, you need to create a new project and then add those reports to that project. You should also create a share datasource to be used by the reports.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 6, 2011 at 4:56 pm
Awesome. Thank you. I will give it a try.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply