How to format measure descriptions

When using a matrix in Reporting Services to design a
report based on a cube, you are presented with a detail
column for your measure and a column to the left of that
for the description of the measure. My report has several
rows of measures that present (for example) both units
and dollars. I want to be able to leave a blank line
between the units section and the dollars section. I also
want to be able to place a heading for each section. The
preference is that the heading be off to the left rather
than above -- but i am not able to add a second
description column. So I placed text in the description
column to simulate the desired formatting.
For example:
Units Prod1
Prod2
Prod3
Total
Sales Prod1
Prod2
Prod3
Total
This approach looks fine in the designer. But when i
publish the report and view it in IE, all extra spaces
are gone (both horizontally and vertically) so the
descriptions look as below:
Units Prod1
Prod2
Prod3
Total
Sales Prod1
Prod2
Prod3
Total
Any suggestions on how to get a better presentation of
the descriptions?Try Using Padding ?
"Daniel Edwards" <DanielEdwards@.discussions.microsoft.com> wrote in message
news:A5663DB5-D5DD-4132-AEA5-A9D19EDFE713@.microsoft.com...
> When using a matrix in Reporting Services to design a
> report based on a cube, you are presented with a detail
> column for your measure and a column to the left of that
> for the description of the measure. My report has several
> rows of measures that present (for example) both units
> and dollars. I want to be able to leave a blank line
> between the units section and the dollars section. I also
> want to be able to place a heading for each section. The
> preference is that the heading be off to the left rather
> than above -- but i am not able to add a second
> description column. So I placed text in the description
> column to simulate the desired formatting.
> For example:
> Units Prod1
> Prod2
> Prod3
> Total
> Sales Prod1
> Prod2
> Prod3
> Total
> This approach looks fine in the designer. But when i
> publish the report and view it in IE, all extra spaces
> are gone (both horizontally and vertically) so the
> descriptions look as below:
> Units Prod1
> Prod2
> Prod3
> Total
> Sales Prod1
> Prod2
> Prod3
> Total
> Any suggestions on how to get a better presentation of
> the descriptions?
>

How to format a Matrix Subtotal

I have built my matrix and am trying to polish it for distribution, but am
having trouble with formatting when using subtotals. The matrix is
structured as follows.
Jan Feb Mar ...... Total
State Year1 10 8 15 ..... 117
Year2 9 11 18 ..... 124
What i need to do is place a vertical border seperating the monthly data
from the annual total. If I place the border on the right of the data column
in layout view, the border appears on all data columns. The subtotal, as
created by RS, only allows me to format the Header, not the value. In fact,
I have no access to the value.
The other formatting task i need to do is place a border after the state
group only, across the entire page. If I select the group, only the group
header is underlined. If i select the row, every data row is underlined.
The end result should be close to this.
Jan Feb Mar ...... Total
______________________________________
State Year1 | 10 8 15 ..... | 117
Year2 | 9 11 18 ..... | 124
______________________________________
Thanks in advance for your help,
GregThe BorderStyle>Right property can be set to an expression. Try something
like (depending on your data):
=iif(Fields!MyMonth.Value = "December", "Solid", "None")
this should put a border on the right only when the month cell value is
December.
For your second formatting requirement, suppose the outer group including
states is Country, you can use the BorderStyle>Bottom expression to put a
bottom border on the last state in the Country group. Here is one such
possible expression:
=iif(Fields!State.Value = Last(Fields!State.Value, "Country"), "Solid",
"None")
You can find out the name of the group containing the state group from the
properties of the matrix. Remember that the scope parameter is case sensitive.
In the expression above you are saying: If this state is the last one in its
country group, have a Solid border, otherwise no border. Put this expression
in the BorderStyle's Bottom property.
Charles Kangai, MCDBA, MCT
"GregRoberts" wrote:
> I have built my matrix and am trying to polish it for distribution, but am
> having trouble with formatting when using subtotals. The matrix is
> structured as follows.
> Jan Feb Mar ...... Total
> State Year1 10 8 15 ..... 117
> Year2 9 11 18 ..... 124
> What i need to do is place a vertical border seperating the monthly data
> from the annual total. If I place the border on the right of the data column
> in layout view, the border appears on all data columns. The subtotal, as
> created by RS, only allows me to format the Header, not the value. In fact,
> I have no access to the value.
> The other formatting task i need to do is place a border after the state
> group only, across the entire page. If I select the group, only the group
> header is underlined. If i select the row, every data row is underlined.
> The end result should be close to this.
> Jan Feb Mar ...... Total
> ______________________________________
> State Year1 | 10 8 15 ..... | 117
> Year2 | 9 11 18 ..... | 124
> ______________________________________
> Thanks in advance for your help,
> Greg
>|||Right click the green triangle in the upper right corner of the Total column
and choose properties.
"GregRoberts" wrote:
> I have built my matrix and am trying to polish it for distribution, but am
> having trouble with formatting when using subtotals. The matrix is
> structured as follows.
> Jan Feb Mar ...... Total
> State Year1 10 8 15 ..... 117
> Year2 9 11 18 ..... 124
> What i need to do is place a vertical border seperating the monthly data
> from the annual total. If I place the border on the right of the data column
> in layout view, the border appears on all data columns. The subtotal, as
> created by RS, only allows me to format the Header, not the value. In fact,
> I have no access to the value.
> The other formatting task i need to do is place a border after the state
> group only, across the entire page. If I select the group, only the group
> header is underlined. If i select the row, every data row is underlined.
> The end result should be close to this.
> Jan Feb Mar ...... Total
> ______________________________________
> State Year1 | 10 8 15 ..... | 117
> Year2 | 9 11 18 ..... | 124
> ______________________________________
> Thanks in advance for your help,
> Greg
>