Multiple datasets

I have an area of my report that needs multiple data sets to be used to
populate the area. I keep getting the error "Report item expressions can only
refer to fields wtihin the current data set scope". Does anyone know how to
make the area allow me to use one data set in one row and one in data set in
the other? I have tried a table within a table, a list within a table....I
cannot find the fix to this problem. Please help!Have a look at subreports.
"KimB" <KimB@.discussions.microsoft.com> wrote in message
news:C6D864D3-BED0-48D2-BB39-C4C642A2B9C0@.microsoft.com...
> I have an area of my report that needs multiple data sets to be used to
> populate the area. I keep getting the error "Report item expressions can
only
> refer to fields wtihin the current data set scope". Does anyone know how
to
> make the area allow me to use one data set in one row and one in data set
in
> the other? I have tried a table within a table, a list within a
table....I
> cannot find the fix to this problem. Please help!|||Thank you. I will try.
"AshVsAOD" wrote:
> Have a look at subreports.
> "KimB" <KimB@.discussions.microsoft.com> wrote in message
> news:C6D864D3-BED0-48D2-BB39-C4C642A2B9C0@.microsoft.com...
> > I have an area of my report that needs multiple data sets to be used to
> > populate the area. I keep getting the error "Report item expressions can
> only
> > refer to fields wtihin the current data set scope". Does anyone know how
> to
> > make the area allow me to use one data set in one row and one in data set
> in
> > the other? I have tried a table within a table, a list within a
> table....I
> > cannot find the fix to this problem. Please help!
>
>

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