Matrix inserting spacing in my report

The matrix in my report expands left to right and displaces the other
tables/charts in my report. I've left enough room for it to expand. Is
there a way to tell it not to push the other stuff?Try to move the items above the matrix (which get pushed to the right) into
one containing rectangle. The top/left of the rectangle has to be closer to
left page border than the matrix top/left position. Does it work then for
you?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cindy Lee" <dangreece@.hotmail.com> wrote in message
news:ubM9QFiXEHA.644@.tk2msftngp13.phx.gbl...
> The matrix in my report expands left to right and displaces the other
> tables/charts in my report. I've left enough room for it to expand. Is
> there a way to tell it not to push the other stuff?
>|||Thanks, putting it in a rectangle works great.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23HnITVkXEHA.1888@.TK2MSFTNGP11.phx.gbl...
> Try to move the items above the matrix (which get pushed to the right)
into
> one containing rectangle. The top/left of the rectangle has to be closer
to
> left page border than the matrix top/left position. Does it work then for
> you?
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Cindy Lee" <dangreece@.hotmail.com> wrote in message
> news:ubM9QFiXEHA.644@.tk2msftngp13.phx.gbl...
> > The matrix in my report expands left to right and displaces the other
> > tables/charts in my report. I've left enough room for it to expand. Is
> > there a way to tell it not to push the other stuff?
> >
> >
>

Matrix and Charts

I have a matrix report that has an embedded Pie chart on the Rows box for the
Matirx. This produces a Pie for each row that shows up on the report.
Everything shows up fine but I want to show a percent on the Pie rather than
showing the hours calculation. I have figured out how to do this for a
single pie,with some of the message boards help. e.g.
=(Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, "YRT_Proj_Cat")
However, when I try this on a matrix the percentages are very small because
it is looking at the sum of the total not the sum of the scope or rows that
should be included. Any ideas on what the formula should look like base ont
he information provided?
I have tried =(Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value,
"Vice_President")
but I get the following error: The expression for the chart â'chart2â' has a
scope parameter that is not valid for an aggregate function. The scope
parameter must be set to a string constant that is equal to either the name
of a containing group, the name of a containing data region, or the name of a
data set.
Build complete -- 1 errors, 0 warnings
This is what I have defined for the matrix:
Rows: Pie Chart (New Pie for each row)
Data: Reg_Hours (Sum of hours for each pie spread across the Proj_Cat columns)
Columns: Project_Category (Dynamic list of columns that contain the hours
for each
category)
In the pie chart I have the following:
Series Fields: Proj_Cat
Data Fields: Reg_Hours
Category Field: NothingAssuming the reportitem name of your pie chart is "Chart1", please try the
following expression for the datapoint labels:
=Fields!Reg_Hours.Value / Sum(Fields!Reg_Hours.Value, "Chart1")
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
news:9CD07032-6031-4C5F-BBBA-FE58C67CB8F5@.microsoft.com...
>I have a matrix report that has an embedded Pie chart on the Rows box for
>the
> Matirx. This produces a Pie for each row that shows up on the report.
> Everything shows up fine but I want to show a percent on the Pie rather
> than
> showing the hours calculation. I have figured out how to do this for a
> single pie,with some of the message boards help. e.g.
> =(Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, "YRT_Proj_Cat")
> However, when I try this on a matrix the percentages are very small
> because
> it is looking at the sum of the total not the sum of the scope or rows
> that
> should be included. Any ideas on what the formula should look like base
> ont
> he information provided?
> I have tried =(Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value,
> "Vice_President")
> but I get the following error: The expression for the chart 'chart2' has
> a
> scope parameter that is not valid for an aggregate function. The scope
> parameter must be set to a string constant that is equal to either the
> name
> of a containing group, the name of a containing data region, or the name
> of a
> data set.
> Build complete -- 1 errors, 0 warnings
> This is what I have defined for the matrix:
> Rows: Pie Chart (New Pie for each row)
> Data: Reg_Hours (Sum of hours for each pie spread across the Proj_Cat
> columns)
> Columns: Project_Category (Dynamic list of columns that contain the hours
> for each
> category)
> In the pie chart I have the following:
> Series Fields: Proj_Cat
> Data Fields: Reg_Hours
> Category Field: Nothing
>|||You had the formula right...I jsut missed the caps on chart1 which is case
sensitive
This worked:
=Fields!Reg_Hours.Value / Sum(Fields!Reg_Hours.Value, "chart1")
Thanks for all the help!!!
"Robert Bruckner [MSFT]" wrote:
> Assuming the reportitem name of your pie chart is "Chart1", please try the
> following expression for the datapoint labels:
> =Fields!Reg_Hours.Value / Sum(Fields!Reg_Hours.Value, "Chart1")
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> news:9CD07032-6031-4C5F-BBBA-FE58C67CB8F5@.microsoft.com...
> >I have a matrix report that has an embedded Pie chart on the Rows box for
> >the
> > Matirx. This produces a Pie for each row that shows up on the report.
> > Everything shows up fine but I want to show a percent on the Pie rather
> > than
> > showing the hours calculation. I have figured out how to do this for a
> > single pie,with some of the message boards help. e.g.
> > =(Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value, "YRT_Proj_Cat")
> >
> > However, when I try this on a matrix the percentages are very small
> > because
> > it is looking at the sum of the total not the sum of the scope or rows
> > that
> > should be included. Any ideas on what the formula should look like base
> > ont
> > he information provided?
> >
> > I have tried =(Fields!Reg_Hours.Value )/ Sum(Fields!Reg_Hours.Value,
> > "Vice_President")
> >
> > but I get the following error: The expression for the chart 'chart2' has
> > a
> > scope parameter that is not valid for an aggregate function. The scope
> > parameter must be set to a string constant that is equal to either the
> > name
> > of a containing group, the name of a containing data region, or the name
> > of a
> > data set.
> > Build complete -- 1 errors, 0 warnings
> >
> > This is what I have defined for the matrix:
> > Rows: Pie Chart (New Pie for each row)
> > Data: Reg_Hours (Sum of hours for each pie spread across the Proj_Cat
> > columns)
> > Columns: Project_Category (Dynamic list of columns that contain the hours
> > for each
> > category)
> >
> > In the pie chart I have the following:
> > Series Fields: Proj_Cat
> > Data Fields: Reg_Hours
> > Category Field: Nothing
> >
>
>