Solved

How can I convert Excel vlookup to SSRS report?

Posted on 2015-01-20
1
429 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
1 Comment
 
LVL 14

Accepted Solution

by:
nishant joshi earned 500 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now