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

sql server reporting services : Conditional Column Formatting


Michael C
7/19/2007 11:42:02 AM

Put double quotes around the "0.625in" and "0.25in"


[quoted text, click to view]
awakin
7/19/2007 6:27:21 PM
Hi Everyone,



I am trying to hide a column in a matrix table. I have no
trouble using conditional formatting to control the visibility of the
column, but when I hide the column the main row in the matrix does not
shrink. Therefore, I have a big gap... My thought was to use conditional
formatting to control the column width of the main matrix row. Listed
below is the expression that I used. Can anyone help me with the error
message or recommend a better solution?







=IIF(Fields!FiscalYear.Value = IIF(Month(TODAY()) =
10-12,Year(TODAY()) ,Year(Today())-1), 0.625in, 0.25in) cannot be
parsed as a unit because it does not contain numeric values. Examples
of valid unit strings are "1pt" and ".5in".



Regards,



A.Akin
AnthonyG
7/24/2007 11:40:00 PM
That doesn't help. It still gives the same error message.
Is there another way of doing this?

[quoted text, click to view]
justinsaraceno
8/20/2007 8:36:02 AM
Anthoney,

Did you ever figure this out? I need to control the width of a column but
it appears column width isn't formattable via an expression.

thanks,
Justin

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