Free SSRS Reporting Services exercises

This page lists 96 SSRS Reporting Services exercises. You can use the menu to show just exercises for a specific topic.

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Pages and printing
Level: Relatively easy
Course: Reporting Services
Exercise: Use expressions in an SSRS report to generate a page header and footer.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Tables
Level: Relatively easy
Course: Reporting Services
Exercise: Create an SSRS report showing a table of actors with interactive sorting.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Charts
Level: Relatively easy
Course: Reporting Services
Exercise: Create a chart in SSRS using a timeline axis to display the history of war films.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Charts
Level: Relatively easy
Course: Reporting Services
Exercise: Create and format a bar chart of film takings by country and certificate.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Variables
Level: Relatively easy
Course:
Exercise: Use a report variable to colour the first n rows of a report.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Designing a Simple Report
Level: Relatively easy
Course: Reporting Services
Exercise: Create a basic SSRS report containing a table of actors sorted by name, and a simple image.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Charts
Level: Relatively easy
Course: Reporting Services
Exercise: Create a pyramid chart in SSRS to display the average budget of martial arts movies.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Lists
Level: Relatively easy
Course: Reporting Services
Exercise: Create a simple list in an SSRS report to display martial arts films.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Matrices
Level: Relatively easy
Course: Reporting Services
Exercise: Create a matrix to show the total Oscars won by films in different genres with different certificates.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

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

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Stored procedures in SSRS
Level: Relatively easy
Course:
Exercise: Create a stored procedure listing actors in order, and use it to create a report.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Revision of expressions
Level: Relatively easy
Course:
Exercise: Create a couple of expressions for a report, using the IIF function.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Dropdown parameters
Level: Relatively easy
Course:
Exercise: Use a drop down list parameter in an SSRS report to filter a table of films based on their Oscar success.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Dropdown parameters
Level: Relatively easy
Course:
Exercise: Use drop down list parameters to filter a table of films in an SSRS report.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Grouping tables
Level: Relatively easy
Course: Reporting Services
Exercise: Create a grouped table in an SSRS report with collapsible sections.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Grouping tables
Level: Relatively easy
Course: Reporting Services
Exercise: Apply grouping to an SSRS table to organise films by genre.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Basic Custom Assemblies
Level: Relatively easy
Course:
Exercise: Assign an expression to an image name, using a custom assembly.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Parameters
Level: Relatively easy
Course: Reporting Services
Exercise: Use parameters in an SSRS report to filter a table of actors by name.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Parameters
Level: Relatively easy
Course: Reporting Services
Exercise: Use text parameters in an SSRS report to filter a table of film roles.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Charts
Level: Relatively easy
Course: Reporting Services
Exercise: Create a pie chart in an SSRS report to shown the length of films.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Parameters using Stored Procedures
Level: Relatively easy
Course:
Exercise: Use two date parameters in a stored procedure for a report listing directors.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Gauges
Level: Relatively easy
Course: Reporting Services
Exercise: Use a gauge in an SSRS report to display the approximate age of films in a table.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Dropdown parameters
Level: Relatively easy
Course:
Exercise: Create a dropdown parameter listing film certificates, and use this to show a report of films.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Lists
Level: Relatively easy
Course: Reporting Services
Exercise: Create a simple list, showing the main details of each film in a separate box.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Data bars and sparklines
Level: Relatively easy
Course: Reporting Services
Exercise: Add data bars to a table in an SSRS report to display the length of science fiction movies.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Indicators
Level: Relatively easy
Course: Reporting Services
Exercise: Use basic indicators in an SSRS report to show the relative success of films based on their Oscar nominations.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Embedding code
Level: Relatively easy
Course:
Exercise: Create and embedded code function to calculate film profit margins.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Tables
Level: Average difficulty
Course: Reporting Services
Exercise: Create a report containing a table listing actors, with interactive sorting.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Expressions
Level: Average difficulty
Course: Reporting Services
Exercise: Add calculated fields to an SSRS dataset to calculate the percentage success rate of Oscars won by films.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Expressions
Level: Average difficulty
Course: Reporting Services
Exercise: Use expressions to create conditional formatting in an SSRS table.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Charts
Level: Average difficulty
Course: Reporting Services
Exercise: Create a doughnut chart in SSRS to display the relative box office takings of animation films.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Dropdown parameters
Level: Average difficulty
Course:
Exercise: Dropdown of genders, with list of actors coloured according to choice.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Improving report navigation
Level: Average difficulty
Course:
Exercise: Create a document map / outline for a table with two grouping levels.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Linking reports (drilldown)
Level: Average difficulty
Course:
Exercise: Create a drillthrough report in SSRS which allows the user to click a country name to see a list of films made in that country.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Gauges
Level: Average difficulty
Course: Reporting Services
Exercise: Use a gauge to compare Oscar wins with Oscar nominations in a table of films.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Matrices
Level: Average difficulty
Course: Reporting Services
Exercise: Create a matrix which groups actors by their day and month of birth in an SSRS report.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Stored procedures in SSRS
Level: Average difficulty
Course:
Exercise: Create a report using a stored procedure linking 2 tables with a WHERE clause.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Subreports
Level: Average difficulty
Course: Reporting Services
Exercise: Create an SSRS report and subreport combination to display a list of films with different certificates.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Improving report navigation
Level: Average difficulty
Course:
Exercise: Create bookmarks for group members, then a table of contents to link to them.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Customising reports
Level: Average difficulty
Course:
Exercise: Create a template, including page setup, logos and default dataset.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Customising reports
Level: Average difficulty
Course:
Exercise: Create a CSS file and apply it to reports to customise the parameter bar.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Data bars and sparklines
Level: Average difficulty
Course: Reporting Services
Exercise: Create a table showing in data bars the number of Oscar-winning films made per actor.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Parameters
Level: Average difficulty
Course: Reporting Services
Exercise: Create date parameters in an SSRS report to filter a table of actors.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Dynamic reports
Level: Average difficulty
Course:
Exercise: Dynamic column chart with dropdown to choose category field.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Dynamic reports
Level: Average difficulty
Course:
Exercise: Use an expression for a dataset to create a report with two dynamic sort fields.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Pages and printing
Level: Average difficulty
Course: Reporting Services
Exercise: Export an SSRS report to Excel using the RenderFormat.Name property to control the visibility of report items.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Dropdown parameters
Level: Average difficulty
Course:
Exercise: Use drop down list parameters in an SSRS report to filter a list of actors based on their gender and dead or alive status.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Expressions
Level: Average difficulty
Course: Reporting Services
Exercise: Create a calculated field to test if a field contains no value. Use the result of the expression to filter two tables.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Tables
Level: Average difficulty
Course: Reporting Services
Exercise: Create two tables in an SSRS report and apply filters to each using the Tablix Properties dialog box.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Expressions
Level: Average difficulty
Course: Reporting Services
Exercise: Apply conditional formatting to an SSRS report using expressions.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Grouping tables
Level: Average difficulty
Course: Reporting Services
Exercise: Apply multiple grouping levels to a table in an SSRS report.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Grouping tables
Level: Average difficulty
Course: Reporting Services
Exercise: Create a tabular report grouping films by starring actors.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Linking reports (drilldown)
Level: Average difficulty
Course:
Exercise: Create a pie chart of films, and attach an action to each slice to show details for that film in a separate table.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Lists
Level: Average difficulty
Course: Reporting Services
Exercise: Create a list grouping by film certificate, to include a table and a chart analysing the films for each certificate.

