Hi

i have a forign key in the table and i want to print the it's value the the related table instead of printing the forign key how?

thanks in advance.

Hi,

As far as I understand your task, you need to create a master-detail report, based on the relation of these tables. You can use the following approach: How to: Create a Master-Detail Report using Detail Report Bands.

After you create a relation between your tables (Master and Detal), so that a Master table's primary key will be linked to a foreign key of its descendant table, make sure you have set the DetailReport.DataMember property using the relation itself, rather than a Detail table's name. Hope this helps you.