Matrix Control pushes out Graphs on Report

I have a report with multiple graphs below each other (some bar, some line, some pie)
To the left of each graph, I have a few text boxes and tables tables displaying information about each graph to the right. (fits on A4 portait page)
For lack of being able to display a pic:
Table Graph
_______ ________________________________
| | | |
| | | |
|______ | |_______________________________|
_______ ________________________________
| | | |
| | | |
|______ | |_______________________________|
Right at the bottom of the report, just below the last table/graph combination, I have a simple matrix control.
In the preview pane, all is well, no problem. When I deploy the report to the report server, the matrix control pushes all graphs out for the entire length of the matrix.
Table Blank space Graph
_______ ________________________________
| | | |
| | | |
|______ | |_______________________________|
_______ ________________________________
| | | |
| | | |
|______ | |_______________________________|
_______________________
| |
|______________________|
Matrix /\
The only way I get the report to display correctly is when I specify that the matrix must start on a new page. Unfortunately, the customer wants all on one page.
Any ideas?As items grow vertically, they push items below them.
As they grow horizontally, they push items beside them on the page.
An easy way to prevent this is to make sure your graphs aren't considered to
be to the right of the matrix by grouping the table and graph together in a
rectangle:
--
| -- -- |
| |Table| |Graph| |
| -- -- |
--
--
|Matrix|
--
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Michelle" <Michelle@.discussions.microsoft.com> wrote in message
news:363724F0-D9EE-4BD3-9769-032E79430C6F@.microsoft.com...
> I have a report with multiple graphs below each other (some bar, some
line, some pie)
> To the left of each graph, I have a few text boxes and tables tables
displaying information about each graph to the right. (fits on A4 portait
page)
> For lack of being able to display a pic:
> Table Graph
> _______ ________________________________
> | | | |
> | | | |
> |______ | |_______________________________|
> _______ ________________________________
> | | | |
> | | | |
> |______ | |_______________________________|
>
> Right at the bottom of the report, just below the last table/graph
combination, I have a simple matrix control.
> In the preview pane, all is well, no problem. When I deploy the report to
the report server, the matrix control pushes all graphs out for the entire
length of the matrix.
> Table Blank space Graph
> _______ ________________________________
> | | |
|
> | | |
|
> |______ | |_______________________________|
> _______ ________________________________
> | | |
|
> | | |
|
> |______ | |_______________________________|
> _______________________
> | |
> |______________________|
> Matrix /\
> The only way I get the report to display correctly is when I specify that
the matrix must start on a new page. Unfortunately, the customer wants all
on one page.
> Any ideas?

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
> >
>
>