Planning a Report (Report Builder)
Applies To: SQL Server 2016
Report Builder lets you create many kinds of paginated reports. For example, you can create reports that show summary or detailed sales data, marketing and sales trends, operational reports, or dashboards. You can also create reports that take advantage of richly formatted text, such as for sales orders, product catalogs, or form letters. All these reports are created by using different combinations of the same basic building blocks in Report Builder. To create a useful, easily understood report, it helps to plan first. Here are some things you might want to consider before you get started:
What format do you want the report to appear in?
You can render reports online in a browser such as the Reporting Services web portal or export them to other formats such as Excel, Word, or PDF. The final form your report takes is an important consideration because not all features are available in all export formats. For more information, see Export Reports (Report Builder and SSRS).
What structure do you want to use to present the data in the report?
You have a choice among tabular, matrix (similar to a cross-tab or PivotTable report), chart, free-form structures, or any combination of these to present data. For more information, see Tables, Matrices, and Lists (Report Builder and SSRS) and Charts (Report Builder and SSRS).
What do you want your report to look like?
Report Builder provides a lot of report items that you can add to your report to make it easier to read, highlight key information, help your audience navigate the report, and so on. Knowing how you want the report to appear can determine whether you need report items such as text boxes, rectangles, images, and lines. You might also want to show or hide items, add a document map, include drillthrough reports or subreports, or link to other reports. For more information, see Images, Text Boxes, Rectangles, and Lines (Report Builder and SSRS) and Interactive Sort, Document Maps, and Links (Report Builder and SSRS).
What data do you want your readers to see? Should the data or format be filtered for different audiences?
You might want to narrow the scope of the report to specific users or locations, or to a particular time period. To filter the report data, use parameters to retrieve and display only the data you want. For more information, see Report Parameters (Report Builder and Report Designer).
Do you need to create your own calculations?
Sometimes, your data source and datasets do not contain the exact fields that you need for your report. In that situation, you might have to create your own calculated fields. For example, you might want to multiply the price per unit times the quantity to get a line item sales amount. Expressions are also used to provide conditional formatting and other advanced features. For more information, see Expressions (Report Builder and SSRS).
Do you want to hide report items initially?
Consider whether you want to hide report items, including data regions, groups and columns, when the report is first run. For example, you can initially present a summary table, and then drill down into the detailed data. For more information, see Drilldown Action (Report Builder and SSRS).
How are you going to deliver your report?
You can save your report to your local computer and continue to work on it, or run it locally for your own information. However, to share your report with others, you need to save the report to a report server that is configured in native mode or a report server in SharePoint integrated mode. Saving it to a server lets others run it whenever they want to. Alternatively, the report server administrator can set up a subscription to the report or set up e-mail delivery of the report to other individuals. You can have the report delivered in a specific export format if you prefer. For more information, see Finding, Viewing, and Managing Reports (Report Builder and SSRS ).