Sunday, February 12, 2012

Can I pass parameters from list to chart?

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 MunLeeuwI 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
>|||Solution: Reworked child dataset to include fields from parent, then use
grouping in parent.
"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
>

No comments:

Post a Comment