If another table is required e.g. a Lookup Table, this can be added to the existing report.
1.Right click on sqlDataSource1 under Report Explorer
2.Select Manage Queries…
3.Click Add
4.Click Run Query Builder
5.Locate and double click on the Table e.g. Tbl_Sourcecode
6.Click into the boxes beside the fields required eg Sourcecode
7.Enter an Alias name eg Source
8.Click OK
9.Click Finish
10.Click OK