SSRS Matrix report Align issue

Hi Chris,

Good day.

How about you replace "Top" in VerticalAlign with:

=IIF(1=1,"Top","Top")

I think, as "Top" is a default value for the field,  then maybe it will pass nothing to web page.

If you pass something in the code, then the web page must have something in it.

So maybe this something can fix the problem.

Also maybe check out something else.

http://stackoverflow.com/questions/531383/reporting-services-right-item-alignment

have fun

Ben

Thanks for your reply, Ben. I tried what you suggest, and SSRS05 doesn't seem to like VerticalAlign expressions, i.e. I tried "=IIF(1=1,"Top","Top")", deployed, and got the error:

• An error occurred during rendering of the report. (rrRenderingError)
  • An error occurred during rendering of the report.
    • Object reference not set to an instance of an object.

If I google this, I get all sorts of really irrelevant suggestions. I tried a different expression, like "=iif(Parameters!year.Value > 1,"Top","Top")", and get the same. The error goes away if I get rid of the VerticalAlign expression and just go back to "Top", though the original bad behavior remains.

Since the alignment appears correctly in BIDS Preview, but incorrectly in IE, I suppose it is some sort of IE incompatibility with BIDS (yay Microsoft!).

Any other suggestions appreciated, but I think this is just a bug. *sigh*

Hi Chris,

Good day.

I had tested the IIF(1=1,"Top","Top") on our SSRS site, before I made the suggestion.

So the error could be something else.

rrRenderingError

http://msdn.microsoft.com/en-us/library/aa337266(v=SQL.90).aspx

have fun

Ben

If  you click on the column and look at the Properties Under Layout is CanGrow and CanShrink set to False.

Unknown said:

If  you click on the column and look at the Properties Under Layout is CanGrow and CanShrink set to False.

Everything in the matrix was set to CanGrow = False, as I earlier attempted to make my output fit onto one page (basically impossible; why doesn't MS have a fit-to-page for SSRS report output??) , and I wouldn't care if it shrank, frankly. However, I just  set all cells to CanShrink = False also, and the vertically floating cell output in IE remains.

IE and SSRS don't play nicely here. (For the millionth time I wish the BIDS preview tab output and IE output were the same...)

Thanks for your reply.

Hi Chris,

Good day.

There are two possible ways you can try to put the matrix in one page.

1,  Inside report:

A, modify Matrix property KeepTogether to Ture

B, reduce Margins in report Layout.

2, Outside report:

A,

Add custom css to pages.

Customizing Style Sheets for HTML Viewer and Report Manager

http://msdn.microsoft.com/en-us/library/ms345247(v=SQL.90).aspx

B,

Using URL Access Parameters

http://msdn.microsoft.com/en-us/library/ms152835(v=SQL.90).aspx

The following example uses the rc:Zoom parameter to set the zoom property of the report to Page Width:

http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:Zoom=Page Width

have fun

Ben

Unknown said:

There are two possible ways you can try to put the matrix in one page.

1,  Inside report:

A, modify Matrix property KeepTogether to Ture

B, reduce Margins in report Layout.

Yeah, I've been around and around on these. I love how MS describes KeepTogether as "... should be kept together if possible." It tries, but fails, to act like a Fit-To-Page. I can't fathom how they think people will be OK with printing matrix reports dynamically sprawled across multiple pages. "But they shouldn't print! Consume it online." someone might say. Ha, that's so funny...

Unknown said:

Add custom css to pages.

...

Using URL Access Parameters

...

The following example uses the rc:Zoom parameter to set the zoom property of the report to Page Width:

I'll check these out. I like the sound of that rc:Zoom.

Thanks!