SQL SSRS Report Builder Course

This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment.

SQL SSRS Report Builder Course Description

Who should attend the SQL SSRS Report Builder Course?

Most attendees have good SQL knowledge. The course is in-depth SSRS.

SQL Data Course Details

Our Style: Hands-on, Practical
Location: Online, Instructor-led
Duration: 1 Days
Group Size: Maximum 4 people per group.
Qualification: PCWorkshops MS SQL SSRS Certification.
Times: Check the booking link

SQL SSRS Report Builder Course Topics


    SSRS Course Topics
  • Report Models:
    Data source views
    Creating a model
    Entities, attributes and roles

  • Tables:
    Creating tables
    Interactive sorting
    Floating headers

  • Grouping:
    Inserting groups
    Group headers/footers
    Displaying group totals
    Expanding and collapsing

  • Expressions:
    The expression builder
    The Report Items collection
    Built-in fields
    Conditional formatting expressions
    Page headers and footers
    Page names and numbers

  • Exporting reports:
    The various report formats
    Using RenderFormat.

  • Parameters:
    Creating parameters
    Filtering using parameters
    Drop list parameters
    Coping with empty tables

  • Matrices:
    Row and column groups
    Sorting and filtering matrices
    Creating subtotals

  • Charts:
    Creating charts
    The parts of a chart
    Formatting charts

  • Basic reports:
    Text boxes and images
    Selecting report items
    Formatting parts of a report
    Miniature charts
    Creating sparklines
    Creating data bars
    Graphical indicators
    Creating and customising indicators
    Linear and radial gauges

  • Lists:
    Page-per-record lists
    Dashboard lists
    Other list ideas

  • Subreports:
    Creating a child report
    Creating the main report
    Linking the two reports

  • Report parts:
    Publishing report parts
    The report part gallery
    Updating report parts

Contact us or customise the SSRS Courses

Powered byEMF HTML Contact Form

Where is our London Classroom

Golden Cross House, 8 Duncannon Street, London, WC2n 4JF

More About Our SSRS Courses

Instructor-led Experienced SQL trainers adapt to audience and address questions directly, delivering directly, live.
Practical SSRS Course All SQL skills are illustrated and thoroughly practiced with comprehensive, explanatory, practical exercises.
Personlised SSRS Courses Courses are fully customisable, use your relevant sample data via pre-course arrangement. The maximum number of delegates per group is 4.
Live online, London Classroom, or Onsite Normally we teach online, instructor-led. You can arrange SQL Intermediate Training onsite or in the London classroom via pre-course arrangement.

Contact PCWorkshops