Microsoft Report Builder 3.0

Install Report Builder and access the website based on your reporting services setup, whether via SharePoint integration or a standalone site; then explore the interface to learn how it works.

install the standalone report builder from the installation file, run the wizard, accept the license, name the install, and specify the target and administrator url.

Install and launch the standalone reporting services website for Microsoft Report Builder 3.0. Log in, remember credentials, and explore the first-time installation and launch.

Explore the Microsoft report builder interface, from data sources and datasets to parameters and built-in fields, and insert tables, charts, and headers to run reports.

Choose between two installation options for report builder, then access it the same way and explore the interface while following along on a computer with report builder installed.

Create reports in Microsoft Report Builder 3.0 using either the wizard or manual approach; start by defining the data source and then build a table or matrix.

Define the data you need by creating a data source, the foundation of a report. Keep it private by default and convert it to a shared data source for others.

Create a local Adventure Works data source in Microsoft Report Builder 3.0, using a SQL Server connection string and Windows integrated security, then test the connection.

Learn how the report wizard simplifies creation, discuss its limitations, and distinguish data sources from datasets, then compare tables and matrices in terms of collapsing rows versus columns.

Learn to use the wizard in Microsoft Report Builder 3.0 to create a dataset and data source, run a query, and design a table or matrix with region and sales.

Learn how to manually create a tablix in Microsoft Report Builder 3.0 by inserting a matrix, mapping fields from a dataset, adding totals, and configuring expand/collapse visibility to toggle subcategories.

Reorganize a tablix to show two parallel dynamic groups by placing order year as a separate group after region, removing subgroups, and adding totals and sales amounts.

Create interactive reports by adding parameters and minor query changes, letting viewers filter data via dropdowns without SQL skills.

Explore using parameters and filters to tailor reports by viewer input. Create datasets and parameters for region, category, and subcategory, enabling multi-value and dependent selections.

Create reports using either the wizard or manual mode, noting wizard ease and its limitations, and learn the difference between a tape looks and a matrix, parameters and filters; practice.

Enhance reports by adding titles, footers, and page notes, and visualize data with charts, Gage visuals, and data maps. Use multiple data sets to augment tables.

Format by applying currency to all fields, adjust column widths, and add a clear title; include built-in fields like execution time, page number, and total pages for a footer.

Learn to add and format charts in Microsoft Report Builder 3.0, including inserting a chart, choosing a chart type, and binding data by values, series, and categories.

Create and customize a linear gauge in Microsoft Report Builder 3.0 by linking to sales amount, configuring the scale, pointer, and conditional colors to show progress toward goals.

Learn to create a map report with the map wizard, using a map gallery, add layers and spatial data, and build an analytical marker map with a legend.

Format your report for readability, add charts that enhance rather than clutter, and place charts only in the report body; explore gauges and maps by practicing these techniques.

Publish reports to a report server and share access with others. Save individual report components—tables, axes, charts, and images—as report parts to reuse across other reports.

View and render reports from the report server web site, then export or save them as csb, pdf, word, or excel formats in hd.

Create and publish report parts by inserting a logo image and naming it. Publish to a report server folder, then insert parts into a new report and update as needed.

Publish reports stored on a SharePoint server with the same process as without SharePoint, and reuse report components to save effort and produce reports faster.

Install Microsoft Report Builder, create and publish reports, and enhance visuals to deliver polished results. Practice what you've learned to become a pro, and return to 360 training.