Hey all
I hope one of you encountered this problem..
I have grouped fields on one table object in some report.
In visual studio all is well i can expand the grouping fields to see thier
children and thier data.
The problem appears in internet explorer - under no sircumstances will this
group expand there!
I am left with the upper most grouping field and can not drill down to its
members!
I have tried both to define these aggregating fields by my self
and by the vs wizard . Also i tried the matrix component instead of the
table one.
One interesting fact is that once exported to excell, things return to
normal again..
I can expand groups and drill down correctly.
I have installed sp1 for reporting services and use ie6 on winxp
professional (both client and server).
If you did not encounter this before where will you start looking'
Thanks for your attention
ReaThe driil down capability requires Session cookies be enabled. Change the
Internet Explorer setting to "Allow Session Cookies" and it should work
"Rea Peleg" <rea_p@.afek.co.il> wrote in message
news:uQfy2B8bEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Hey all
> I hope one of you encountered this problem..
> I have grouped fields on one table object in some report.
> In visual studio all is well i can expand the grouping fields to see thier
> children and thier data.
> The problem appears in internet explorer - under no sircumstances will
this
> group expand there!
> I am left with the upper most grouping field and can not drill down to its
> members!
> I have tried both to define these aggregating fields by my self
> and by the vs wizard . Also i tried the matrix component instead of the
> table one.
> One interesting fact is that once exported to excell, things return to
> normal again..
> I can expand groups and drill down correctly.
> I have installed sp1 for reporting services and use ie6 on winxp
> professional (both client and server).
> If you did not encounter this before where will you start looking'
> Thanks for your attention
> Rea
>
>
Showing posts with label grouped. Show all posts
Showing posts with label grouped. Show all posts
Tuesday, March 27, 2012
Thursday, March 8, 2012
Can I use two different datsets in list
I created an list in that we placed an matrix and i ma using one dataset for
all of it anf grouped the list with one id called org name.
Now for each org we have answers associated and its an different dataset wen
i try to insert it. It provides errors.
As we got grouping in it and in grouping when we use other data set
information it gives as First(Field!xyz.value,datsetname) which gives
aggregate function exception or error.
How do we resolve it.Issue resolved by sub report.
"NAVIN.D" wrote:
> I created an list in that we placed an matrix and i ma using one dataset for
> all of it anf grouped the list with one id called org name.
> Now for each org we have answers associated and its an different dataset wen
> i try to insert it. It provides errors.
> As we got grouping in it and in grouping when we use other data set
> information it gives as First(Field!xyz.value,datsetname) which gives
> aggregate function exception or error.
> How do we resolve it.
all of it anf grouped the list with one id called org name.
Now for each org we have answers associated and its an different dataset wen
i try to insert it. It provides errors.
As we got grouping in it and in grouping when we use other data set
information it gives as First(Field!xyz.value,datsetname) which gives
aggregate function exception or error.
How do we resolve it.Issue resolved by sub report.
"NAVIN.D" wrote:
> I created an list in that we placed an matrix and i ma using one dataset for
> all of it anf grouped the list with one id called org name.
> Now for each org we have answers associated and its an different dataset wen
> i try to insert it. It provides errors.
> As we got grouping in it and in grouping when we use other data set
> information it gives as First(Field!xyz.value,datsetname) which gives
> aggregate function exception or error.
> How do we resolve it.
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
>
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
>
Subscribe to:
Posts (Atom)