After Ryan's Advanced SSRS conference session, I went home and have been working on a calendar report for use with some of our Volunteers. Much of this is working out fine, but I am finding that the VerticalAlign property of my calendar field is not acting as it should and/or I am missing something. Please see attached screenshot. Why isn't the text for each date field Aligning to the top? Everything I can find is set to VerticalAlign = Top, and all looks well in BIDS preview tab, but in IE I get this. Anyone have any suggestions? Thanks!(Using BIDS/SSRS 2005.)
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!