Access to Table Cells (Textboxes) Outside the Table

Hi,
I have two tables and would like to base another textbox aggregate
(outside of both tables), on the aggregate result cells from each
table. I don't think this is possible, but if anyone knows how please
let me know.
Table A (using DataSet A)
Table B (using DataSet B)
I want a textbox with an aggregate (Sum) which equals: #1) a Textbox in
Table A (which is a group aggregate) + #2) a Textbox in Table B (which
is another group aggregate).
Thanks,What you should do is set it to an expression and use the expression builder
and base it on an aggregate of the dataset aggregates. I.e. the sum of the
two sums.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Curtis" <curtis.johnstone@.gmail.com> wrote in message
news:1163719396.108142.238140@.k70g2000cwa.googlegroups.com...
> Hi,
> I have two tables and would like to base another textbox aggregate
> (outside of both tables), on the aggregate result cells from each
> table. I don't think this is possible, but if anyone knows how please
> let me know.
> Table A (using DataSet A)
> Table B (using DataSet B)
> I want a textbox with an aggregate (Sum) which equals: #1) a Textbox in
> Table A (which is a group aggregate) + #2) a Textbox in Table B (which
> is another group aggregate).
> Thanks,
>|||I re-architected my report using multiple datasets and aggregates and
query parameters. It all worked great except (for one record queries)
but there is a significant problem: For each record in dataset A, I
need to show a table based on dataset B and another table from dataset
C. I originally was using a list item for dataset A with two embedded
tables (using the other datasets). I was having difficulty and then
discovered that you cannot nest data regions that use different
datasets - doah! What is the best way to overcome that limiation? Can
you nest subreports?
The only other option I see is to get all of the data from one dataset
and use subqueries that return the aggregates.
Curtis
Bruce L-C [MVP] wrote:
> What you should do is set it to an expression and use the expression builder
> and base it on an aggregate of the dataset aggregates. I.e. the sum of the
> two sums.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Curtis" <curtis.johnstone@.gmail.com> wrote in message
> news:1163719396.108142.238140@.k70g2000cwa.googlegroups.com...
> > Hi,
> >
> > I have two tables and would like to base another textbox aggregate
> > (outside of both tables), on the aggregate result cells from each
> > table. I don't think this is possible, but if anyone knows how please
> > let me know.
> >
> > Table A (using DataSet A)
> > Table B (using DataSet B)
> >
> > I want a textbox with an aggregate (Sum) which equals: #1) a Textbox in
> > Table A (which is a group aggregate) + #2) a Textbox in Table B (which
> > is another group aggregate).
> >
> > Thanks,
> >