Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Report Builder 3.0 vs Visual Studio 2012 for creating SSRS Reports

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?

like image 326
Juan Velez Avatar asked Jul 02 '15 14:07

Juan Velez


People also ask

How do I create a SSRS report in Visual Studio 2012?

Start VS 2012 then go to "File" -> "New" -> "Project...". Go to the Business intelligence Tab then select Project server project Template then change the name of the project then click OK. Then right-click on the Report folder that is in Solution Explorer then click on the Add New Report command as shown.

Is Microsoft report Builder the same as SSRS?

Report Builder implements the same Report Designer that is provided by SQL Server Reporting Services (SSRS) and the SQL Server Data Tools (SSDT) development tool.

Is report Builder part of SSRS?

Report Builder, Report Designer, Report Manage, Report Server, Data sources are important SSRS components.


1 Answers

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:

  • Create a report in the Report Designer
  • Deploy the report
  • Do a fix with Report Builder
  • Save the report (= deploys the report)

Here are the official descriptions of each environments:

Report Designer

Report Designer in Business Intelligence Development Studio is a report authoring environment that is hosted in Microsoft Visual Studio. Use Report Designer project and solution files to organize and maintain a master copy of report definitions, report parts, shared data sources, shared datasets, and resource files such as images and ESRI shapefiles for maps.

Report Builder

Report Builder is a report authoring environment for business users who prefer to work in the Microsoft Office environment. You work with one report at a time. You can modify a published report directly from a report server. You can quickly build a report by adding items from the Report Part Gallery provided by report designers from your organization.

More info on the differences between Report Designer and Report Builder:

  • Designing Reports in Report Designer and Report Builder 3.0 (SSRS)
  • Comparing Report Authoring Environments
like image 190
Sébastien Sevrin Avatar answered Oct 13 '22 00:10

Sébastien Sevrin