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.

  1. 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.

  2. We will delete horizontal-line from the Details Footer section.
  3. 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
  4. 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:
    Time for action – modifying the report's footer
  5. We will now modify the SumQty function so that it performs a sum on the sum_amount field. 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.

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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset