- Pentaho 5.0 Reporting by Example
- Mariano García Mattío Dario R. Bernabeu
- 464字
- 2021-08-13 16:24:36
Time for action – configuring the Details Footer section
Next, we will configure the Details Footer section as seen here:
- We will make the Details Footer section visible in our report. The Details Footer section is commonly used to place a summary of what was seen in Details.
- Go to the Structure tab, and in the hierarchical tree, navigate to Master Report | Group: | Details Body | Details Footer. Then configure Attributes.hide-on-canvas with the value false:
- We will add the following two labels in the work area of this section:
Total Articles:Total Sales:
- And we will set the following value for both of them:
- Style.bold =
true
- Style.bold =
- Next, we will create a function to count the rows, in this case, of the products sold.
We create the
Count (Running)function, found in the Running category, and configure it with the following characteristic:- Function name =
ProductCounter
Note
The functions that include the word
Runningas part of their name tell us that they are executed as the data is processed, that is, on the fly. In this case,Count (Running)will count the report's rows as they are presented in the Details section of each page. - Function name =
- Similarly to the previous step, we create a function that will take a sum of the sales made.
We create the
Sum (Running)function, found in the Running category, and configure it with the following characteristics:- Function name =
SumQty - Field name =
Quantity
Note
In this case,
Sum (Running)will take a sum of theQuantityfield as the data is presented in the Details section of each page. - Function name =
- Now we place the two recently created functions to the right of the label that corresponds to each, that is, we will place
ProductCounterto the right of the first label andSumQtyto the right of the second label.Let's consider, when we are laying out the report, that an object we have inserted becomes red; refer to the following example:
This indicates that this object is superimposed on another object and that it is possible that when the report is executed, this object will not be viewable normally. In these cases, we should arrange and resize the objects so that none are superimposed.
- We copy the horizontal line (
) created earlier by pressing the 
icon. We select the Details Footer section and paste the horizontal line by pressing the 
icon. Then we position it in the upper part of this section. - We see what the report looks like at this point. Press the preview button. We should obtain the following result:
What just happened?
We customized our report's Details Footer section. We created and added two functions, one to calculate the quantity of articles sold and another to calculate the sum of the sales.
- 快·易·通：2天學(xué)會(huì)Office辦公應(yīng)用（2016版）
- 輕松學(xué)五筆打字
- Word+Excel+PPT高效辦公從入門到精通
- Access 2010數(shù)據(jù)庫(kù)實(shí)用教程
- Office 2007辦公軟件應(yīng)用立體化教程
- 新編Word/Excel/PPT 2016高效辦公三合一（全彩版）
- 大話PPT：幻燈片制作真經(jīng)
- 精通Excel數(shù)據(jù)統(tǒng)計(jì)與分析
- Office2010從入門到精通（視頻講解+圖解+技巧）
- Excel數(shù)據(jù)處理與統(tǒng)計(jì)初步（第4版）
- 巧學(xué)活用Word
- MATLAB及Mathematica軟件應(yīng)用
- Excel 2010 SQL完全應(yīng)用
- Excel 2010表格處理直通車
- Excel商務(wù)數(shù)據(jù)分析與應(yīng)用（慕課版·第2版）