Applying Conditional Formatting On Field In Crystal Reports

Ankur Mistry

ASP.NET Crystal Reportsconditional formatting on FieldFormatting in Crystal Reports

16 Comments

Join the conversation! Your thoughts help the community grow.

Sonu Chaudhary10y ago
nice share
Sonu Chaudhary10y ago
good one
Ankur Mistry11y ago
thank you
Bhalchandra mithbavkar11y ago
Nice Article
Mayank Sharma11y ago
Your way to teach us in step by step is very good Sir.
Ankur Mistry11y ago
thank you sirji
Rupesh Kahane11y ago
Good one
Gowtham K11y ago
Great Work, Thanks for sharing
Ankur Mistry11y ago
thank you all
Humayun Kabir Mamun11y ago
Nice...
Mannan11y ago
Nice article sir.... Informative
Santhakumar Munuswamy11y ago
Good one
Ankur Mistry11y ago
Thank you Sibeesh Venu
Sibeesh Venu11y ago
Nice Share
Ankur Mistry11y ago
Thank you Sir, but i am still learning. Not genius
Viraj Desai11y ago
Nice article. Really helpful. Ankur is genius.

In this article we will learn conditional formatting on Field in Crystal Reports. Will display salary of each employee and highlight the row if the salary is greater than 25,000 in red.

This article is the second part of my first article.

If you haven’t had a look at the first, then please go through the previous article: Step By Step Creating Grouping In Crystal Report.

Step 1: Create a new Table Salary as in the following:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Salary](
[EmpId] [int] NULL,
[Salary] [numeric](18, 2) NULL
) ON [PRIMARY]
GO

We already created 2 tables in my first article which is Employee and Department. So now we have 3 tables, [1] Employee [2] Department and [3] Salary,

Step 2: Now open the Crystal Report, go to Field Explorer, right click and select Database expert like the following screen:

Step 3: from the database Expert select the Salary table and click on ‘>’ button and click ‘OK’ Button,

Step 4: Now we have Salary table. Go to Links tab, give a link to Employee table and Salary table on EmpId field like the following screenshot.

Step 5: Now we have salary table in Field Explorer

Just Drag and Drop Salary field in Details Section of Crystal Report,

Step 6: Now go to Crystal Reports tab, Report and select Section Expert,

Step 7: Go to details section and click on color tab,

Step 8: Click on the highlighted button, this will open Formula Workshop,

Step 9: Write your condition here like the following:

if {Salary.Salary} > 25000 then

crRed

else

CrSilver

(If the salary is greater then 25000 then highlight the row with red color else silver color),

Selary

That’s it! Just check the formula by pressing Alt + C for checking for errors like the following screenshot,

Message

Step 10: Save the report and click on Main Report Preview,

Selary image

Here we displayed employee records in red if the salary is greater than 25,000, else highlight in Silver color.

I hope you liked this article.