Shulou(Shulou.com)06/03 Report--

In the business system, we often see such data display requirements: some special data has a specified standard range, and data beyond the standard range should be marked with red warning display to inform customers that this data is abnormal, which is what we call data warning. The effect is shown in the following figure. Red shows the warning when the freight cost is greater than 100. This effect shows abnormal data more clearly and helps users to analyze and judge abnormal data.

Without reporting tools, we usually need to spend some time changing the page style ourselves, and with reporting tools we can achieve the data warning effect in minutes.

The little teacher taught us a simple way to achieve the effect of the picture above, now start class, whose small eyes haven't looked at the teacher.

The props used by the little teacher are: Run dry report (knock on the blackboard), pay attention to keep up with the teacher's rhythm.

First, we make a tabular report, as shown below:

Among them,

Cell A2 uses the select function to obtain manifest data

Use value method for cells after B2

[Practical Tips]:

If the list-style report does not have parameters and sql is relatively simple, we can directly use the wizard to make it, use the File-New Report menu function, and perform foolish operations according to the prompts;

If sql is relatively complex or has parameters and other configurations, you can create a blank report, and then use the "dataset" configuration function in the lower right corner of the designer to drag fields to report cells to automatically generate fetch expressions.

A simple list-style report is complete, let's preview the results:

Then, we will achieve the effect of data warning.

Thump thump. Select the cell where we want to set the data alert (corresponding to E2 in this example), and find "Display"-"Foreground View" in the cell attributes on the right, and configure the foreground color expression, as shown in the following figure:

Among them,

value() is a cell function that obtains the value of the current cell.

In this example, the warning display is realized when the freight cost is greater than 100, and different foreground colors are set according to whether the condition is satisfied, so as to realize the data warning effect.

Duang~ Perfectly done!

[Practical Tips]

Color input We use the "Color Input" drop-down button in the dialog box to select commonly used colors;

You can also double-click the color in front and select and configure all colors in the pop-up dialog box. Common color configuration methods are supported, as shown in the following figure:

Finally, let's review the problems encountered and the skills to solve them:

[Problem] Data Alert

Tip: Use foreground color expression configuration. Of course, smart friends should not be difficult to think of how to use background color to show the warning effect.

So far, the data warning effect is perfect ending, we only use the foreground color setting of the dry report to achieve the effect, this wave of operation 6 not 6? Come on~ Run dry report waiting for you to pick~

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.