Just to be more specific:

Say I have three tables. I want to join them to display different fields from each one on a report.

Is there a way I can programatically put all these into a dataset to be linked to the ReportViewer? I found that the wizard will only let me select one table and then will set this selection in its properties. The language would be C#.