BY CATEGORY▼
- VIDEOS HOME PAGE
- .NET (14)
- Business Intelligence (40)
- Integration Services (19)
- Macros and Programming (82)
- Microsoft Excel (70)
- Microsoft Office (92)
- Miscellaneous (1)
- Power BI (35)
- Power Platform (35)
- Python (31)
- Report Builder (107)
- Reporting Services (113)
- SQL (42)
- Visual Basic for Applications (215)
- Visual C# (14)
REPORT BUILDER CATEGORIES▼
REPORT BUILDER 2016 VIDEOS▼
- Report Builder Pt 1 - Installing Report Builder 2016
- Report Builder Pt 2 - Creating Your First Report
- Report Builder Pt 3 - Saving to a Report Server
- Report Builder Pt 4.1 - Embedded Data Sources and Datasets
- Report Builder Pt 4.2 - Shared Data Sources and Datasets
- Report Builder Pt 4.3 - Importing Datasets from Existing Reports
- Report Builder Pt 4.4 - Importing Datasets from SQL Query Files
- Report Builder Pt 4.5 - Datasets using Views
- Report Builder Pt 4.6 - Datasets using Stored Procedures
- Report Builder Pt 4.7 - Entering and Copying Data into a Report
- Report Builder Pt 5.1 - Basic Tables
- Report Builder Pt 5.2 - Sorting and Interactive Sorting in Tables
- Report Builder Pt 5.3 - Table Headers, Footers and Totals
- Report Builder Pt 5.4 - Repeating and Scrolling Table Headers
- Report Builder Pt 5.5 - Filtering Tables and Datasets
- Report Builder Pt 5.6 - Creating Or Filters in Datasets and Tables
- Report Builder Pt 6.1 - Grouping Rows in the Query Designer
- Report Builder Pt 6.2 - Grouping and Aggregating in a Table
- Report Builder Pt 6.3 - Creating Nested Parent and Child Groups
- Report Builder Pt 6.4 - Table Groups with Detail Rows
- Report Builder Pt 6.5 - Page Breaks and Headers in Table Groups
- Report Builder Pt 6.6 - Collapsible and Expandable Table Groups
- Report Builder Pt 6.7 - Recursive Table Groups
- Report Builder Pt 6.8 - Creating a Basic Matrix
- Report Builder Pt 6.9 - Matrix Nested Groups
- Report Builder Pt 7.1 - Basic Calculated Fields
- Report Builder Pt 7.2 - The IIf and Switch Functions
- Report Builder Pt 7.3 - Divide by Zero Errors
- Report Builder Pt 7.4 - And, Or, AndAlso, OrElse, Xor and Not
- Report Builder Pt 7.5 - Nulls in Expressions
- Report Builder Pt 7.6 - Calculating Date Parts
- Report Builder Pt 7.7 - Calculating Differences Between Dates
- Report Builder Pt 7.8 - Concatenating Values
- Report Builder Pt 7.9 - Trimming and Replacing Text
- Report Builder Pt 7.10 - Calculating First, Last and Middle Names
- Report Builder Pt 7.11 - Splitting and Joining Text
- Report Builder Pt 7.12 - Lookup, LookupSet and MultiLookup Functions
- Report Builder Pt 8.1 - Conditional Formatting in Tables
- Report Builder Pt 8.2 - Alternating Colours for Table Detail Rows
- Report Builder Pt 8.3 - Placeholders
- Report Builder Pt 9.1 - Aggregate Functions and Scope
- Report Builder Pt 9.2 - Percentage of Group Totals in a Table
- Report Builder Pt 9.3 - Percentage of Matrix Row and Column Totals
- Report Builder Pt 9.4 - Highlight Min and Max Values in a Table
- Report Builder Pt 9.5 - Highlight Min and Max Values in a Matrix
- Report Builder Pt 9.6 - Report Variables and Group Variables
- Report Builder Pt 9.7 - The RunningValue Function
- Report Builder Pt 9.8 - Alternating Row Colours in Grouped Tables
- Report Builder Pt 9.9 - The Previous Function
- Report Builder Pt 9.10 - Compare Previous Days, Months and Years
- Report Builder Pt 9.11 - Creating Sum If, Count If and Average If Expressions
- Report Builder Pt 10.1 - Report Parameters and Filters
- Report Builder Pt 10.2 - Query Parameters and Filters
- Report Builder Pt 10.3 - Default Values for Parameters
- Report Builder Pt 10.4 - Optional Report Parameters
- Report Builder Pt 10.5 - Optional Query Parameters
- Report Builder Pt 10.6 - Stored Procedure Parameters
- Report Builder Pt 10.7 - Boolean Report Parameters
- Report Builder Pt 10.8 - Boolean Query Parameters
- Report Builder Pt 11.1 - Drop Down List Parameters
- Report Builder Pt 11.2 - Optional Drop Down List Parameters
- Report Builder Pt 11.3 - Multi Value Parameters
- Report Builder Pt 11.4 - Multi Value Parameters and Null Values
- Report Builder Pt 11.5 - Multi Value Parameters and Stored Procedures
- Report Builder Pt 11.6 - Cascading Parameters
- Report Builder Pt 12.1 - Drill Through Reports using Tables
- Report Builder Pt 12.2 - Drill Through Reports using a Matrix
- Report Builder Pt 12.3 - Drill Through Reports using Charts
- Report Builder Pt 12.4 - Drill Through Reports using Maps
- Report Builder Pt 13.1 - Basic Indicators
- Report Builder Pt 13.2 - Custom Indicator Icons
- Report Builder Pt 13.3 - Indicators in a Matrix
- Report Builder Pt 13.4 - Using Indicators to Compare Previous Rows
- Report Builder Pt 14.1 - Basic Data Bars
- How do I highlight the parameter search string in a Report Builder table?
- How do I show a top 10 total and a grand total in a Report Builder table?
- How do I create an optional end date parameter in Report Builder?
- How do I compare specific columns in a matrix in SSRS?
- How do I refer to the previous column in a matrix in SSRS?
- How do I calculate percentage of columns in a matrix with multiple groups?
- How do I calculate aggregates for recursive groups in SSRS?
- How do I hide columns using parameters in SSRS?
Report Builder 2016 videos | Report Builder Pt 7.9 - Trimming and Replacing Text
Posted by Andrew Gould on 18 December 2020
This video explains how to clean up messy text that you might have imported into a report. You'll learn how to remove leading and trailing spaces using the Trim functions and how to get rid of unwanted characters using the Replace function in both Visual Basic and SQL.
See our full range of Report Builder training resources.
There are no files which go with this video.
There are no exercises for this video.
Making a video bigger
You can increase the size of your video to make it fill the screen like this:

Play your video (the icons shown won't appear until you do), then click on the full screen icon which appears as shown at its bottom right-hand corner.
When you've finished viewing a video in full screen mode, just press the Esc key to return to normal view.
Improving the quality of a video
To improve the quality of a video, first click on the Settings icon:

Make sure you're playing your video so that the icons shown appear, then click on this gear icon at the bottom right-hand corner.
Choose to change the video quality:

Click on Quality as shown to bring up the submenu.
The higher the number you choose, the better will be your video quality (but the slower the connection speed):

Don't choose the HD option unless you have a fast enough connection speed to support it!
Is your Wise Owl speaking too slowly (or too quickly)? You can also use the Settings menu above to change your playback speed.