I have always used Visual Studio to create my SSRS reports but I have recently been advised to switch over to and use report builder 3.0. I am wondering, are there are any advantages to using one over the other for SSRS report development?
Any known compatibility issues when trying to edit an .rdl in Report Builder 3.0 that was created in Visual Studio 2012?
Best Answer
I would say that the Report Designer (Visual Studio) targets Developers that have a Visual Studio edition, whereas Report Builder targets non-developer users, familiar with Office applications that will just need to let ClickOnce install Report Builder (but developers can use it too).
Report Builder has less features, but you can still do plenty of things with it, so it can be useful when you need to do a quick fix of the report, and you would take more time to do it with Report Designer.
Having said that, the following scenario is completely valid:
Here are the official descriptions of each environments:
Report Designer
Report Builder
More info on the differences between Report Designer and Report Builder: