• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

lookup function SSRS

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
vbnetcoder
Asked:
vbnetcoder
1 Solution
 
DcpKingCommented:
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
 
vbnetcoderAuthor Commented:
ty
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now