>I can see how that works and yes the subreports are a lot easier to manage but if I want to place a single table on the report with information coming from three database tables to display in this single table, is this actually possible?
>
>From what I've tried if I try to mix up the fields in the table to show different database columns I get:
>
>"The Value expression for the textbox ‘x’ refers to the field ‘y’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope."
>
>Of course this is because I have a certain single table dataset linked to this table, it won't allow me to add the whole dataset and if I try to remove it:
>
>"The data set name is missing in the data region ‘DataSetName’."

In the report designer, click on the table (the grid) and click Properties. You should now see the follow tabs:

General
Visibility
Navigation
Sorting
Groups
Filters
Data Output

In the general tab, select your dataset for 'Dataset name: '
In the sorting tab, set up the expressions for sorting your data.
In the Groups tab, set up a data group on the parent id (key) that the child records are linked on (e.g. =Fields!Parent_id.Value) You can name it anything (default is table number and group number). Set the parent group by selecting it from the dropdown.

Then, after your table is configured correctly on the report designer, click in the colum you want to configure and point to the correct child table field.

I recommend you walk through some tutorials. Here is a good one to get you started:

http://www.gotreportviewer.com/masterdetail/index.html

it covers one way to get it done (there are a few different ways). The website is a great beginner lesson:

http://www.gotreportviewer.com/