Hi,
I have some columns that sometimes may have null values... I got the null rows to shrink with CanShrink = True in Layout property, but it seems this doesn't seem to work on the columns...I've attached some pics... Any help?
1 Answer, 1 is accepted
0
Hi Lily,
Selecting a column will be accepted as a collection of textboxes. Note that they CanShrink only vertically. That is why the column doesn't shrink horizontally.
I suggest to apply a Conditional formatting rule with nested IIf to check if all of the column fields contain Null values. In the attached report I tried to imitate your crosstab and the following rule is set on the column - ConditionalFormatting property:
Expression: = IIf(Fields.techCodeColumn= "", IIf(Fields.upperPercent = "", IIf(Fields.Value = "", true, false), false),false)
Operator: =
Value: =true
Then set the Style -> uncheck Visible -> OK.
Please, test the suggested approach and let us know whether it works for you.
Regards,
Neli
Progress Telerik
Selecting a column will be accepted as a collection of textboxes. Note that they CanShrink only vertically. That is why the column doesn't shrink horizontally.
I suggest to apply a Conditional formatting rule with nested IIf to check if all of the column fields contain Null values. In the attached report I tried to imitate your crosstab and the following rule is set on the column - ConditionalFormatting property:
Expression: = IIf(Fields.techCodeColumn= "", IIf(Fields.upperPercent = "", IIf(Fields.Value = "", true, false), false),false)
Operator: =
Value: =true
Then set the Style -> uncheck Visible -> OK.
Please, test the suggested approach and let us know whether it works for you.
Regards,
Neli
Progress Telerik
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items