{"id":26632,"date":"2023-05-30T09:59:13","date_gmt":"2023-05-30T09:59:13","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=26632"},"modified":"2024-11-26T08:39:11","modified_gmt":"2024-11-26T08:39:11","slug":"how-to-conditionally-format-fields-using-the-highlighting-expert-in-crystal-report","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2023\/05\/30\/how-to-conditionally-format-fields-using-the-highlighting-expert-in-crystal-report\/","title":{"rendered":"How to conditionally format fields using the Highlighting Expert in Crystal Report"},"content":{"rendered":"\n

In the Sage X3<\/a>, we have various standard reports for almost every screen which are developed in Crystal Report. Also we can develop customized reports as per client\u2018s need. Crystal Reports is a popular Windows-based report writer solution that allows a developer to create reports and dashboards from a variety of data sources with a minimum of code to write.<\/p>\n\n\n\n

One of our client wanted to highlight the lines in the Sales Order report which are having values greater than 10,000. To achieve this requirement, we have used Highlighting Expert<\/strong> feature of Crystal Report, which highlights one or more fields or the whole section based on a particular condition. <\/p>\n\n\n\n

We’ve created a DEMO report and highlighted the field ‘Total’ with red color and the whole section with silver when the ‘total including tax’ field exceeds the value greater than or equal to
10,000. Follow the below steps to achive above task :<\/p>\n\n\n\n

Step 1:<\/strong>
Select a field to be highlighted (Total Including Tax)<\/p>\n\n\n\n

Step 2:
<\/strong>Highlighting button on the Expert Tools toolbar<\/p>\n\n\n\n

New Stuff:<\/strong> How to increase or decrease the number of lines in grid of any Inquiry screen<\/a><\/p>\n\n\n\n

\"Expert<\/a><\/center>\n
Expert Tools toolbar<\/center><\/font>\n\n\n\n

Step 3:<\/strong>
In the Item editor area, click the Value of list and select the field that you want to base your condition on.
The field chosen here is the field upon which your condition is based; this field need not be the field that is being formatted. To create a condition based on the values of the field that is being formatted, select “this field” from the list. To base your condition on a different report field, select it from the list of available fields.<\/p>\n\n\n\n

Step 4:<\/strong>
Select a comparison from the second list (is equal to, is less than, and so on).<\/p>\n\n\n\n

Step 5:<\/strong>
Complete the condition by entering the desired value in the box.<\/p>\n\n\n\n

Step 6:<\/strong>
In the Font style, Font color, Background, and Border lists, specify the formatting changes that you want to apply to the selected field when your condition is met.<\/p>\n\n\n\n

\"Highlight<\/a><\/center>\n
Highlight expert<\/center><\/font>\n\n\n\n

Step 7:<\/strong>
Click OK to return to your report.<\/p>\n\n\n\n

Also, we can change the backgroud color based on conditions of any particular section by writing the condition on formula workshop :<\/p>\n\n\n\n

Step 1:<\/strong>
Right Click on the detail section and select ‘Color’ tab.<\/p>\n\n\n\n

\"Section<\/a><\/center>\n
Section Expert<\/center><\/font>\n\n\n\n

Step 2:<\/strong>
Click on the conditional formula button and write the condition as per requirement<\/p>\n\n\n\n

\"Formula<\/a><\/center>\n
Formula Workshop<\/center><\/font>\n\n\n\n

Step 3:<\/strong>
Click on save and close button.<\/p>\n\n\n\n

\"Output\"<\/a><\/center>\n
Output<\/center><\/font>\n\n\n\n

As we can see, lines which are having values greater than 10,000 in Total Excluding Tax are getting highlighted in Red color and having background of Grey color. But the other remaining values are not getting highlighted and background color for those values is white.<\/p>\n\n\n\n

So it is working properly as per the condition we have applied in the Formula workshop and Highlighting expert.<\/p>\n","protected":false},"excerpt":{"rendered":"

In the Sage X3, we have various standard reports for almost every screen which are developed in Crystal Report. Also we can develop customized reports as per client\u2018s need. Crystal Reports is a popular Windows-based report writer solution that allows a developer to create reports and dashboards from a variety of data sources with a\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,13],"tags":[3172,357,3699,461,3517,3739,3745],"class_list":["post-26632","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-integration","tag-amount","tag-color","tag-conditions","tag-crystal-report","tag-formula","tag-greater-than","tag-highlighting"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/26632","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=26632"}],"version-history":[{"count":13,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/26632\/revisions"}],"predecessor-version":[{"id":30235,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/26632\/revisions\/30235"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=26632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=26632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=26632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}