PARAMETERS exercises

This page lists the 15 exercises about Parameters in SSRS Reporting Services on our website:

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

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!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 0 threads

Add a new post