Microsoft SSRS 2012 training exercises (page 1 of 3)

Showing exercises 1-20 (out of 53)

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

Go to exercise ...

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

Go to exercise ...

Category: SSRS 2012
Topic: Data sources and datasets
Level: Relatively easy
Course:
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 2012
Topic: Tables
Level: Average difficulty
Course:
Exercise: Create a report containing a table listing actors, with interactive sorting.

Go to exercise ...

Category: SSRS 2012
Topic: Tables
Level: Harder than average
Course:
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 2012
Topic: Grouping tables
Level: Average difficulty
Course:
Exercise: Create a tabular report grouping films by starring actors.

Go to exercise ...

Category: SSRS 2012
Topic: Grouping tables
Level: Harder than average
Course:
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 2012
Topic: Expressions
Level: Average difficulty
Course:
Exercise: Create a report with an expression calculating film budgets per minute, and a simple page header.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Category: SSRS 2012
Topic: Parameters
Level: Average difficulty
Course:
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 2012
Topic: Parameters
Level: Average difficulty
Course:
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 2012
Topic: Parameters
Level: Harder than average
Course:
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 2012
Topic: Parameters
Level: Harder than average
Course:
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 2012
Topic: Indicators
Level: Average difficulty
Course:
Exercise: Create a table showing appropriiate smiley faces - indicators - depending on how many Oscars each film was nominated for.

Go to exercise ...

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

Go to exercise ...

Category: SSRS 2012
Topic: Gauges
Level: Harder than average
Course:
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 2012
Topic: Matrices
Level: Relatively easy
Course:
Exercise: Create a simple matrix of films by certificate and country.

Go to exercise ...

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

Go to exercise ...

Category: SSRS 2012
Topic: Matrices
Level: Harder than average
Course:
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