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

BIRT cross table free lattice operation how to do, I believe many people without experience at a loss, this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

For example, to deal with such a scene:

1. Complete the cross table according to the detailed records.

2. Count the subtotal of each row on the cross table (intermediate process).

3. Calculate the percentage of each value in the crosstab to the subtotal.

The calculation flow is shown in the figure below:

BIRT and other tools will provide some calculation column function, you can calculate some other column values or statistical values on the basis of the original data, so it is easy to implement the first two steps. However, traditional tools (including BIRT) do not have a good naming mechanism for data items in post-operation reports (usually naming data units in design stage with column names), so it is difficult to accurately describe data reference relations and can only write expressions with strong regularity, while random independent lattice operations make traditional tools difficult to deal with.

A common solution is to write custom data sets (complex SQL or scripted data sources), pre-compute the data and stuff it into report boxes. But custom data set way, code is very troublesome, workload.

If you use a concentrator, it will be much simpler. Its rich set operations can easily complete such calculations. The code is shorter than scripted data sources and simpler to write than SQL. For example, similar calculations can be written like this in the concentrator:

A

1

=myDB.query@x("select * from record")

2

=A1.pivot(time;department,count)

3

>A2.run(t=Admin+Finance+Management,Admin=string(Admin/t,"0.00%"),Finance=string(Finance/t,"0.00%"),Management=string(Management/t,"0.00%"))

4

return A2

There are many similar computational problems that are not easy to solve in BIRT, but are easy to solve with the help of the concentrator SPL.

The aggregator provides a JDBC driver that can be easily integrated with reporting tools such as BIRT, which calls SPL scripts with methods to use and obtain it.

After reading the above content, do you know how to do the free cell operation in BIRT cross table? If you still want to learn more skills or want to know more related content, welcome to pay attention to the industry information channel, thank you for reading!

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.