Highlight Max Value in column

4 posts, 0 answers
  1. Bill
    Bill avatar
    9 posts
    Member since:
    Apr 2013

    Posted 04 Mar 2015 Link to this post

    I have a report that displays a calculated value in a textbox in a group footer section.  I need to highlight this textbox if its' value is the maximum for the values displayed in this column.

    The section of the report is shown in the attached file.

    How would I highlight the 16.09% in the Membership in PAL column.

    Any help would be appreciated.
  2. Bill
    Bill avatar
    9 posts
    Member since:
    Apr 2013

    Posted 04 Mar 2015 Link to this post

    Just to clarify.  I now how to use conditional formatting. The real question should be how do I determine what the highest value in the column.  In the case of the attachment it is 16.09%.

    Thank you
  3. Bill
    Bill avatar
    9 posts
    Member since:
    Apr 2013

    Posted 05 Mar 2015 Link to this post

    I got it.  Changed my SQL to do the calculation and added a dense ranking descending column to determine the row with the highest value and used conditional formatting to check for a ranking of 1 to highlight the cell.
  4. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 09 Mar 2015 Link to this post

    Hi Bill,

    I am glad to hear you found a solution.

    Other approach will be to use the Exec data function, and the data scope of the data item or the group to get the MAX value and compare it to the current value via conditional formatting rule.
    Consider the attached demo report in XML format. It can be previewed with the Standalone Designer tool of Telerik Reporting Q1 2015

    Regards,
    Stef
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top