WISE OWL EXERCISES
SSRS EXERCISES
SSRS REPORTING SERVICES EXERCISES
- Designing a Simple Report (3)
- Data sources and datasets (1)
- Tables (5)
- Grouping tables (6)
- Expressions (8)
- Pages and printing (2)
- Parameters (9)
- Indicators (3)
- Gauges (4)
- Matrices (5)
- Charts (6)
- Data bars and sparklines (2)
- Lists (4)
- Subreports (2)
- Revision of expressions (3)
- Variables (3)
- Embedding code (3)
- Basic Custom Assemblies (2)
- Examples of custom assemblies (1)
- Customising reports (2)
- Stored procedures in SSRS (2)
- Parameters using Stored Procedures (2)
- Dropdown parameters (9)
- Multivalue dropdowns (1)
- Improving report navigation (2)
- Linking reports (drilldown) (4)
- Dynamic reports (2)
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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). |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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). |
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. |
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. |
Software: | SSRS Reporting Services |
Version: | SSRS 2012 and later |
Topic: | Variables |
Level: | Average difficulty |
Course: | |
Exercise: | Use report variables to show percentages of totals. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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). |
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. |
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. |
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. |
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. |
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!. |
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. |
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. |
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). |
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. |
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. |
You can search our full list of SSRS exercises here.