Last post Aug 16, 2013 05:21 AM by Lisa Zhang - MSFT
Aug 14, 2013 01:29 PM|anbujeremiah|LINK
Aug 15, 2013 10:37 AM|feelwang|LINK
The best way with best performance is writing your query in a dataset using JOIN in your query.
Otherwise, LOOKUP can be used to achieve the goal.
Aug 15, 2013 11:27 AM|anbujeremiah|LINK
Aug 16, 2013 05:21 AM|Lisa Zhang - MSFT|LINK
According to your description, if it could be possible to join the two dataset into one, I would suggest you please do this way. If that is not achievable due to some reason, as you know a table could link to only one dataset at a time, however if you are
using SSRS 2008 R2 you can use Lookup function to use another dataset inside your tablix.
=Lookup (Fields!Code.Value, Fields!Code.Value,Fields!meaning.Value,"Dataset2")
Where the first Fields! Code.Value is your first dataset field (such as Dataset1) and Fields! Code.Value is the field in the second dataset (such as Dataset2).
Here are useful references bellow:
# assigning two data sets to one talbe in SSRS
# How to link multiple datasets in one table - Report Builder 3.0
# Grouping multiple tables (tablix) with different datasets – SSRS 2008 R2
If you have any questions, please let me know.