Showing posts with label fairly. Show all posts
Showing posts with label fairly. Show all posts

Friday, March 23, 2012

Matrix tables - blank pages print

Hello,

I have a fairly large report with multiple matrix tables. They grow to a fixed width horizontally and may grow to various heights vertically. I have the interactive height set to zero so that it displays on the web page on one screen. When I go to print this report, I am getting a blank page between each page with data. Here are my dimensions:

Report:

height: 15 in

width: 8.5 in

interactive height: 0 in

interactive width: 8.5 in

left margin: .5 in

right margin: .5 in

top margin: .5 in

bottom margin: .5 in

Body:

height: 13.3875 in

width: 6.9 in

Would this problem be due to the fact that my matrix tables span an area greater than a normal page height in design mode even before they grow dynamically? Any suggestions would be appreciated.

Thanks.

Problem solved - it turned out to be hidden fields on the report that were causing the issue. Thanks.sql

Wednesday, March 7, 2012

Matrix - Alternating row colours

Hello,
My first posting - I am fairly new to reporting services and I wonder if
anyone knows how to alternate the background colour on a row in a matrix?
I can do a similar thing in a table using
=iif(RowNumber(Nothing) Mod 2, "#ffffff","#d3efef")
this doesn't function correctly if it's placed across the matrix row - and
outputs wrong over individual cells.
# Broxi #Please read this blog article:
http://blogs.msdn.com/chrishays/archive/2004/08/30/223068.aspx
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Craig Thomson" <craig@.mercatus.no> wrote in message
news:eZyGk3HoEHA.1460@.TK2MSFTNGP12.phx.gbl...
> Hello,
> My first posting - I am fairly new to reporting services and I wonder if
> anyone knows how to alternate the background colour on a row in a matrix?
> I can do a similar thing in a table using
> =iif(RowNumber(Nothing) Mod 2, "#ffffff","#d3efef")
> this doesn't function correctly if it's placed across the matrix row - and
> outputs wrong over individual cells.
> # Broxi #
>