![\"\"](\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2011\/01\/conditional_formatting1.png\" "\\"conditional_formatting1\\"")
<\/p>\nThis tutorial shows how to use conditional formatting in PHPRunner\/ASPRunnerPro projects.<\/p>\n
Our first example illustrates the profitability of the product line where we have a list of products with their respective monthly profit figures. All positive numbers are displayed in black and all negative in red. Changing the font color of this field based on its value helps the viewer immediately spot the losing products and take necessary actions.<\/p>\n
<\/p>\n
\nTo set the formatting proceed to Visual Editor and double-click on the field you want to format. In our case it is the field “Profitability”. Select ‘Custom’ View As option. Add your code in the custom code editor. If the value of my current field is greater than zero I will set the font color to black, otherwise to red. Always remember to check the syntax of your code.<\/p>\n
PHP<\/strong><\/p>\n ASP<\/strong><\/p>\n C#<\/strong><\/p>\n You can also represent the positive and negative results with images. For example I have added the red and green circles to highlight the performance of each product. To make this work you will simply need to add two more lines to your custom code. Don’t forget to place the actual images in the project folder.<\/p>\n PHP<\/strong><\/p>\n ASP<\/strong><\/p>\n C#<\/strong><\/p>\n Now, lets say we want to highlight not only the font color itself but also change the background of the cell to yellow.<\/p>\n Because we are no longer working with just the field values, but with the table structure, we will have to use the events to set the background color.<\/p>\n Proceed to the Events screen in the software and select ‘After record processed’ event for the list page of the Products table. The code will be similar to the one we used earlier. If the value of the ‘Profitability’ field is less than zero and will set the background of the cell to yellow. You can refer to the software manual for more examples and code syntax.<\/p>\n PHP<\/strong><\/p>\n ASP<\/strong><\/p>\n C#<\/strong><\/p>\n Let\u2019s say you wanted to take it a step further and highlight the entire row of the losing products.<\/p>\n In the same event you can use the same code for the condition check and only change the code for setting the background of the row. You code should look like this. Once again you can find the exact syntax for this example in the software manual.<\/p>\n PHP<\/strong><\/p>\n ASP<\/strong><\/p>\n C#<\/strong><\/p>\n And if you want to change the background color of all rows regardless of the condition, you can simply comment out the condition in this event:<\/p>\n PHP<\/strong><\/p>\n ASP<\/strong><\/p>\n C#<\/strong><\/p>\n Watch the video tutorial<\/a><\/p>\n Other tutorials: PHPRunner<\/a>, ASPRunnerPro<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" This tutorial shows how to use conditional formatting in PHPRunner\/ASPRunnerPro projects. Our first example illustrates the profitability of the product line where we have a list of products with their respective monthly profit figures. All positive numbers are displayed in black and all negative in red. Changing the font color of this field based on its value helps the viewer immediately spot the losing products and take necessary actions.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,1,8],"tags":[9,17,6,5],"class_list":["post-68","post","type-post","status-publish","format-standard","hentry","category-asp-net","category-php-category","category-tutorials","tag-view-as-custom","tag-appearance","tag-asprunnerpro","tag-phprunner"],"_links":{"self":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/68","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/comments?post=68"}],"version-history":[{"count":72,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/68\/revisions"}],"predecessor-version":[{"id":194,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/68\/revisions\/194"}],"wp:attachment":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/media?parent=68"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/categories?post=68"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/tags?post=68"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}if ($value < 0) {\r\n $color=\"black\";\r\n} else {\r\n $color=\"red\";\r\n}\r\n$value=\"<span style='color: \" . $color . \"'>\" .$value . \"<\/span>\";<\/pre>\nif strValue < 0 then\r\n color=\"black\"\r\nelse\r\n color=\"red\"\r\nend if\r\nstrValue=\"<span style='color: \" & color & \"'>\" & strValue & \"<\/span>\"<\/pre>\n
\r\nstring color;\r\nif (value > 0) {\r\ncolor=\"black\"; \r\n}else { \r\ncolor=\"red\"; \r\n}\r\nvalue=\"<span style='color: \" + color + \"'>\" + value.ToString() + \"<\/span>\";\r\n<\/pre>\nif ($value < 0) {\r\n $value =$value. ' <img src=\"green.png\" alt=\"\" \/>';\r\n $color=\"black\";\r\n} else {\r\n $value ='<strong>'.$value. '<\/strong> <img src=\"red.png\" alt='' \/>';\r\n $color=\"red\";\r\n}\r\n$value=\"<span style='color: \" . $color . \"'>\" . $value . \"<\/span>\";<\/pre>\nif strValue < 0 then\r\n strValue = strValue & \" <img src='green.png' alt='' \/>\"\r\n color=\"black\"\r\nelse\r\n strValue = \"<strong>\" & strValue & \"<\/strong> <img src='red.png' alt='' \/>\"\r\n color=\"red\"\r\nend if\r\nstrValue=\"<span style='color: \" & color & \"'>\" & strValue & \"<\/span>\"<\/pre>\n
\r\nstring color;\r\nif (value < 0) {\r\n value = String.Format(\"{0} <img src='green.png' alt='' \/>\", value); \r\n color=\"black\"; \r\n} else {\r\n value = String.Format(\"<strong>{0}<\/strong> <img src='red.png' alt='' \/>\", value); \r\n color=\"red\"; \r\n}\r\nvalue = String.Format( \"<span style='color: {0}'>{1}<\/span>\" , color, value); \r\n<\/pre>\n![\"\"](\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2011\/01\/conditional_formatting2.png\" "\\"conditional_formatting2\\"")
<\/p>\n![\"\"](\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2011\/01\/conditional_formatting3.png\" "\\"conditional_formatting3\\"")
<\/p>\nif ($data[\"Profitability\"]<0)\r\n $record[\"Profitability_css\"].='background:yellow';<\/pre>\n
if data(\"Profitability\")<0 then\r\n record(\"Profitability_css\") = record(\"Profitability_css\") & \"background:yellow\"\r\nend if<\/pre>\n
\r\nif (data[\"Profitability\"]<0) \r\n record[\"Profitability_css\"]+=\"background:yellow\"; \r\n<\/pre>\n
if ($data[\"Profitability\"] < 0)\r\n $row[\"rowstyle\"]='style=\"background:yellow\"';<\/pre>\n
if data(\"Profitability\") < 0 then\r\n row(\"rowstyle\")=\"style='background:yellow'\"\r\nend if<\/pre>\n
\r\nif (data[\"Profitability\"]<0) \r\n row[\"rowstyle\"]+=\"background:yellow\"; \r\n<\/pre>\n
$row[\"rowstyle\"]='style=\"background:yellow\"';<\/pre>\n
row(\"rowstyle\")=\"style='background:yellow'\"<\/pre>\n
\r\nrow[\"rowstyle\"]+=\"background:yellow\"; \r\n<\/pre>\n