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
>

How to fit table on one page

Hello, I have a report that displays about 200 data records. There is no any
group or subtotal in the report, but just plain data. It is built in a
table. The report always generates two pages when it is ran, even though I
checked "fit table on one page if possible" box on the properties of the
table. How can I set up the report to display the 200 records on one page?
Thanks in advance!Hi Jean,
You can change the Page Height property in the Report Properies dialogue to
a larger number to fit the rows. This is true if you are rendering the
report in HTML.
--
Rodney Landrum - Author, "Pro SQL Server Reporting Services" (Apress)
(http://www.apress.com/book/bookDisplay.html?bID=365)
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:F077EAB2-1B32-49FD-A81F-098E5B37034D@.microsoft.com...
> Hello, I have a report that displays about 200 data records. There is no
> any
> group or subtotal in the report, but just plain data. It is built in a
> table. The report always generates two pages when it is ran, even though I
> checked "fit table on one page if possible" box on the properties of the
> table. How can I set up the report to display the 200 records on one page?
> Thanks in advance!
>|||Hi Hean,
You can increase the size of your Page Height Property in Report
Properties/Layout tab. This should work if you are rendering in HTML.
--
Rodney Landrum
Author, "Pro SQL Server Reporting Services" (Apress)
http://www.apress.com
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:F077EAB2-1B32-49FD-A81F-098E5B37034D@.microsoft.com...
> Hello, I have a report that displays about 200 data records. There is no
> any
> group or subtotal in the report, but just plain data. It is built in a
> table. The report always generates two pages when it is ran, even though I
> checked "fit table on one page if possible" box on the properties of the
> table. How can I set up the report to display the 200 records on one page?
> Thanks in advance!
>|||Sorry, I meant Jean. :)
Rodney
"Jean" <Jean@.discussions.microsoft.com> wrote in message
news:F077EAB2-1B32-49FD-A81F-098E5B37034D@.microsoft.com...
> Hello, I have a report that displays about 200 data records. There is no
> any
> group or subtotal in the report, but just plain data. It is built in a
> table. The report always generates two pages when it is ran, even though I
> checked "fit table on one page if possible" box on the properties of the
> table. How can I set up the report to display the 200 records on one page?
> Thanks in advance!
>|||Rodney,
It works! Thanks a lot!
Jean
"Rodney Landrum" wrote:
> Sorry, I meant Jean. :)
> Rodney
> "Jean" <Jean@.discussions.microsoft.com> wrote in message
> news:F077EAB2-1B32-49FD-A81F-098E5B37034D@.microsoft.com...
> > Hello, I have a report that displays about 200 data records. There is no
> > any
> > group or subtotal in the report, but just plain data. It is built in a
> > table. The report always generates two pages when it is ran, even though I
> > checked "fit table on one page if possible" box on the properties of the
> > table. How can I set up the report to display the 200 records on one page?
> >
> > Thanks in advance!
> >
>
>sql