Microsoft Office Tutorials and References
In Depth Information
You can author reports with data sources using Report Builder or Report Designer from SQL Server 2012 Data Tools
(SSDT). The key difference between the two is that in Report Builder you use the ribbon to insert and configure
report items, while in Report Designer you use the SSDT toolbox to perform those tasks. However, both tools generate
reports in report definition language (rdl). Table 3-2 compares the tools.
Table 3-2. Comparison of Report Designer and ReportBuilder
SSDT Report Designer
Report Builder 3.0
Reports authored using SQL Server Data Tools by
connecting with various data sources
Does not use SSDT and is a separate application
Source control system compatible
Though it is not directly compatible, reports can be
source-controlled from the application. For instance,
you can source-control report files using SharePoint
document library versioning.
Used mostly by advanced users and developers
Used by business users for easy report generation
Capable of multiple deployments
Not capable of multiple deployments
Can embed a data source and create shared data sources
Add report models
Can view RDL file source
Can’t view RDL file source
Can import reports from an Access database
Can’t import reports from an Access database
Even a brief glance at the products, as in Table 3-2 , suggests that SSDT provides many more features than Report
Builder 3.0. To get more details about the features of both, visit http://msdn.microsoft.com/en-us/library/dd207010.aspx .
Now, let’s author a basic report using SSDT.
Building and Publishing a Basic Report
When you’re authoring a report and publishing it to your SharePoint environment, it is important to choose the right tool.
We will use SSDT Report Designer for the following example and later edit the published report using Report Builder.
Use SSDt report Designer to author a report that retrieves data from the adventure Works DW 2012 cube, and
publish the report to a Sharepoint environment.
Launch SQL Server Business intelligence Studio and, from the File menu, click on new project.
in the new project window, select the Business intelligence template from the left side and
select report Server project from the available templates. Set the name, Location and Solution
name values, and click oK. in this example, let’s name this project “report project Sample.” in
the Solution explorer window, right-click on the reports folder and then on add new report.
Search JabSto ::