Reference Sub-Report Value on Main Report

I have values on 2 Sub- Reports that I need to do reference on the main
report to do a particular calculation.
I was wondering if there is anyway that I can reference the sub-report
values from the main-report without making a specific call to the database
just to obtain the one value that I need.
--
L Anthony JohnsonSometimes what you can do is reference first( )of the dataset. Doesn't
always work it depends on where you are doing it.
=first(Fields!fieldname.Value,"datasetname")
of course, if you want something besides the first value then this will not
work for you.
Bruce L-C
"L Anthony Johnson" <ppsyco2@.nospamm4m3bellsouth.net> wrote in message
news:%23uxZCGGZEHA.3480@.TK2MSFTNGP11.phx.gbl...
> I have values on 2 Sub- Reports that I need to do reference on the main
> report to do a particular calculation.
> I was wondering if there is anyway that I can reference the sub-report
> values from the main-report without making a specific call to the database
> just to obtain the one value that I need.
> --
> L Anthony Johnson
>|||The Sub-Reports have their own datasets.
How would I reference the sub-reports dataset in the main report?
Landry
--
L Anthony Johnson
Newbie
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23sDUjtGZEHA.3432@.TK2MSFTNGP10.phx.gbl...
> Sometimes what you can do is reference first( )of the dataset. Doesn't
> always work it depends on where you are doing it.
> =first(Fields!fieldname.Value,"datasetname")
> of course, if you want something besides the first value then this will
not
> work for you.
> Bruce L-C
> "L Anthony Johnson" <ppsyco2@.nospamm4m3bellsouth.net> wrote in message
> news:%23uxZCGGZEHA.3480@.TK2MSFTNGP11.phx.gbl...
> > I have values on 2 Sub- Reports that I need to do reference on the main
> > report to do a particular calculation.
> >
> > I was wondering if there is anyway that I can reference the sub-report
> > values from the main-report without making a specific call to the
database
> > just to obtain the one value that I need.
> >
> > --
> > L Anthony Johnson
> >
> >
>|||This is a good question, as I have the same problem. Does anyone know how
to access a data/value in a subreport?
"L Anthony Johnson" <ppsyco2@.nospamm4m3bellsouth.net> wrote in message
news:OD#gfZPZEHA.1980@.TK2MSFTNGP09.phx.gbl...
>
> The Sub-Reports have their own datasets.
> How would I reference the sub-reports dataset in the main report?
> Landry
> --
> L Anthony Johnson
> Newbie
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23sDUjtGZEHA.3432@.TK2MSFTNGP10.phx.gbl...
> > Sometimes what you can do is reference first( )of the dataset. Doesn't
> > always work it depends on where you are doing it.
> > =first(Fields!fieldname.Value,"datasetname")
> >
> > of course, if you want something besides the first value then this will
> not
> > work for you.
> >
> > Bruce L-C
> >
> > "L Anthony Johnson" <ppsyco2@.nospamm4m3bellsouth.net> wrote in message
> > news:%23uxZCGGZEHA.3480@.TK2MSFTNGP11.phx.gbl...
> > > I have values on 2 Sub- Reports that I need to do reference on the
main
> > > report to do a particular calculation.
> > >
> > > I was wondering if there is anyway that I can reference the sub-report
> > > values from the main-report without making a specific call to the
> database
> > > just to obtain the one value that I need.
> > >
> > > --
> > > L Anthony Johnson
> > >
> > >
> >
> >
>