Home  >  Blog  >   MSBI  > 

SQL Server 2008 R2 – LookUp Enhancement in SSRS

Rating: 4
  
 
5104
  1. Share:
MSBI Articles

 

LookUp Enhancement in SSRS 2008 R2

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)

                    SSRS Overview

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.

Look up set: set of values (or) Result set relations

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

 MindMajix YouTube Channel

Multi Look Up:

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!

List of Related Microsoft Certification Courses:

 SSIS  Power BI
 SSAS  SQL Server
 SCCM  SQL Server DBA
 SharePoint  BizTalk Server
 Team Foundation Server  BizTalk Server Administrator

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
MSBI TrainingDec 06 to Dec 21
MSBI TrainingDec 10 to Dec 25
MSBI TrainingDec 13 to Dec 28
MSBI TrainingDec 17 to Jan 01
Last updated: 04 December 2022
About Author
Ravindra Savaram

Ravindra Savaram is a Content 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.

Recommended Courses

1 /15