Screen Shot 2018-06-20 at 3.04.50 PM
Editing of relations is done using the Relations Editor, access using the relations button on the menu bar. By default, all foreign keys are imported into this menu, so unless your database is poorly setup or you have some odd relations to do, you shouldn't need to enter this menu.

Once you have a relation setup, Report Studio will automatically fill in the relations between two or more fields for you. If we go to our Invoice example from Grouping, we can see our Break band have the invoice date and then two Customer fields. If you look at the above relation editor, you'll see that Invoice.CustomerId is linked to Customer.CustomerId, and as such, Report Studio automatically fetches the correct customer data and the correct fields for us.
Pasted Graphic