Report Formatting

SQL Server 2014    |    Expert
  • 14 videos | 1h 30m 52s
  • Earns a Badge
Rating 4.3 of 7 users Rating 4.3 of 7 users (7)
You can create different types of reports using either SQL Server Data Tools Report Designer and Report Builder. Learn how to use these tools to create reports with different options, including images, charts, and column headers.

WHAT YOU WILL LEARN

  • Create a basic table report
    Create a basic matrix report
    Format field and column headers in a table and matrix report
    Add images, maps, charts, and indicators to a report
    Add lists, text boxes, and other visuals to a report, including headers and footers
    Group data in a report and add line totals and grand totals
    Implement group variables and report variables to a report
  • Define expressions to retrieve, calculate, display, sort, filter, and parameterize data
    Use the report wizard to create a new report
    Create a new report in report builder by selecting the appropriate report layout and adding data sources and datasets
    Filter, group, and sort data for a report in report builder
    Add images, maps, charts, and indicators to a report in report builder
    Add interactive features to a report in report builder
    Modify an existing report that was created in sql server data tools report designer

IN THIS COURSE

  • 5m 23s
    In this video, you will create a basic table report. FREE ACCESS
  • 4m 21s
    Learn how to create a basic matrix report. FREE ACCESS
  • Locked
    3.  Formatting Fields and Column Headers
    5m 43s
    In this video, you will format field and column headers in a table and matrix report. FREE ACCESS
  • Locked
    4.  Adding Images, Maps, Charts, and Indicators
    13m 6s
    In this video, you will learn how to add images, maps, charts, and indicators to a report. FREE ACCESS
  • Locked
    5.  Adding Lists, Text Boxes, and Other Visuals
    7m 14s
    In this video, you will learn how to add lists, text boxes, and other visuals to a report, including headers and footers. FREE ACCESS
  • Locked
    6.  Grouping Data and Adding Line Totals and Grand Totals
    4m 19s
    In this video, you will learn how to group data in a report and add line totals and grand totals. FREE ACCESS
  • Locked
    7.  Implementing Group and Report Variables
    6m 27s
    Learn how to implement group variables and report variables in a report. FREE ACCESS
  • Locked
    8.  Defining Expressions
    5m 53s
    In this video, you will learn how to create expressions to retrieve, calculate, display, sort, filter, and parameterize data. FREE ACCESS
  • Locked
    9.  Using the Report Wizard to Create a Report
    4m 53s
    In this video, you will learn how to use the Report Wizard to create a new report. FREE ACCESS
  • Locked
    10.  Creating a Report in Report Builder
    6m 9s
    In this video, you will learn how to create a new report in Report Builder by selecting the appropriate report layout and adding data sources and datasets. FREE ACCESS
  • Locked
    11.  Filtering, Grouping, and Sorting Data in Report Builder
    7m 37s
    Learn how to filter, group, and sort data for a report in Report Builder. FREE ACCESS
  • Locked
    12.  Adding Images, Charts, Gauges, and Indicators
    11m 10s
    In this video, you will learn how to add images, maps, charts, and indicators to a report in Report Builder. FREE ACCESS
  • Locked
    13.  Adding Interactive Features in Report Builder
    5m 23s
    Learn how to add interactive features to a report in Report Builder. FREE ACCESS
  • Locked
    14.  Modifying an Existing Report in Report Builder
    3m 15s
    In this video, you will learn how to modify an existing report that was created in SQL Server Data Tools Report Designer. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Business Reporting: Creating & Formatting Matrix Visualizations in Power BI
Rating 4.4 of 230 users Rating 4.4 of 230 users (230)
Course CompTIA Data+: Data Visualization Reports
Rating 5.0 of 6 users Rating 5.0 of 6 users (6)
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Managing Reporting Services
Rating 4.4 of 11 users Rating 4.4 of 11 users (11)
Course Processing Reports & Creating Subscriptions and Schedules
Rating 3.8 of 5 users Rating 3.8 of 5 users (5)
Course Getting Started with the Power BI Service
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)