Редактиране

Споделяне чрез


Report Builder tutorials

Applies to:  SQL Server 2016 (13.x)  Power BI Report Server

The Report Builder tutorials help you learn how to create basic Reporting Services paginated reports.

Tutorial Description
Prerequisites for tutorials (Report Builder) To use these tutorials, you must have read-only access to a SQL Server database and permissions to access a SQL Server 2016 (13.x) Reporting Services (SSRS) or later report server.
Create a basic table report (Report Builder) Create a data source connection, define a query, build a layout to contain your data, format your report, and add grouping and totals.
Create a matrix report (Report Builder) Use the Table or Matrix Wizard to create the report data source, dataset, and layout, and then enhance the matrix within the Design view of Report Builder.
Create a free form report (Report Builder) Create a free-form report from scratch. Free-form reports allow for a flexible layout, making it easy to design visually appealing reports in various formats.
Format text (Report Builder) Format text in your reports to enhance readability and present data professionally.
Add a column chart to your report (Report Builder) Add columns to charts to show data changes over time and compare relative values over multiple charts. You can add a column chart to show data changes over time and compare the relative value of multiple series.
Add a pie chart to your report (Report Builder) Add a pie chart to a report. Pie charts help visualize data as a proportion of the whole.
Add a bar chart to your report (Report Builder) Add a bar chart to a report. Bar chart visualizations help to improve readability and understandability of report data.
Add a sparkline to your report (Report Builder) Create a matrix and then add a set of sparkline charts to the matrix. Sparklines and data bars are small, simple charts that convey large amounts of information in a little space.
Add a KPI to your report (Report Builder) Add a key performance indicator (KPI) to a report. KPIs help you show measurable values with business significance.
Map report (Report Builder) Add a map to a report. Use the map to display data on a geographic background in a Reporting Services paginated report.
Add a parameter to your report (Report Builder) Customize the appearance and content of a report by using parameters. The parameters allow report readers to filter report data for one or more values.
Create drillthrough and main reports (Report Builder) Create reports for a drillthrough scenario based on an Analysis Services cube. You create the main report and enable it for drillthrough and the report that's the target of the drillthrough action.
Introduce expressions Use expressions to concatenate, calculate, and look up field values and show them a report. You learn how to conditionally display different images and indicator states by using expressions.
Reporting Services tutorials See the other Reporting Services tutorials to learn more about how to create basic Reporting Services paginated reports.