BY CATEGORY▼
- VIDEOS HOME PAGE
- .NET (14)
- Business Intelligence (40)
- Integration Services (19)
- Macros and Programming (81)
- Microsoft Excel (63)
- Microsoft Office (85)
- Miscellaneous (1)
- Power BI (32)
- Python (29)
- Report Builder (107)
- Reporting Services (113)
- SQL (42)
- Visual Basic for Applications (212)
- 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 4.4 - Importing Datasets from SQL Query Files
Posted by Andrew Gould on 24 December 2020
This video explains how to import an SQL query file to create a dataset in a Report Builder report. You'll learn how to import a query into a dataset, as well as how to create your own queries using either a simple text editor such as Notepad, or a more sophisticated application like SQL Server Management Studio.
See our full range of Report Builder training resources.
This video has the following accompanying files:
| File name | Type | Description |
|---|---|---|
| Oscar Winning Films.sql | SQL query |
Click to download a zipped copy of the above files.
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.