Forcing Alignment of 2 Matrix Report Items 1

[arrowhouse]

I'm newbie to Reporting Server. I have 2 Matrix report items on my report, side by side horizontally. I know that these will always have the same number of rows & I want to make the rows across these two items line up.

In the design window they do because they are snapped to the grid & you only see the outline. However because the headers are bigger in one of the reports than the other, when I preview the report the rows do not allign.

Can & how do I do this?

Thanks for any suggestions. `

 

[xlbo]

with great difficulty - I have spent hours int eh past trying to do stuff like this and tbh, the best way to do it (if possible is change your data so that you can do the lot in 1 matrix

If that's not possible, make the header row on both matrices big enough vertically to accomodate the largest possible title (if it is not titles but row entries causing the problem, do the same with the height of the rows

Even then, you may still run into issues if you have any groups set.....other thing to make sure is that you have the CanGrow property of all cells set to false

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[arrowhouse]

Thanks Geoff,

I am going for the 2 matrix report only because I want to show one half of the values in the columns N4 and the others as N2. I couldn't find a way to to do that (perhaps I asked the wrong question) - so i thought maybe separate matrix, but alligned would work. It is a fairly simple structure.

So (e.g) I want:
Apples Pears ... Mango
Day 1 17.40 50.30 ... 95.3455
Day ..
Day 7 19.30 34.95 ... 98.3476

Changing the header row on both the matrix items has worked fine.

thanks

Liz

 

[xlbo]

Good to know it worked but if there is anything that can be logically hooked into to determine the formatting, it can be done dynamically....

=iif(Fields!TestField="1stHalfOfMatrix","N2,"N4")

would be the pseudocode to explain what you might enter into the format property

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[arrowhouse]

Hi Geoff,

Thanks for being so helpful.

Yes I have something I can determine logically. So your suggestion works fine & simplifies the report.

I hadn't discovered the conditional formating expression. Magic.

Kind regards

Liz

 

[xlbo]

No probs - the majority of properties in SSRS can be conditional in the same way - colours / borders / formats / sizes / just about anything really...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question