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)
- Using SQL views (3)
- Stored procedures in SSRS (2)
- Stored procedure parameters (2)
- Dropdowns with procedures (9)
- Multivalue parameter procedures (1)
- Improving report navigation (2)
- Linking reports (drilldown) (4)
- Dynamic reports (2)
SSRS Reporting Services | Customising reports exercise | Customise the parameters bar for a report
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
The answer to the exercise will be included and explained if you attend the relevant Wise Owl course (sadly, only in the UK for now).
| Software ==> | SSRS Reporting Services (99 exercises) |
| Version ==> | SSRS 2012 and later |
| Topic ==> | Customising reports (2 exercises) |
| Level ==> | Average difficulty |
You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
First add the report called Vanilla from the above folder into your project (right-click on the project and choose to add an Existing Item):
Initially the report looks a bit boring and corporate.
Edit the file called rsreportserver.config in the appropriate folder so that it references a style sheet called pink.
Copy the default CSS file called HtmlViewer.css, to get a new file called pink.css:
You're now ready to make things pink!
Deploy the report to the report server, then see if your changes have worked:
Much better!
Finally, please delete the reference to the CSS style sheet from your rsreportserver.config file, before it gives an unprofessional impression of Wise Owl!