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 (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)
SSRS Reporting Services exercises on PARAMETERS
This page lists the 15 exercises about Parameters in SSRS Reporting Services on our website:
| Software: | SSRS Reporting Services |
| Version: | SSRS 2016 and later |
| Topic: | Parameters |
| Level: | Relatively easy |
| Course: | Reporting Services |
| 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 |
| Course: | Reporting Services |
| 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: | 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: | 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 2016 and later |
| Topic: | Parameters |
| Level: | Average difficulty |
| Course: | Reporting Services |
| 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 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: | Parameters |
| Level: | Average difficulty |
| Course: | Reporting Services |
| Exercise: | Use parameters in an SSRS report to control the results generated by calculated fields. |
| Software: | SSRS Reporting Services |
| Version: | SSRS 2016 and later |
| Topic: | Parameters |
| Level: | Harder than average |
| Course: | Reporting Services |
| Exercise: | Create a sequence of cascading drop list parameters in an SSRS report. |
| Software: | SSRS Reporting Services |
| Version: | SSRS 2016 and later |
| Topic: | Parameters |
| Level: | Harder than average |
| Course: | Reporting Services |
| 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 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). |
You can search our full list of SSRS exercises here, or why not have a look at our other SSRS training resources?
This page has 0 threads
Add post