Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Lookup

Answered Lookup

  • Tuesday, February 19, 2013 7:01 PM
     
     
    Sign In to Vote
    0

    Hi

    I am using SQL2008 and am new to Report writing

    I have 2 datasets:

    DataSet # 1 Admissions

    DateSet # 2 Referrals Placed

    I am trying to create a report using  patient account # in DataSet#1 and looking up in DataSet # 2 the Name of Referral Placed Provider

    I am having trouble with Lookup Syntax

    =Lookup(Fields!Admission_Account_Number.Value,Fields!Account_Number.Value,Fields!Placed_Provider_Name.Value,"Placements")

    Any auggestions would be greatly appreciated

    • Moved by David Dye Tuesday, February 19, 2013 7:03 PM Post request help with reporting services and not integration services
    •  
     

All Replies

  • Tuesday, February 19, 2013 7:04 PM
     
     
    Sign In to Vote
    0

    Since you are requesting assistance with reporting services rather than integration services I have moved your post in order to receive a more directed response.

    David Dye My Blog

     
  • Tuesday, February 19, 2013 8:21 PM
     
     Answered
    Sign In to Vote
    1

    Hi, 

    Any errors? the syntax looks correct  --- just make sure the right parameters are passed:

    Lookup(TheKeyFieldFromDataSet1, TheKeyFieldFromDataSet2, TheFieldYouWantToFetch,"TheNameofDataSet2").

    Please mark as answered or vote helpful if this post help resolved your issue. Thanks!

    k r o o t z


    • Edited by krootz Tuesday, February 19, 2013 8:22 PM
    • Proposed As Answer by Sanjeewan Kumar Wednesday, February 20, 2013 6:51 AM
    • Marked As Answer by Marymswlcsw Wednesday, February 20, 2013 4:10 PM
    •  
     
  • Wednesday, February 20, 2013 4:09 PM
     
     
    Sign In to Vote
    0
    Thanks