null columns not shrinking

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

    Posted 10 Jun Link to this post

    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?

  2. Neli
    Admin
    Neli avatar
    188 posts

    Posted 13 Jun 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.

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