Multiple Datasets

I have two datasets.
I have a list with multiple tables in it to break out information.
There are two tables that I need to populate. They are using dataset 2.
THe rest of the tables are using dataset1.
How do I link the data that is pulled in dataset 1, to dataset 2?
Both datasets have the account number field in it. And when the primary
table 1 pulls the account number, I want dataset 2 to display the references
for the account number that is displayed in dataset 1?
ThankOn Jun 4, 3:36 pm, Susan R <Sus...@.discussions.microsoft.com> wrote:
> I have two datasets.
> I have a list with multiple tables in it to break out information.
> There are two tables that I need to populate. They are using dataset 2.
> THe rest of the tables are using dataset1.
> How do I link the data that is pulled in dataset 1, to dataset 2?
> Both datasets have the account number field in it. And when the primary
> table 1 pulls the account number, I want dataset 2 to display the references
> for the account number that is displayed in dataset 1?
> Thank
You should be able to achieve this via drill-through, where you pass
the account number from the main report to the drilled-through one.
Another way of accomplishing this is to use the dataset that includes
the account number as a report parameter and then reference the
parameter selected via the query/stored procedure that sources the
other table control. Assuming that the report parameter is called
AccountNum (that is linked to one dataset), you could use something
like this:
select ... from References where AccountNumber = Parameters!
AccountNum.Value
Also, you could try using Jump to URL/Report (as part of the
Navigation property of a table control, etc).
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant