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

This article will explain in detail how to easily achieve the data anomaly early warning function of web report. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

In business systems, we often see such data display requirements: some special data have a specified standard range, and for data beyond the standard range, we need to show red warning to inform customers that this data is abnormal, that is, what we call data early warning. The effect is shown in the following figure, and red shows the warning when the freight is greater than 100. This effect shows the abnormal data more clearly and helps users to analyze and judge the abnormal data.

If we do not use the report tool, we usually need to spend some time to change the page style, and through the report tool we can achieve the data early warning effect minute by minute.

The little teacher taught you a simple way to achieve the effect of the picture above. Now the class begins, whose small eyes haven't looked at the teacher yet.

The props used by the primary teacher are: dry the report (knock on the blackboard) and keep up with the teacher's rhythm.

First, we make a tabular report, as shown in the following figure:

Among them

A2 cell uses select function to achieve inventory data acquisition

After B2, the cell uses the value method

[practical tips]:

If the inventory report has no parameters and sql is relatively simple, we can directly use the wizard to make it, use the "File"-"New report" menu function, and operate foolishly according to the prompts.

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

A simple checklist report has been made. Let's preview the results:

Then, let's achieve the effect of data early warning.

Here comes the key point. Select the cell where we want to set the data alert (in this case, corresponding to E2), find the following in the cell properties on the right: "display"-"foreground color", and configure the foreground color expression, as shown in the following figure:

Among them

Value () is a built-in cell function that gets the value of the current cell.

What is realized in this example is that when the freight cost is greater than 100, the early warning is displayed, and different foreground colors are set according to whether the condition is met, so as to achieve the data early warning effect.

Duang~ is perfect!

[practical tips]

Color input We use the Color input drop-down button in the dialog box to select common colors.

You can also double-click the front color to select and configure all colors in the pop-up dialog box to support common color configuration methods, as shown in the following figure:

On the web report how to easily achieve data anomaly early warning function to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.