Prev: Report Manager access: localhost vs 127.0.0.1
Next: ReportViewer - Calendar input type field for date parameter
From: Kerry on 30 Mar 2010 13:37
questions about chart titles. I'm creating a pie chart showing hours by
worktype( dev, maint, etc). At the highest level is the entire org, under
that, departments. chart defined as values = sum of hours. Category group =
worktype. (All the values are being rerported correctly in the pie charts.)

I created a table with the entire org as group 1, and the departments as
group 2.
I have a pie chart defined in the table group 1 header, and one defined in
the group 2 header. Group 1 is the entire org, so the title on the chart is a
constant( no problem). I want the group 2 header pie chart(departments) title
to be the department filed names that I'm grouping on in the table. Whenever
i try to use an expression with the department name
=fields(departmentname,value), I get the old "expressions can only refer to
fields within the current data scope" message.

I'm assuming this is because, upto now, I haven't defined department field
name in the chart, only in the table group 2. Any suggestions? Am I going
down the wrong path?

thanks for you help, in advance.
From: Jen on 31 Mar 2010 11:41
I think you just need to give the field a scope. Try something like
=(Fields!departmentname.Value, "Group 2")

On Mar 30, 1:37 pm, Kerry <Ke...(a)discussions.microsoft.com> wrote:
> questions about chart titles. I'm creating a pie chart showing hours by
> worktype( dev, maint, etc). At the highest level is the entire org, under
> that, departments. chart defined as values = sum of hours. Category group =
> worktype. (All the values are being rerported correctly in the pie charts..)
>
> I created a table with the entire org as group 1, and the departments as
> group 2.
> I have a pie chart defined in the table group 1 header, and one defined in
> the group 2 header. Group 1 is the entire org, so the title on the chart is a
> constant( no problem). I want the group 2 header pie chart(departments) title
> to be the department filed names that I'm grouping on in the table. Whenever
> i try to use an expression with the department name
> =fields(departmentname,value), I get the old "expressions can only refer to
> fields within the current data scope" message.
>
> I'm assuming this is because, upto now, I haven't defined department field
> name in the chart, only in the table group 2.  Any suggestions? Am I going
> down the wrong path?
>
> thanks for you help, in advance.

From: Kerry on 31 Mar 2010 14:58
Thanks for the try, but no prgress. same error. I tried using the dataset
name too, but that returned the error also. Any other suggestions,

"Jen" wrote:

> I think you just need to give the field a scope. Try something like
> =(Fields!departmentname.Value, "Group 2")
>
> On Mar 30, 1:37 pm, Kerry <Ke...(a)discussions.microsoft.com> wrote:
> > questions about chart titles. I'm creating a pie chart showing hours by
> > worktype( dev, maint, etc). At the highest level is the entire org, under
> > that, departments. chart defined as values = sum of hours. Category group =
> > worktype. (All the values are being rerported correctly in the pie charts..)
> >
> > I created a table with the entire org as group 1, and the departments as
> > group 2.
> > I have a pie chart defined in the table group 1 header, and one defined in
> > the group 2 header. Group 1 is the entire org, so the title on the chart is a
> > constant( no problem). I want the group 2 header pie chart(departments) title
> > to be the department filed names that I'm grouping on in the table. Whenever
> > i try to use an expression with the department name
> > =fields(departmentname,value), I get the old "expressions can only refer to
> > fields within the current data scope" message.
> >
> > I'm assuming this is because, upto now, I haven't defined department field
> > name in the chart, only in the table group 2. Any suggestions? Am I going
> > down the wrong path?
> >
> > thanks for you help, in advance.
>
> .
>
From: Jen on 5 Apr 2010 14:14
=First(Fields!departmentname.Value, "Group2")


On Mar 31, 2:58 pm, Kerry <Ke...(a)discussions.microsoft.com> wrote:
> Thanks for the try, but no prgress. same error. I tried using the dataset
> name too, but that returned the error also. Any other suggestions,
>
>
>
> "Jen" wrote:
> > I think you just need to give the field a scope. Try something like
> > =(Fields!departmentname.Value, "Group 2")
>
> > On Mar 30, 1:37 pm, Kerry <Ke...(a)discussions.microsoft.com> wrote:
> > > questions about chart titles. I'm creating a pie chart showing hours by
> > > worktype( dev, maint, etc). At the highest level is the entire org, under
> > > that, departments. chart defined as values = sum of hours. Category group =
> > > worktype. (All the values are being rerported correctly in the pie charts..)
>
> > > I created a table with the entire org as group 1, and the departments as
> > > group 2.
> > > I have a pie chart defined in the table group 1 header, and one defined in
> > > the group 2 header. Group 1 is the entire org, so the title on the chart is a
> > > constant( no problem). I want the group 2 header pie chart(departments) title
> > > to be the department filed names that I'm grouping on in the table. Whenever
> > > i try to use an expression with the department name
> > > =fields(departmentname,value), I get the old "expressions can only refer to
> > > fields within the current data scope" message.
>
> > > I'm assuming this is because, upto now, I haven't defined department field
> > > name in the chart, only in the table group 2.  Any suggestions? Am I going
> > > down the wrong path?
>
> > > thanks for you help, in advance.
>
> > .- Hide quoted text -
>
> - Show quoted text -

 | 
Pages: 1
Prev: Report Manager access: localhost vs 127.0.0.1
Next: ReportViewer - Calendar input type field for date parameter