Go to exercise ...

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

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Multivalue dropdowns
Level: Average difficulty
Course:
Exercise: Multivalue droplist, using JOIN to display parameter labels.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Dropdown parameters
Level: Average difficulty
Course:
Exercise: Use parameters in an SSRS report to control the results generated by calculated fields.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Parameters using Stored Procedures
Level: Average difficulty
Course:
Exercise: List films lasting between 2 parameters, one of which may be null.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Variables
Level: Average difficulty
Course:
Exercise: Use report variables to show percentages of totals.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Tables
Level: Average difficulty
Course: Reporting Services
Exercise: Create a formatted SSRS table to show a list of successful films with interactive sorting and a total row.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Subreports
Level: Average difficulty
Course: Reporting Services
Exercise: Create a report and subreport listing out all of the actors appearing in each film.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Basic Custom Assemblies
Level: Average difficulty
Course:
Exercise: Use a custom assembly to remember - and change - row back colours.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Embedding code
Level: Average difficulty
Course:
Exercise: Create an embedded function to show films are blockbusters or turkeys.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Indicators
Level: Average difficulty
Course: Reporting Services
Exercise: Add indicators to an SSRS report to display the length of each film in a table.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Revision of expressions
Level: Average difficulty
Course:
Exercise: Create a calculated field using SWITCH to categorise directors.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Embedding code
Level: Harder than average
Course:
Exercise: A long VB function in embedded code to count and summarise words.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Expressions
Level: Harder than average
Course: Reporting Services
Exercise: Use expressions in an SSRS report to calculate a variety of values related to the season of a film.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Dropdown parameters
Level: Harder than average
Course:
Exercise: Create a sequence of cascading drop list parameters in an SSRS report.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Revision of expressions
Level: Harder than average
Course:
Exercise: For each film show a list of its actors, using JOIN and LOOKUPSET.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Linking reports (drilldown)
Level: Harder than average
Course:
Exercise: Create an SSRS report with a column chart which allows the user to drill through to see details of films made in different countries.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Linking reports (drilldown)
Level: Harder than average
Course:
Exercise: Create an SSRS report with a matrix which can be used to drill through to another report.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Lists
Level: Harder than average
Course: Reporting Services
Exercise: Create a grouped list in an SSRS report to display details of crime films.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Examples of custom assemblies
Level: Harder than average
Course:
Exercise: Use a report variable and custom assembly to colour rows proportionally.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Charts
Level: Harder than average
Course: Reporting Services
Exercise: Create a doughnut chart within a grouped table giving breakdown of number of films by certificate.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Dropdown parameters
Level: Harder than average
Course:
Exercise: Create a drop down list parameter to select the cast members for different films in an SSRS report.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Grouping tables
Level: Harder than average
Course: Reporting Services
Exercise: Create a report with multiple grouping levels and collapsible groups.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Dropdown parameters
Level: Harder than average
Course:
Exercise: Linked dropdowns using parameters, with a UNION query to replace the top value.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Expressions
Level: Harder than average
Course: Reporting Services
Exercise: Use the lookup function in an SSRS report to retrieve related information from a different data source.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

Software: SSRS Reporting Services
Version: SSRS 2016 and later
Topic: Parameters
Level: Harder than average
Course: Reporting Services
Exercise: Use multiple parameters in an SSRS report to filter a table of films, allowing null values and with conditional formatting.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
Topic: Variables
Level: Harder than average
Course:
Exercise: Create one report and one group variable to show percent of totals.

Go to exercise ...

Software: SSRS Reporting Services
Version: SSRS 2012 and later
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 ...

You can search our full list of SSRS exercises here.

This page has 0 threads Add post