Solved

How can I convert Excel vlookup to SSRS report?

Posted on 2015-01-20
1
418 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
Comment Utility
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

772 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

12 Experts available now in Live!

Get 1:1 Help Now