Tuesday, February 19, 2013 7:01 PM
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
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
Tuesday, February 19, 2013 7:04 PM
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
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
Wednesday, February 20, 2013 4:09 PMThanks