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:
- Create the “myvariable” variable in the Data Dictionary.
- Select the Page tab > select Panels > select Dictonary.
Fig. 01 – Dictionary
- Select New Item > New Variable.
Fig. 02 – New Variable
- From the New Variable window, create a new int type variable named “myvariable.” See Figure 03.
Fig. 03 – New Variable Dialog
- 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:
myvariable = 0
- Add the following code to the Rendering Event:
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.
- Enter the following expression into a text component where you want the myvariable value to be displayed:
{myvariable}
Fig. 05 – “myvariable” Text Component
I added “Count:” to the beginning of the expression in Figure 04, for appearances.
- Set the Process at property of the Text Component to End of Report.
Fig. 06 – “Process at” Property
- Process your report. Your results should look something like Figure 07.
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.0114.641
The following release notes apply to Toolbox build 25.1.0114.641. UI Fixes Several issues were reported and discovered within the OEM 2025 user interface. The following issues have been resolved: Fig. 1: Excess commands on the tool strip being ...
Toolbox Release Notes | Build 25.1.102.641
The following release notes apply to Toolbox build 25.1.102.641 Toolbox OEM 2025 Work smarter, and faster with Toolbox 2025 (OEM). With an OEM Subscription, you’ll gain access to the latest toolsets and innovative features of Toolbox 2025. ...
What’s New in Toolbox 2025 (OEM)
Work smarter, faster with Toolbox 2025 (OEM). With an OEM Subscription, you’ll gain access to the latest toolsets and innovative features of Toolbox 2025. Improvements Toolbox UI Overhaul OEM 2025 introduces several updates to the appearance and ...
Toolbox Release Notes | Build 24.1.1206.641
The following release notes apply to Toolbox build 24.1.1206.641 MV Server Nesting Fix There was a reported issue occurring when users attempted to remotely process work orders using a nesting station on MV Server. When attempting to process the work ...
Microvellum Foundation Library Release Notes | Build 24.1127
The following release notes apply to Microvellum Foundation Library build 24.1127. Additions Added a new Soffit product to the Upper Cabinet Accessories category. Added the Top Filler (Ceiling Scribe) option to Upper and Tall cabinets. (Corner ...