Using Render Events on Data Bands in Report Designer

Using Render Events on Data Bands in Report Designer

The articles in this section of the Knowledge Base involve working with Lists for display in your reports. To learn more about Lists and how to access the Report Designer, see Creating Lists in Report Designer. This article provides information on applying events to your data bands for use in your reports.

There are three special events that can be applied to a Data band, Rendering Event, Begin Render Event, and End Render Event. If there are ten rows in the Data Source to which the Data band has been assigned, then the Data band is printed ten times. The Begin Render Event is called before the data is rendered. It can be used to initialize some data as variables and calling some actions. The End Render Event is called after the data has been rendered when all data rows have been output. It is used for total calculation processing, amongst other things. The Rendering Event is called when rendering one data row. It is called before the Data band is printed. If there are ten rows in the Data Source, the Rendering Event is output ten times.

The following tutorial provides an example for working with these events:

  1. Create the “myvariable” variable in the Data Dictionary.
    1. Select the Page tab > select Panels > select Dictonary.

    2. Fig. 01 – Dictionary

    3. Select New Item > New Variable.

    4. Fig. 02 – New Variable

    5. From the New Variable window, create a new int type variable named “myvariable.” See Figure 03.

    6. Fig. 03 – New Variable Dialog

  2. Close the Dictionary Window > select the Data band for the event to be applied to > select the Events tab > write the following code in the Begin Render Event:
  3. myvariable = 0
  4. Add the following code to the Rendering Event:
  5. myvariable = myvariable + 1

    Fig. 04 – Render Events

    The End Render event is not used in this case.

    The myvariable variable that you added acts as a counter for the number of rows in the Data Source. Before the rendering starts, myvariable equals zero. Each subsequent row that is rendered from the Data Source adds one to myvariable, resulting in the total number of rows/items in the Data band.

  6. Enter the following expression into a text component where you want the myvariable value to be displayed:
  7. {myvariable}

    Fig. 05 – “myvariable” Text Component

    I added “Count:” to the beginning of the expression in Figure 04, for appearances.
  8. Set the Process at property of the Text Component to End of Report.

  9. Fig. 06 – “Process at” Property

  10. Process your report. Your results should look something like Figure 07.

  11. Fig. 07 - Report Example

    • Related Articles

    • Using Render Events on Group Header Bands in Report Designer

      The articles in this section of the Knowledge Base involve working with Groups for display in reports. To learn more about Groups and how to access the Report Designer, see Understanding Groups in the Report Designer. This article details Events in ...
    • Understanding Report Bands in Report Designer

      The articles in this section of the Knowledge Base involve working with Report Bands for display in your reports. To access the Report Designer, select Toolbox Setup > Design Reports > Design (Report Type) Report. Select New Report to design a report ...
    • Understanding Empty Data Bands in Report Designer

      The articles in this section of the Knowledge Base involve working with Empty Data bands for display in your reports. To access the Report Designer, select Toolbox Setup > Design Reports > Design (Report Type) Report. Select New Report to design a ...
    • Understanding Child Bands in Report Designer

      The articles in this section of the Knowledge Base involve working with Child Bands for display in your reports. To access the Report Designer, select Toolbox Setup > Design Reports > Design (Report Type) Report. Select New Report to design a report ...
    • Understanding Page Bands in Report Designer

      The articles in this section of the Knowledge Base involve working with Page Bands for display in your reports. To access the Report Designer, select Toolbox Setup > Design Reports > Design (Report Type) Report. Select New Report to design a report ...
    • Recent Articles

    • Toolbox Release Notes | Build 25.1.1204.641

      The following release notes apply to Toolbox build 25.1.1204.641 Toolbox Login Screen Update Fig. 1: The updated Toolbox Login interface. The Toolbox Login interface has had several changes applied to it to enhance its usability and allow for greater ...
    • Toolbox Release Notes | Build 25.1.1120.641

      The following release notes apply to Toolbox build 25.1.1120.641 Mouse Wheel Fix There was a reported issue in certain interfaces (such as report groups) in which hovering over a dropdown menu (such as Output Type) would result in the options within ...
    • Dynamic Dimensioning in Toolbox BSB

      When applying dimensions to products and other solids in Toolbox BSB, by default, all dimensions are drawn in 2D on the Y plane, requiring one to switch to a top view (or an appropriately high isometric view) to see them. BricsCAD has a feature that ...
    • Toolbox Release Notes | Build 25.1.1107.641

      The following release notes apply to Toolbox build 25.1.1107.641. Subassembly Prompt Fixes A pair of issues were reportedly occurring when attempting to work with subassembly prompts in the Edit Design Data interface. Subassemblies copied to the ...
    • Microvellum Foundation Library Release Notes | Build 25.1024

      The following release notes apply to the Microvellum Foundation Library build 25.1024. Additions Added Face Profile Options to the Door Wizard for enhanced design flexibility. Users can now apply decorative visual profiles to doors, drawer fronts, ...