Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How can I convert Excel vlookup to SSRS report?

Posted on 2015-01-20
1
Medium Priority
?
528 Views
Last Modified: 2015-01-24
Excel Vlookup table looks like this:
   Lookup    &      Return
Field Value          Value
      PP7                 7 (returned)
      PP12              12 (returned)

How can I perform a similar lookup in SSRS, maybe through a hidden table?
0
Comment
Question by:rhservan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 14

Accepted Solution

by:
nishant joshi earned 1500 total points
ID: 40561215
Hi rhservan,

First you need to create dataset for lookup. e.g "lookup".Lookup dataset should contains all fields.

For example,
SELECT LookupFieldValue,LookupReturnValue
FROM @Table

Open in new window


Your SSRS Expression whould be

=Lookup(Parameters!LookupParam.Value, Fields!LookupFieldValue.Value, Fields!LookupReturnValue.Value, "lookup")

Open in new window


Thanks,
Nishant
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Viewers will learn how the fundamental information of how to create a table.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question