How to format measure descriptions -- sql server reporting services

Daniel Edwards
12/2/2004 5:45:05 PM

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?

brickmouse
12/3/2004 4:46:23 PM

Try Using Padding ?

[quoted text, click to view]

sql server reporting services : How to format measure descriptions