This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Free SSRS Reporting Services exercises

You are welcome to try any of the 99 SSRS Reporting Services exercises listed below, but please do not distribute them in any form without asking for our written permission first.

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	SSRS Reporting Services
Topic:	Parameters
Level:	Relatively easy
Exercise:	Use a drop down list parameter in an SSRS report to filter a table of films based on their Oscar success.

Show this exercise

Software:	SSRS Reporting Services
Topic:	Parameters
Level:	Relatively easy
Exercise:	Use drop down list parameters to filter a table of films in an SSRS report.

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	SSRS Reporting Services
Topic:	Parameters
Level:	Average difficulty
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.

Show this exercise

Software:	SSRS Reporting Services
Topic:	Parameters
Level:	Average difficulty
Exercise:	Use parameters in an SSRS report to control the results generated by calculated fields.

Show this exercise

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

Show this exercise

Software:	SSRS Reporting Services
Topic:	Parameters
Level:	Harder than average
Exercise:	Create a drop down list parameter to select the cast members for different films in an SSRS report.

Show this exercise

Software:	SSRS Reporting Services
Topic:	Parameters
Level:	Harder than average
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).

Show this exercise

Software:	SSRS Reporting Services
Topic:	Parameters
Level:	Harder than average
Exercise:	Create a sequence of cascading drop list parameters in an SSRS report.

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	SSRS Reporting Services
Topic:	Using SQL views
Level:	Relatively easy
Exercise:	Create a report based on a view listing actors and roles, then update it.

Show this exercise

Software:	SSRS Reporting Services
Topic:	Using SQL views
Level:	Average difficulty
Exercise:	Create a new view showing film profitability, and use this for a report.

Show this exercise

Software:	SSRS Reporting Services
Topic:	Using SQL views
Level:	Average difficulty
Exercise:	Create a view including all film tables, and use this to create a matrix report.

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	SSRS Reporting Services
Topic:	Stored procedure parameters
Level:	Relatively easy
Exercise:	Use two date parameters in a stored procedure for a report listing directors.

Show this exercise

Software:	SSRS Reporting Services
Topic:	Stored procedure parameters
Level:	Average difficulty
Exercise:	List films lasting between 2 parameters, one of which may be null.

Show this exercise

Software:	SSRS Reporting Services
Topic:	Dropdowns with procedures
Level:	Relatively easy
Exercise:	Create a dropdown parameter listing film certificates, and use this to show a report of films.

Show this exercise

Software:	SSRS Reporting Services
Topic:	Dropdowns with procedures
Level:	Average difficulty
Exercise:	Dropdown of genders, with list of actors coloured according to choice.

Show this exercise

Software:	SSRS Reporting Services
Topic:	Dropdowns with procedures
Level:	Harder than average
Exercise:	Linked dropdowns using parameters, with a UNION query to replace the top value.

Show this exercise

Software:	SSRS Reporting Services
Topic:	Multivalue parameter procedures
Level:	Average difficulty
Exercise:	Multivalue droplist, using JOIN to display parameter labels.

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	SSRS Reporting Services
Topic:	Linking reports (drilldown)
Level:	Average difficulty
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.

Show this exercise

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

Show this exercise

Software:	SSRS Reporting Services
Topic:	Linking reports (drilldown)
Level:	Harder than average
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.

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

You can search our full list of SSRS exercises here. Or why not learn to do them the right way on one of our SSRS training courses? You can attend our online training classes wherever you are in the world!

This page has 0 threads

Add a new post

EXERCISE TOPIC

SSRS EXERCISES

SSRS REPORTING SERVICES EXERCISES

Free SSRS Reporting Services exercises

Head office

London

Manchester