SAP Crytal Report

How to apply Conditional Formatting in Crystal Reports?. The Complete SAP Crytal Report Developer Course 2023 [Videos].

To write a conditional formatting formula, right-click the report and click Format Result Object element → select the property on which you want to apply conditional formula → click and it will open formula workshop.

Write the formula in the formula text pane, save and close it.

Conditional Formatting

In this example, if you can print Total Price greater than 60000 in Green and below 60000 in Red, this can be passed in formula workshop.

Formula Example

Formula Example2

In this example, crGreen, crRed, crBlack is used. You can also use actual numeric value of color constants.

There are three common conditional formatting functions −

  • CurrentObjectValue
  • DefaultAttribute
  • GridRowColumnValue

DefaultAttribute can be used for any formatting formula, CurrentObjectValue for any formatting formula where you are formatting an object value, and GridRowColumnValue can be used for any formatting formula where you are formatting an object value in a Cross-Tab.

See All

Comments (361 Comments)

Submit Your Comment

See All Posts

Related Posts

SAP Crytal Report / Blog

What is Crystal Reports ?

SAP Crystal Reports is a Business Intelligence tool which is used to generate reports from both SAP and non-SAP data sources. It enables end users to generate reports that includes exceptional visualizations and implement new business requirements into reports to reduce dependency on IT and Report developers.
7-Feb-2022 /17 /361

SAP Crytal Report / Blog

What is GUI Navigation in Crystal Reports?

Crystal Reports for enterprise provides an interface that enables you to quickly and easily create, format, and publish effective reports. The menu bar provides full range of features available in Crystal Reports for Enterprise as shown in the following image.
7-Feb-2022 /17 /361

SAP Crytal Report / Blog

What is Options in Crystal Reports?

Report Options is one of the most commonly used feature in Crystal Report Designer, when you need to access/modify the values of Report Options of a Crystal report at runtime in a Crystal Reports .NET application.
7-Feb-2022 /17 /361