The look up enhancement functions available in 2008 in below navigation
Go to Text book (Table) → RT click → Expression → category → common functions → miscellaneous →
Item → In scope
→ Look up
→ Look upset
→ Multi look up
Syntax:
Look up (source column, destination column, result set, data set
Look upset (source column, Destination column, Result set, data set
Multi look up (source column, Destination column, Result set, data set
Look up function usage (single value relations)
a) Create 2 data sets for emp, dept ie, EDS, DDS
b) Expression properties:
= Lookup (fields! Emp.DID, Fields! Dept. DID, Fields! Dept. D Name
O/P: EMP Table Dept Table
EID EN DID D NAME
1 X 10 IT
2 X 20 HR
If you would like to become a SSRS(SQL Server Reporting Services) certified professional, then visit Mindmajix - A Global online training platform: "SSRS Training and Certification Course". This course will help you to achieve excellence in this domain.
Eg:- For DID in Dept, mutti emp Id’s in emp
= Join (look up set (fields! Dept. DID
Fields 1 Emp. DID. Fields ! Emp.EID .”EDS” ) “,” )
o/p :- D ID D NAME E ID
10 IT 1 4 7
2 5 8
3 6 9
Generally multi lookup use at the time of multi valued the parameters because users can send multiple values.
This lookup returns based on every value, passed from the source in multi value list.
JOIN (multi look up (fields! Dept. DID, fields! emplDID, Fields! EMP.Did. “EDS”) , (“”)
Displaying different colors for text box value:
Party code textbox → press F4 → color properties → In Expression window → =Code. Getcolor (Fields! Partycode.value)
Explore SSRS Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download Now!
SSIS | Power BI |
SSAS | SQL Server |
SCCM | SQL Server DBA |
SharePoint | BizTalk Server |
Team Foundation Server | BizTalk Server Administrator |
Name | Dates | |
---|---|---|
MSBI Training | Sep 14 to Sep 29 | View Details |
MSBI Training | Sep 17 to Oct 02 | View Details |
MSBI Training | Sep 21 to Oct 06 | View Details |
MSBI Training | Sep 24 to Oct 09 | View Details |
Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.