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

BIRT how to achieve dynamic date grouping according to parameters, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

BIRT is generally good at dealing with data with consistent rules, but dynamic operations with inconsistent conditions are difficult to achieve in reports. The conventional approach is to create a scripted data sources, process the business logic on the script source, prepare the data, and then pass it directly to the BIRT for presentation. But the SQL or scripted data sources way, the code is very troublesome to write, and a lot of work.

For example, to deal with such a scenario: to count orders over a period of time according to the start date and end date, but to display the results dynamically by day, week, month, and year according to the span of the start and end date. The query process is shown in the following figure:

It is recommended to use an aggregator, whose rich set operations can easily complete this kind of calculation and logical judgment, which is shorter than the code written by Java and easier to write than stored procedures. For example, similar calculations can be written like this in the aggregator:

A

B

one

= []

two

= demo.query@x ("select ORDERID,ORDERDATE,ORDERAMOUNT from ORDERS where ORDERDATE > =? and ORDERDATE

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.