We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Conditional Formatting on Rows

Thread ID:

Created:

Updated:

Platform:

Replies:

145081 Jun 5,2019 02:17 PM UTC Jun 7,2019 07:39 AM UTC Report Platform 5
loading
Tags: Report Designer
Matt Lawrence
Asked On June 5, 2019 02:17 PM UTC

Hi there,
When using a PivotGrid in Sync Fusion report designer, is it possible to change the colour of a row based on the contents of a field in that row?

For example I have columns a grid of: 

Case #      Date             Priority      Customer, 
1               30/04/2011   High          Bob
2               25/02/0012   Low          Dave  

could I change the colour of the row red when the Priority is High? Many thanks

Vinoth Srinivasan [Syncfusion]
Replied On June 6, 2019 11:26 AM UTC

Hi Matt, 

Thanks for your interest in Syncfusion components. 

Currently, we don’t have an option to change the background color of the row based on the field value in Pivot Grid, so we suggest you to use the Tablix control to achieve your requirement. You need to set the below expression for the background property of each cell in that row for your requirement. 

=IIf(Fields!Priority.Value = "High", "Red", "Transparent") 
 
 
We have prepared a simple report based on this and it can be downloaded from the below location. 


Regards, 
Vinoth S. 


Matt Lawrence
Replied On June 6, 2019 12:11 PM UTC

Many thanks Vinoth,

I have attempted to alter the expression to exactly what I need and unfortunately this hasn't work.  I should note that I am using the Web Designer, so the only options I have for the table are the Grid and PivotGrid.

I have attached screenshots of what I have attempted.

Attachment: screenshots_87ceb3bc.zip

Vinoth Srinivasan [Syncfusion]
Replied On June 6, 2019 12:22 PM UTC

Hi Matt, 

Thanks for your update. 

Could you please update us the Report Server version you are using at your end, since we have provided Tablix report item support in 3.2.0.40 release version. 

Regards, 
Vinoth S. 


Matt Lawrence
Replied On June 6, 2019 12:33 PM UTC

Hi Vinoth,

I believe I am using 3.1.0.34.

Kind regards,

Matt

Vinoth Srinivasan [Syncfusion]
Replied On June 7, 2019 07:39 AM UTC

Hi Matt, 
 
We suggest you to upgrade to our latest report platform release to use the Tablix report item. Please download our Syncfusion Report Platform, 2019 v4.1.0.16 builds from below link. 
 
 
Regards, 
Vinoth S. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon