Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

lookup function SSRS

Posted on 2012-08-25
2
Medium Priority
?
477 Views
Last Modified: 2012-08-29
Is it possible use the lookup function to search the second dataset by more then one field?

For example: I want to return a field where fielda = something fieldb= something and fieldc = something.
0
Comment
Question by:vbnetcoder
2 Comments
 
LVL 16

Accepted Solution

by:
DcpKing earned 2000 total points
ID: 38332831
It does not appear so (ref: http://msdn.microsoft.com/en-us/library/ee210531.aspx).
You could try creating a new dataset containing the results of the expression you want to use (use a stored procedure to provide the data if it's complex) and refer into that ...

hth

Mike
0
 

Author Closing Comment

by:vbnetcoder
ID: 38346848
ty
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

810 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