Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
545 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Here are the chapters included in this course manual (we use exactly the same manuals for our classroom and online Reporting Services courses).
Click here to download a sample of the first two chapters of this Advanced SSRS manual, or review how to license our courseware.
Section | Title |
---|---|
1.1 | Grouping Basics |
1.2 | Grouping Rows in a Table |
1.3 | Removing Groups |
1.4 | Formatting a Grouped Table |
1.5 | Multiple Groups |
1.6 | Page Breaks |
1.7 | Collapsible Groups |
Section | Title |
---|---|
2.1 | Overview of Expressions |
2.2 | Ad-Hoc Table Columns |
2.3 | Calculated Fields |
2.4 | Working with Numbers |
2.5 | Conditional Functions |
2.6 | Working with Text |
2.7 | Working with Dates |
2.8 | Aggregating Data |
2.9 | Lookup Functions |
2.10 | Built-In Fields |
2.11 | Placeholders |
Section | Title |
---|---|
3.1 | Scope |
3.2 | Row Numbers |
3.3 | Running Totals |
3.4 | Extra Functions |
Section | Title |
---|---|
4.1 | Using Variables |
4.2 | How Variables are Calculated |
4.3 | Group Variables |
Section | Title |
---|---|
5.1 | Overview – Ways to Reuse Code |
5.2 | Creating an Embedded Function |
5.3 | Other Ways to Write Code |
Section | Title |
---|---|
6.1 | Server Explorer / Management Studio |
6.2 | Accessing Server Explorer |
6.3 | Accessing Management Studio (SSMS) |
Section | Title |
---|---|
7.1 | The Need for Views |
7.2 | Creating Views using the Designer |
7.3 | Scripting Views |
7.4 | Switching between the Designer and Scripting |
7.5 | Using Views in Datasets |
7.6 | Using Views to Rename Columns |
7.7 | Pros and Cons of Views |
Section | Title |
---|---|
8.1 | Introduction to Parameters |
8.2 | Report Parameters |
8.3 | Query Parameters |
8.4 | Organising Parameters |
8.5 | Default Values |
8.6 | Null Values |
8.7 | Drop Down Lists |
8.8 | Multi-Value Drop Down Lists |
8.9 | Cascading Drop Down Lists |
8.10 | Conditional Formatting with Parameters |
Section | Title |
---|---|
9.1 | Introduction to Stored Procedures |
9.2 | Creating Stored Procedures |
9.3 | Altering a Stored Procedure |
9.4 | Executing Stored Procedures |
9.5 | Renaming and Deleting Stored Procedures |
9.6 | The Cheat’s Stored Procedure |
Section | Title |
---|---|
10.1 | Overview |
10.2 | Creating Procedures with Parameters |
10.3 | Testing Procedures using Parameters |
10.4 | Stored Procedure Parameters in SSRS Reports |
10.5 | Allowing Null Values |
10.6 | Parameter Data Types (Numbers) |
10.7 | Parameter Data Types (Text) |
10.8 | Parameter Data Types (Dates/Times) |
Section | Title |
---|---|
11.1 | Basic Dropdowns using Stored Procedures |
11.2 | Cascading Dropdowns |
11.3 | Removing SELECT A VALUE |
Section | Title |
---|---|
12.1 | Multivalue Parameters |
12.2 | Splitting Comma-Delimited Strings |
12.3 | Creating a Multivalue Parameter |
12.4 | Coping with Multivalue Choices |
Section | Title |
---|---|
13.1 | Overview of Drillthrough Reports |
13.2 | Creating the Child Report |
13.3 | Creating the Parent Report |
13.4 | Creating Report Actions |
13.5 | Using Drillthrough Reports |
13.6 | Multiple Parameters |
Section | Title |
---|---|
14.1 | Bookmarks |
14.2 | Navigation Maps |
Section | Title |
---|---|
15.1 | Dynamic Data Sources |
15.2 | Dynamic Datasets |
15.3 | Dynamic Stored Procedures |
Section | Title |
---|---|
16.1 | Examples in this Chapter |
16.2 | The Underlying Principle |
16.3 | Example – Choosing the Grouping Field |
16.4 | Example – Choosing the Row and Column Field for a Matrix |
16.5 | Example – Choosing the Data Field |
If you book a place on one of our courses you will automatically get access to the relevant courseware manual online, and also have the option to receive a paper copy of it.
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.