Solved

How can I convert Excel vlookup to SSRS report?

Posted on 2015-01-20
1
436 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

803 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