"Eric" <Eric@discussions.microsoft.com> wrote in message
news:B5D38CBB-41B4-4C82-A60C-F9CFD01F55ED@microsoft.com...
> I'm trying to input data from a second dataset into a table. The Edit
> tool
> only gives me First(Fields!Name.Value, "DataSet2"). How do I remove the
> "First" and just get the actual value with the correct Dataset? Sorry if
> this is a stupid question. Thanks.

"Eric" wrote:

> Thanks, I'll just create a subreport.
>
> "Jeff A. Stucker" wrote:
>
> > Are you trying to link the values of the datasets together, so that DataSet1
> > driving the table references some values in DataSet2? You can't really
> > merge two different data sets in the same report table. So there are 2 ways
> > to work around this: either join your two sets of data in your source
> > query, or put the second data in a subreport and link the "outer" value in
> > the report table to the "inner" value in the subreport which could be
> > dropped onto a table cell. If you can do the former, I'd suggest that.
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > "Eric" <Eric@discussions.microsoft.com> wrote in message
> > news:B5D38CBB-41B4-4C82-A60C-F9CFD01F55ED@microsoft.com...
> > > I'm trying to input data from a second dataset into a table. The Edit
> > > tool
> > > only gives me First(Fields!Name.Value, "DataSet2"). How do I remove the
> > > "First" and just get the actual value with the correct Dataset? Sorry if
> > > this is a stupid question. Thanks.
> >
> >