August 17, 2017 at 8:42 am
Hi,
I am new with SSDT (Visual Studio), Report Builder and SSRS.
I have installed both SSDT and Report Builder tools.
To create shared datasources or datasets, I use SSDT, and then deploy the objects (shared datasources, datasets or reports) to the ReportServer.
To modify reports I am using Report Builder. Once I open this tool, I am connected on the server and can open reports.
I have updated my report with Report Builder, and this one has been saved on the ReportServer.
Now I would like to add a shared dataset in this report. Then I open the report with SSDT (Visual Studi) and the version of the rdl file is not the last one (all the updates made with Report Builder are missing). It is a version stored locally, not the one on the ReportServer.
How can I proceed to make sure that each time I use SSDT, the latest version of my reports is used ?
That is to say : how to synchronize SSDT environnement with ReportServer ?
Thanks a lot for your help.
August 21, 2017 at 2:31 pm
Not sure if you're mixing up terms or just aren't stating all the pieces. When making changes in Visual Studio, are you building/publishing the report to the Report Server? If you don't build & publish, the changes made will not be "saved" to the .rdl being rendered by the Report Server.
I'm not familiar with Report Builder, so I can't give any advice there.
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
August 30, 2017 at 1:13 am
Hi,
thank you for your answer.
Yes I do build / publish the report with Visual Studio.
But this tool is a geek one, so I prefer Report Builder to modify reports, and then I do with Report Builder the same build / publish process. Therefore, the report in the server is up to date.
But if I come back to use Visual Studio, how can I proceed to open the report that has been published to the server (with report builder). It seems that with VS it is using a local version of the report and not the server one.
August 30, 2017 at 1:48 pm
To be sure you've got the most recent version, the best way would be to use some sort of version control (we use Vault). Barring that, you can download the report server version from SSRS and open it in Visual Studio.
August 30, 2017 at 7:14 pm
franck.robert - Wednesday, August 30, 2017 1:13 AMBut if I come back to use Visual Studio, how can I proceed to open the report that has been published to the server (with report builder). It seems that with VS it is using a local version of the report and not the server one.
Only way i know of to do this is to manually download the report and replace the version inside VS.
August 30, 2017 at 11:52 pm
matak - Wednesday, August 30, 2017 7:14 PMfranck.robert - Wednesday, August 30, 2017 1:13 AMBut if I come back to use Visual Studio, how can I proceed to open the report that has been published to the server (with report builder). It seems that with VS it is using a local version of the report and not the server one.Only way i know of to do this is to manually download the report and replace the version inside VS.
Thanks a lot.
Those two tolls are not really integrated.
Therefore I imagine that the best thing woud be to use only one of these two tools and not both of them.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply