Groups | Blog | Home
all groups > sql server reporting services > july 2006 >

sql server reporting services : Variable Set of Columns in Report


Microsoft
7/10/2006 4:03:43 PM
I have been trying in vain for some time to create a columnar report where
certain column(s) can be hidden as requested by the user via report
parameter(s). I have tried placing all the columns in the report and then
hiding some as needed, but this prints blank pages when rendered to PDF
since the report body does not shrink as column(s) are hidden. I have tried
a table, list, and matrix to no avail...
Does anyone know of a workaround, a trick, or perhaps a different approach
that I have not thought of?
Thanks.

Tim Dot NoSpam
7/10/2006 9:31:37 PM
Hi Microsoft Ron.

When you say it prints blank rows, does this mean that a user can hide ALL
the columns? What if they hide all but one column? Wouldn't that one
column still be valid as a row?

[quoted text, click to view]

Ron L
7/11/2006 7:28:58 AM
It renders blank pages to PDF, which are essentially the report body with
the columns that reside there, but the columns are "hidden". The fact that
the report body is wider than the page (even though the number of visible
columns will fit on the page) cause blank pages to be rendered. It would be
nice if the body width "rolled-up" in response to hidden content residing
there. Can't seem to come up with another approach that works.

By the way, sorry about the "from Microsoft" thing. Apparently I share an
office with comedians.

Ron

[quoted text, click to view]

Tim Dot NoSpam
7/12/2006 12:00:00 AM
I'm slow. If you have ColumnA, B and C on the report body and hide column
C, do you still get the blank space that ColumnB would have inhabited?

I'm just wondering if what might be happening is the cells are marked hdden
but the column isn't.

-Tim

The reason I ask is
[quoted text, click to view]

AddThis Social Bookmark Button