Multiple tables in a report?

I have 2 datasets defined and 2 tables in my report. I
want to have the results of one dataset in one table, and
the results of the other dataset in the other table. Is
there a way to specify which dataset I want the table to
use? The report designer only lets me use an aggregate (= First(Fields!name.Value, "dataset2")) in the 2nd table.
This syntax allows me to specify the dataset, but I don't
want just the first record, I want all the records. This
doesn't seem like it should be complicated. Anyone?Right click on table, go to properties, and you should see a datasetname
property. Enter the respective dataset name
"Jerrad" wrote:
> I have 2 datasets defined and 2 tables in my report. I
> want to have the results of one dataset in one table, and
> the results of the other dataset in the other table. Is
> there a way to specify which dataset I want the table to
> use? The report designer only lets me use an aggregate (=> First(Fields!name.Value, "dataset2")) in the 2nd table.
> This syntax allows me to specify the dataset, but I don't
> want just the first record, I want all the records. This
> doesn't seem like it should be complicated. Anyone?
>