"Steve MunLeeuw" <smunson@clearwire.net> wrote in message
news:ex0YWYGIGHA.3144@TK2MSFTNGP10.phx.gbl...
>I have a list that is grouped on OrganizationID. Inside the list is a
>chart that uses a different dataset. The chart dataset should be passed
>the OrganizationID from the list grouping. I''ve tried a few different
>things, but always end up with build errors, such as:
> Error 1 [rsAggregateInGroupExpression] A group expression for the chart
> 'chart1' includes an aggregate function. Aggregate functions cannot be
> used in group expressions. C:\Projects\AAC.SchoolPlan\2006\SchoolPlan
> Reports\SchoolPlan Reports\schoolplan reports\cat6_nosubreport.rdl 0 0
> When I look at the Expression editor in the chart, the selected dataset in
> the metadata is from the list, but the chart dataset is dsChart. I tried
> to add the dataset identifier, but when I do this I'm forced into using an
> aggregate function.
> Do the data for the list and the chart need to come from the same dataset?
>
> Background:
> I was using a subreport for this, but we switched to the Dundas for RS
> charting, and MS has an issue where only the last chart is rendered. It's
> my understanding that this is due to an issue in SSRS 2005 with the custom
> control interfaces when accessed in a subreport controlled by a list.
> Word on the street is that it should be fixed in SSRS 2005 SP1.
>
> Thanks,
> Steve MunLeeuw
>

"Steve MunLeeuw" <smunson@clearwire.net> wrote in message
news:ufwelhGIGHA.344@TK2MSFTNGP11.phx.gbl...
>I may need to use subreport and wait for sp1. Read: "
> Re: Loopig Each Record in dataset"
>
>
>
> "Steve MunLeeuw" <smunson@clearwire.net> wrote in message
> news:ex0YWYGIGHA.3144@TK2MSFTNGP10.phx.gbl...
>>I have a list that is grouped on OrganizationID. Inside the list is a
>>chart that uses a different dataset. The chart dataset should be passed
>>the OrganizationID from the list grouping. I''ve tried a few different
>>things, but always end up with build errors, such as:
>> Error 1 [rsAggregateInGroupExpression] A group expression for the chart
>> 'chart1' includes an aggregate function. Aggregate functions cannot be
>> used in group expressions. C:\Projects\AAC.SchoolPlan\2006\SchoolPlan
>> Reports\SchoolPlan Reports\schoolplan reports\cat6_nosubreport.rdl 0 0
>> When I look at the Expression editor in the chart, the selected dataset
>> in the metadata is from the list, but the chart dataset is dsChart. I
>> tried to add the dataset identifier, but when I do this I'm forced into
>> using an aggregate function.
>> Do the data for the list and the chart need to come from the same
>> dataset?
>>
>> Background:
>> I was using a subreport for this, but we switched to the Dundas for RS
>> charting, and MS has an issue where only the last chart is rendered.
>> It's my understanding that this is due to an issue in SSRS 2005 with the
>> custom control interfaces when accessed in a subreport controlled by a
>> list. Word on the street is that it should be fixed in SSRS 2005 SP1.
>>
>> Thanks,
>> Steve MunLeeuw
>>
>
>