- Pentaho 5.0 Reporting by Example
- Mariano García Mattío Dario R. Bernabeu
- 343字
- 2021-08-13 16:24:38
Time for action – modifying the report's footer
We will configure the Details Footer section for it to be repeated on every page of our report. We will configure the top border of the Details Footer section. We will modify the name of the labels on the Details Footer section to match the ones in our data set. Finally, we will modify the SumQty function to perform a sum on the sum_amount field.
- We will go to Report tree structure (Structure tab) and search the tree for the node by navigating to: Master Report | Group | Details Footer. We will select this node and modify it in the following way:
- Style.repeat-header:
true
This modification will make this section present on every page.
- Style.repeat-header:
- We will delete horizontal-line from the Details Footer section.
- We will go to Report tree structure (Structure tab), navigate to Master Report | Group | Details Body | Details Footer, and set the following:
- Style.top-style:
solid - Style.top-size:
4.0 - Style.top-color :
#009933
- Style.top-style:
- At this point, we will modify the text belonging to the two labels of the Details Footer section. On the upper label, we will place the text Total Customers, on the lower one we will put Total Amount:
- We will now modify the SumQty function so that it performs a sum on the
sum_amountfield. We will access the Data Panel (Panel tab), inside Functions we will select SumQty and change the following:- Field Name:
sum_amount
Note
We should modify the Function Name of this function, as well as the Product Counter one, but these modifications will not be done now so that we do not introduce too many extra steps. Feel free to perform these changes in your report.
- Field Name:
To see what our report looks like so far we can use the Preview option.
What just happened?
We configured the Details Footer section to be repeated on every page. Also, in this section, we delete the horizontal-line and we set its border top. We configured two labels and the function so that they match our current data set.
- Word/Excel/PPT 2007辦公應用從入門到精通
- Word／Excel 2016高效辦公從入門到精通
- Excel公式、函數與圖表應用大全
- Excel函數與公式標準教程（實戰微課版）
- 新編電腦辦公（Windows 10 + Office 2010版）從入門到精通
- Office 2016三合一職場辦公效率手冊
- WPS Office 2019 高效辦公
- AIGC高效辦公：Excel數據處理與分析（微課版）
- Word/Excel/PowerPoint三合一辦公應用
- 從零開始學Excel VBA
- 隨身查： 一小時搞定你想要的PPT
- Word、Excel 行政與文秘高效辦公必備
- Office 2013從新手到高手
- PPT進化：如何設計一份驚艷的PPT
- 新編Office 2007公司辦公入門與提高(修訂版)