title: How to combine two Datasources in SSRS
body: <p>my report have two different Dataset(Dataset1 and Dataset2) both is connected  to different Data sources . Field Name is derived from Dataset1 and ID is derived  from Dataset2.I want to display the Name in textbox based on the ID derived  from Dataset2.Can anyone please suggest best option other than linked server.</p>