Help setting up datasets

I have a report that needs to show three different counts in the first 3
columns. This will be on a group header line. The detail for the group
needs to show the data that is used to get the third count. My report footer
needs show a sum of the three counts.
I have two different ideas on how do accomplish this but run into problems
with each. If I use two datasets I can only reference the counts in an
aggregate when my table dataset is the details. I can not (or donâ't know
how) to set an expression to get the value from a dataset where the keys are
equal. My other solution is a single dataset with the three counts included
in each row. In the group heading I can do =First(Fields!count1,value) but I
can not sum that way because I can not perform an aggregate on an aggregate.
Anyone have any ideas on this?The "easiest" (or should I say "only") way I've found to pull off
rather complex aggregation for RS is to use a stored procedure to come
up with summaries in a temp table(s), and then run my queries against
those temp table (or tables) to give me a tabular output that is as
close as possible to what my report needs to look like.
On Mar 28, 4:53 pm, simmonsj_98 <simmons...@.discussions.microsoft.com>
wrote:
> I have a report that needs to show three different counts in the first 3
> columns. This will be on a group header line. The detail for the group
> needs to show the data that is used to get the third count. My report footer
> needs show a sum of the three counts.
> I have two different ideas on how do accomplish this but run into problems
> with each. If I use two datasets I can only reference the counts in an
> aggregate when my table dataset is the details. I can not (or don't know
> how) to set an expression to get the value from a dataset where the keys are
> equal. My other solution is a single dataset with the three counts included
> in each row. In the group heading I can do =First(Fields!count1,value) but I
> can not sum that way because I can not perform an aggregate on an aggregate.
> Anyone have any ideas on this?