null columns not shrinking

2 posts, 0 answers
  1. Lily
    Lily avatar
    22 posts
    Member since:
    Feb 2019

    Posted 10 Jun 2019 Link to this post


    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?

  2. Neli
    Neli avatar
    277 posts

    Posted 13 Jun 2019 Link to this post

    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.

    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
Back to Top