SSRS Report Builder Part 7.12 - Lookup, LookupSet and MultiLookup Functions
19.9 هزار بار بازدید -
4 سال پیش
-
By Andrew GouldDownload files here
By Andrew Gould
Download files here https://www.wiseowl.co.uk/report-buil...
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Chapters
00:00 Topic List
01:04 The Basic Report
03:22 Creating a Lookup Table Dataset
05:01 The Lookup Function
08:58 Converting Data Types
10:38 Looking Up Director Names
13:34 Checking if a Value was Returned
16:02 Returning Multiple Values
17:24 The LookupSet Function
19:43 Joining the Contents of an Array
22:08 Testing the Length of an Array
25:27 Looking up Multiple Values
26:55 The MultiLookup Function
https://www.wiseowl.co.uk - This video explains how to use the Lookup, LookupSet and MultiLookup functions in Report Builder. You'll learn how to lookup values across different datasets, how to return multiple values to an array and how to join them into a single value. The final part of the video shows you how to lookup multiple values from a single field using the MultiLookup and Split functions.
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, VBA, Power BI, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more
Download files here https://www.wiseowl.co.uk/report-buil...
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Chapters
00:00 Topic List
01:04 The Basic Report
03:22 Creating a Lookup Table Dataset
05:01 The Lookup Function
08:58 Converting Data Types
10:38 Looking Up Director Names
13:34 Checking if a Value was Returned
16:02 Returning Multiple Values
17:24 The LookupSet Function
19:43 Joining the Contents of an Array
22:08 Testing the Length of an Array
25:27 Looking up Multiple Values
26:55 The MultiLookup Function
https://www.wiseowl.co.uk - This video explains how to use the Lookup, LookupSet and MultiLookup functions in Report Builder. You'll learn how to lookup values across different datasets, how to return multiple values to an array and how to join them into a single value. The final part of the video shows you how to lookup multiple values from a single field using the MultiLookup and Split functions.
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, VBA, Power BI, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more
4 سال پیش
در تاریخ 1399/10/02 منتشر شده
است.
19,988
بـار بازدید شده