sql server reporting services: Aligning Matrices in a report -- sql server reporting services

You're in the

sql server reporting services

group:

Aligning Matrices in a report

Jsarna
12/28/2005 2:01:37 PM

sql server reporting services:

I have a report that requires 3 matrices side by side, each with
different datasets. The rows are the same in each. I have set all the
properties of the cells to be the same, but the 3 don't line up, I lose
some space each row so that the bottom cells don't line up across the
page.

Any idea what the problem may be? They all have the same row grouping
and subtotals.

This is in RS 2000.

Joe

Re: Aligning Matrices in a report

Sorcerdon
12/29/2005 7:21:32 AM

Joe,

Do they NOT line up - meaning the whole matrix? or the results?
if its the results:
1) Try setting the Automatic Resize OFF in the Cell options.
or
2) make sure all the cell properties are the same.

regards,

Stas K.

Re: Aligning Matrices in a report

Sorcerdon
12/29/2005 7:38:49 AM

Ok I just reread your problem and relized that really wouldn't help.
Perhaps making all the columns wider making all the content 1 liners
help?

regards,

Stas K.

RE: Aligning Matrices in a report

scantcircle
12/29/2005 9:40:02 AM

Are the 3 matrices contained in a rectangle object? The rectangle should
help in lining up multiple objects. You could also try placing the matrices
in a list based on the same group. Then wrap the 3 matrices in a rectangle
and nest it in the list object.

--
Regards,

scantcircle

[quoted text, click to view]

Re: Aligning Matrices in a report

Jsarna
12/29/2005 1:00:16 PM

After closer looking at the output, it appears that the height of the
subtotal of the first grouping is slightly larger than the subtotal in
the other matrix. Since there are a few subtotals in the page, it
throws off the alignment. I cannot find any place to set the padding
or borders for the subtotal rows created. I clicked on the green
arrows and set the values there to the same, but that does not seem to
help.

Joe

Re: Aligning Matrices in a report

Jsarna
12/29/2005 1:11:23 PM

Strange that it exports fine to both PDF and Excel, so it is a
rendering issue.

Joe

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn