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.
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.
3 Answers, 1 is accepted
0
Bill
Top achievements
Rank 1
Rank 1
answered on 04 Mar 2015, 06:53 PM
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
Thank you
0
Bill
Top achievements
Rank 1
Rank 1
answered on 05 Mar 2015, 03:16 PM
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.
0
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
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.