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

Big data in the report tool how to make a record table with a timeline, in view of this problem, this article introduces the corresponding analysis and solutions in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

If you want to make a report that records events in the timeline, how do you make it through the report tool? How to make the timeline? Let's take the drying report as an example to make two types of timeline records, and see how to achieve them.

Concise version of timeline

1. Add the dataset to fetch the time and events that need to be recorded.

I read the time and event data from the EXCEL file, which is shown in the following figure:

Create a new report under report designer, and then add a file dataset to the report menu, dataset.

Select the EXCEL file, then select the field and click OK.

After building the dataset, you can see the field name of the newly created dataset in the lower right corner of the report design interface. Select the corresponding fields and drag them to the B2PowerC2 cell to automatically generate a numeric expression in the cell.

The default size of the cell is the same as the design size, in order to fully display the content, we need to manually change the resize mode to enlarge according to the cell content.

Select A1, B1, C1, then merge the cells and enter the text "COVID-19" in the cell.

The effect of previewing the report under the designer is shown in the following figure.

Next, add a timeline.

I saved the intercepted part of the timeline as a picture and added the picture file to the A2 cell.

After adding the picture, we preview the report and find that only an event axis node appears in the middle.

The effect of the above image is that B2 is an extension grid, stretching the previous grid with an image, and what we want is that there needs to be a timeline node before each time, so we need to manually change the left nominative of A2 grid to B2.

Let's take a preview of the effect.

Through the above settings, we have made a concise time record table by means of pictures.

Dynamic change of timeline color

The timeline of the time record table in the screenshot below is a dotted line. From the perspective of the style, it seems that our first idea can be solved directly through the border of the cell, but the color of the border of the extended cell is fixed. Cannot be dynamically changed by conditional expressions.

The border color of a grid can not be changed dynamically, but its foreground color and background color can be changed dynamically.

The effect in the screenshot here is to dynamically change the color of the grid by entering a character of a vertical bar in the grid and making a conditional judgment according to the accumulated value of the event.

In the B1 lattice, a variable is defined and the initial value 0 is assigned, in the D4 cell, the value expression is set to = a=a+1, and the foreground color is set to white, so that the accumulated value of an is used to judge the condition and will not be displayed.

Set the conditional judgment expression in the foreground color in the E4 cell to dynamically change the color of the vertical bar according to the accumulated value of D4.

Now draw the key points: pay attention to the use of temporary variables and how to manually modify the nominative by following the extension.

The answer to the question about how the report tool in big data makes a record table with a timeline is shared here. I hope the above content can be of some help to you, if you still have a lot of doubts to be solved. You can follow the industry information channel for more related knowledge.

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.