Microsoft SSRS Reporting Services training exercises (page 1 of 3)

Showing exercises 1-20 (out of 53)

Category: SSRS Reporting Services
Topic: Designing a Simple Report
Level: Relatively easy
Course: Reporting Services
Exercise: Create a simple report, containing an image, a line and a textbox.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Designing a Simple Report
Level: Average difficulty
Course: Reporting Services
Exercise: Create a skeleton premier league table (this exercise is mostly about aligning and formatting text boxes).

Go to exercise ...

Category: SSRS Reporting Services
Topic: Data sources and datasets
Level: Relatively easy
Course: Reporting Services
Exercise: Create a data source and shared dataset to link to a simple two-table database of books and authors.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Tables
Level: Average difficulty
Course: Reporting Services
Exercise: Create a report containing a table listing actors, with interactive sorting.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Tables
Level: Harder than average
Course: Reporting Services
Exercise: Create a pretty tabular report listing out actors and their films, and freeze the headers at the top of each page.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Grouping tables
Level: Average difficulty
Course: Reporting Services
Exercise: Create a tabular report grouping films by starring actors.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Grouping tables
Level: Harder than average
Course: Reporting Services
Exercise: Create a tabular report listing films by language and country, with two levels of grouping and subtotals for each.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Expressions
Level: Average difficulty
Course: Reporting Services
Exercise: Create a report with an expression calculating film budgets per minute, and a simple page header.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Expressions
Level: Harder than average
Course: Reporting Services
Exercise: Create a report listing film directors by age (including calculating this age with an expression and conditional formatting).

Go to exercise ...

Category: SSRS Reporting Services
Topic: Parameters
Level: Relatively easy
Course: Reporting Services
Exercise: Create a report using parameters to show all of the actors born between two (user-input) dates.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Parameters
Level: Average difficulty
Course: Reporting Services
Exercise: Create a report with a multivalue droplist parameter, to show all of the films for a given set of certificates.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Parameters
Level: Average difficulty
Course: Reporting Services
Exercise: Create a report listing out all of the films made for any given actor (choosable from a drop list).

Go to exercise ...

Category: SSRS Reporting Services
Topic: Parameters
Level: Harder than average
Course: Reporting Services
Exercise: Create a report with droplists for the birth month and year for an actor (including an additional drop list to ask which day of the week should be shaded).

Go to exercise ...

Category: SSRS Reporting Services
Topic: Parameters
Level: Harder than average
Course: Reporting Services
Exercise: A fun but difficult exercise, involving hiding things depending on the value of a dropdown parameter, and with a navigation link thrown in.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Indicators
Level: Average difficulty
Course: Reporting Services
Exercise: Create a table showing appropriiate smiley faces - indicators - depending on how many Oscars each film was nominated for.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Gauges
Level: Average difficulty
Course: Reporting Services
Exercise: Create a table containing a gauge to measure the number of Oscar nominations for each film.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Gauges
Level: Harder than average
Course: Reporting Services
Exercise: Create a table with a gauge panel containing 2 gauges and 3 labels, measuring film budgets against box office.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Matrices
Level: Relatively easy
Course: Reporting Services
Exercise: Create a simple matrix of films by certificate and country.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Matrices
Level: Average difficulty
Course: Reporting Services
Exercise: Create a matrix of Oscars, to include formatted subtotals and conditional formatting.

Go to exercise ...

Category: SSRS Reporting Services
Topic: Matrices
Level: Harder than average
Course: Reporting Services
Exercise: Create a matrix of actors by decade and gender - lots of extra complications in this one!.

Go to exercise ...

This page has 0 threads Add post