Business Objects - Configuring a Report to Display Globals (with Databands)

Business Objects - Configuring a Report to Display Globals (with Databands)

This is the third in a series of three tutorials that demonstrate how to configure Microvellum Business Objects in a sample report. This tutorial assumes that you have a basic understanding of Business Objects in Microvellum reports. Click  here   to see an overview of the subject.

It also assumes that the Business Objects have been set up in the report dataset. Click  here   to view the procedure for configuring them in the report dataset. This must be finished before attempting the procedure in this tutorial.

Click  here   to see a useful tutorial on how to set up a report using Business Objects using subreports.

This tutorial will focus on how to configure a report to display a custom global variable that has been added to the default global variables. It will assign that global value to a report variable that is then used in report calculations.

Global variable name:  Minimum_Cost_Panel_Report2

  1. Configure the global variable as a Business Object using the procedures in earlier tutorials. Click the button Edit Data Source from the report viewer screen to enter the Report Setup area to do this.

    2. Fig. 1


  2. Add and configure a report variable of type decimal to contain the Business Object global value.

    3. Fig. 2 


  3. Add a databand and set up the filter for only one specific global variable value.

    4. Fig. 3


  4. Add event code at the appropriate level for what you are trying to accomplish. In this case, it should be in the After Print event and should be the following value: decMinimum_Cost_Panel_Report2 = EstimateProject_GlobalVariables.Value.

    This expression sets a variable value with a global variable value.


    5. Fig. 4


  5. Add text components to display the variable value, and one to perform a calculation on that value.

    6. Fig. 5



    Fig. 6



    Fig. 7


Here is the rendered report:


Fig. 8


You may also download the import file for this sample report created using this article.


    • Related Articles

    • Business Objects - Configuring a Report to Display Globals (with Subreports)

      This is the second in a series of three tutorials that demonstrate how to configure Microvellum Business Objects in a sample report. This tutorial assumes that you have a basic understanding of Business Objects in Microvellum reports. Click  here  to ...

    • Business Objects - Configuring in a Report Dataset

      This tutorial is the first in a series of three that demonstrates how to configure Microvellum Business Objects in a sample report dataset. Click here   for an overview of how they are intended to be used. We will set up the dataset to contain the ...

    • Using Business Objects in Reports (Overview)

      The term "Business Object" is used in Microvellum to describe an object or entity that encapsulates or contains data. The Microvellum Business Objects are used in reports. They are set up when configuring the report dataset and contain either the ...

    • Understanding Sub Reports in Report Designer

      The articles in this section of the Knowledge Base involve working with the Sub Report component for display in your reports. To access the Report Designer, select Toolbox Setup > Design Reports > Design (Report Type) Report. Select New Report to ...

    • Working in the Sub Reports Editor of Report Designer

      The articles in this section of the Knowledge Base involve working with Sub Reports for display in your reports. To learn more about Sub Reports, and how to access this section within the Report Designer, see Understanding Sub Reports in Report ...

    • Recent Articles

    • Toolbox Release Notes | Build 25.1.0213.641

      The following release notes apply to Toolbox build 25.1.0213.641. Stay Down Nesting Additions 3 new settings have been added to Stay Down Nesting, to resolve specific issues with routes and connectors that have been reported: Fig. 1: New options in ...

    • Toolbox Release Notes: Year of 2024

      This document will catalog all releases for Microvellum Toolbox software builds that were released in the year 2024. This encompasses builds 24.1.0104.641 to 24.1.1206.641. Toolbox Release Notes | Build 24.1.1206.641 The following release notes apply ...

    • Toolbox Release Notes | Build 25.1.0129.641

      The following release notes apply to Toolbox build 25.1.0129.641. SMA Fixes A wide variety of issues with the Solid Model Analyzer have been resolved. Multiple modifications to existing interfaces or settings have been made to improve precision and ...

    • Microvellum Foundation Library Release Notes | Build 25.0124

      The following release notes apply to Microvellum Foundation Library build 25.0124. Additions Added Century Components Waste Bins, Vanity Organizers, and Base Cabinet Organizers. 11”, 14”, 17” Signature Series Bottom Mount 34qt & 50qt. 4”, 5”, 6”, 9”, ...

    • SQL Server Backups

      This article will list out the various types of backups you can create for databases hosted on an SQL Server, explore methods for creating backups manually and automatically, as well as list software/services that may assist you with backing up your ...