EXERCISE TOPIC▼
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 (15)
- 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)
- Using SQL views (3)
- Stored procedures in SSRS (2)
- Stored procedure parameters (2)
- Dropdowns with procedures (3)
- Multivalue parameter procedures (1)
- Improving report navigation (2)
- Linking reports (drilldown) (4)
- Dynamic reports (2)
Free SSRS Reporting Services exercises
This page lists 99 SSRS Reporting Services exercises. You can use the menu on the left to show just exercises for a specific topic.
This page lists 99 SSRS Reporting Services exercises. You can use the menu above to show just exercises for a specific topic.
| Software: | SSRS Reporting Services |
| Version: | SSRS 2016 and later |
| Topic: | Pages and printing |
| Level: | Relatively easy |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| Exercise: | Create a matrix to show the total Oscars won by films in different genres with different certificates. |
| Software: | SSRS Reporting Services |
| Version: | SSRS 2016 and later |
| Topic: | Using SQL views |
| Level: | Relatively easy |
| Courses: | Fast track SSRSAdvanced SSRS |
| Exercise: | Create a report based on a view listing actors and roles, then update it. |
| Software: | SSRS Reporting Services |
| Version: | SSRS 2012 and later |
| Topic: | Data sources and datasets |
| Level: | Relatively easy |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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: | Advanced SSRS |
| Exercise: | Create a couple of expressions for a report, using the IIF function. |
| Software: | SSRS Reporting Services |
| Version: | SSRS 2016 and later |
| Topic: | Parameters |
| Level: | Relatively easy |
| Courses: | Reporting ServicesFast track SSRS |
| 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: | Parameters |
| Level: | Relatively easy |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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: | Stored procedure parameters |
| Level: | Relatively easy |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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: | Dropdowns with procedures |
| Level: | Relatively easy |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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: | Dropdowns with procedures |
| Level: | Average difficulty |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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 |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| Exercise: | Create a matrix which groups actors by their day and month of birth in an SSRS report. |
| Software: | SSRS Reporting Services |
| Version: | SSRS 2016 and later |
| Topic: | Using SQL views |
| Level: | Average difficulty |
| Courses: | Fast track SSRSAdvanced SSRS |
| Exercise: | Create a view including all film tables, and use this to create a matrix report. |
| Software: | SSRS Reporting Services |
| Version: | SSRS 2012 and later |
| Topic: | Designing a Simple Report |
| Level: | Average difficulty |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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 |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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: | Parameters |
| Level: | Average difficulty |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| Exercise: | Apply conditional formatting to an SSRS report using expressions. |
| Software: | SSRS Reporting Services |
| Version: | SSRS 2012 and later |
| Topic: | Gauges |
| Level: | Average difficulty |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| Exercise: | Create a tabular report grouping films by starring actors. |
| Software: | SSRS Reporting Services |
| Version: | SSRS 2012 and later |
| Topic: | Indicators |
| Level: | Average difficulty |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| Exercise: | Create a matrix of Oscars, to include formatted subtotals and conditional formatting. |
| Software: | SSRS Reporting Services |
| Version: | SSRS 2012 and later |
| Topic: | Multivalue parameter procedures |
| Level: | Average difficulty |
| Courses: | Fast track SSRSAdvanced SSRS |
| Exercise: | Multivalue droplist, using JOIN to display parameter labels. |
| Software: | SSRS Reporting Services |
| Version: | SSRS 2012 and later |
| Topic: | Parameters |
| Level: | Average difficulty |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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: | Parameters |
| Level: | Average difficulty |
| Courses: | Reporting ServicesFast track SSRS |
| 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: | Stored procedure parameters |
| Level: | Average difficulty |
| Courses: | Fast track SSRSAdvanced SSRS |
| Exercise: | List films lasting between 2 parameters, one of which may be null. |
| Software: | SSRS Reporting Services |
| Version: | SSRS 2016 and later |
| Topic: | Using SQL views |
| Level: | Average difficulty |
| Courses: | Fast track SSRSAdvanced SSRS |
| Exercise: | Create a new view showing film profitability, and use this for a report. |
| Software: | SSRS Reporting Services |
| Version: | SSRS 2012 and later |
| Topic: | Variables |
| Level: | Average difficulty |
| Courses: | Fast track SSRSAdvanced SSRS |
| Exercise: | Use report variables to show percentages of totals. |
| Software: | SSRS Reporting Services |
| Version: | SSRS 2016 and later |
| Topic: | Tables |
| Level: | Average difficulty |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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: | Advanced SSRS |
| 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 |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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: | Parameters |
| Level: | Harder than average |
| Courses: | Reporting ServicesFast track SSRS |
| 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: | Advanced SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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: | Parameters |
| Level: | Harder than average |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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: | Dropdowns with procedures |
| Level: | Harder than average |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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 |
| Courses: | Fast track SSRSAdvanced SSRS |
| 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 |
| Courses: | Reporting ServicesFast track SSRS |
| 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. Or why not learn to do them the right way on one of our classroom SSRS training courses in the UK, or on one of our live online SSRS courses wherever you are in the world?
This page has 0 threads
Add post