“I have a data retrieval application written in CGI that shows information about customer orders. I would like to display all the values that are greater than 1000 in a different color. How can I do that?”

In order to display values in different colors based on specified condition, you will need to create a set of calculations. In following example Salesman's 'Total Commission' is displayed in color red if that commission is greater than 1000.

In order to change font color to red you need to add this tag in your HTML <font color=red>. To make sure that this color is displayed only when the condition is true (total commission greater than 1000) alphanumeric calculations 'font', 'color' and 'red' are created. Then those calculations are concatenated into an 'HTML tag ' calculation that will give <font color=red> HTML tag.

That calculation is then used as a result in the conditional calculation 'Commission greater than 1000' that will be executed only if 'Total commission' is greater than 1000. See Figure 1 - Calculated fields - to see the logic.

Figure 1 — Calculated fields. (Click to enlarge)


In option 5 — Preformat of your retrieval to make sure to specify the calculation 'Commission greater than 1000' as Display type — you will not need to display 'font', 'color' 'read' and 'HTML tag' calculations. See Figure 2 — Preformat — for calculations, sizes, and display types. Compile your application.

Figure 2 — Preformat (Click to enlarge)


Your generated application will look like the one in Figure 3 — Sales Performance by Name (note: number of records to display was changed to 10 instead of the default 5). You can see that the last field displayed is 'Commission greater than 1000".

Figure 3 — Sales Performance by Name (Click to enlarge)


You will need to modify QHTMLSRC for your retrieval application by following these two easy steps:
1. The first step is to comment out these two lines of code:

Have a hotline question of your own? Send an e-mail to support@mrc-productivity.com and let our product specialists help you!