Linking entities in report builder by table columns that are not primary or foriegn keys.

What is the best way to join two tables by something other than there primary or foriegn keys in report builder. I actually want a relationship between two tables based on a combination of two columns.

Thanks

Dear,

Delete the relationship and join the table as per ur criteria.But the Primary and Foregin key Relation is the best to retrieve the record and applying functions. and also on criteria basis.

HTH

From

Sufian