all groups > sql server reporting services > may 2007 >
You're in the

sql server reporting services

group:

Dynamic columns



Dynamic columns Sherminator
5/29/2007 1:32:02 PM
sql server reporting services: I am setting visible property for column based on user input. This works
fine. However, I need to be able to change the width to 0 for the column as
well so the report will not print blank pages. A matrix is NOT an option.
Report is too complicated. Unfortunately there is no expression option for
the column width. Is there any way of setting this to 0 or autosize???? Also
need to adjust the body width dynamically.
Re: Dynamic columns EMartinez
5/29/2007 6:27:18 PM
On May 29, 3:32 pm, Sherminator
[quoted text, click to view]


Unfortunately, there are not very many options available if a matrix
control is not an option. You could try putting the table control(s)
in a rectangle. Also, you could try to rearrange the columns according
to the ones most likely to be invisible. Sorry that I could not be of
greater assistance.

Regards,

Enrique Martinez
Sr. Software Consultant
Re: Dynamic columns Sherminator
5/30/2007 5:40:01 AM
It's not a matter of the columns not showing, so the order doesn't matter.
They do hide, however blank pages print because the body is over 18 inches
when all columns are populated. Unfortunately, the tablecolumn element is not
available thru the ReportItems collections. If it were I could reset the
width of the empty columns to 0 using a function and adjust the body width if
it too were available thru the ReportItems collection, however, those
elements are not available to my knowledge.

[quoted text, click to view]
AddThis Social Bookmark Button