Developer Center

Developer Handbook

Last Updated: Feb 02, 2018 03:10PM CET
Follow the points below to get to know more about Jasper reports, in general and when targeting Mambu.

Tutorials/user guides for leveraging Jasper specific knowledge:
Predefined Reports:
Jaspersoft offers a set of examples and usage details about reports packed into a project. These details covers the main available features case by case. Download the project and explore it to see how different widgets can be used and how your reports can look like. Follow the tutorial from there to get the examples compiled and filled with data.

Data Dictionary:
Creating Jasper reports requires working with Mambu DB. We maintain a data dictionary on our side with the tables and the relations between them. Explore each table, from its purpose, to its columns, types and required data. A few charts offer an overview for the most common entities as well. We recommend exploring the dictionary before starting working the reports.



Parameter Types:
Parameters are used as input values for reports. They can be used to filter the results of just to pass some data to be includedt. Mambu supports a few types of parameters:
  • String
  • Date
  • Boolean
  • Integer
  • Decimal
  • Double
To use them you have to declare the Jasper parameter to be of the according Java type (eg. java.util.Date for the date type). The result will be seen when opening the report's overview, where the input will be rendered into the according widget (eg. a Date widget). The type is also used in the input validation process, each one allowing only the intended values.
These parameters can also have a description, displayed in Mambu as a label, to be clear in purpose.




Default Parameters:
Mambu offers support for a few predefined parameters. These parameters, when used in specific contexts, get automatically completed at runtime.

As an example, let's assume a BRANCH_ID parameter is built into the logic of a report and the report associated with the Branch category to be available at the branch level. When running the report from the context of a branch (from its overview), Mambu will populate the ID without further input required from the user. If the same report is run directly from the Administration panel, the ID will have to be added by the user, as there is no branch context there. Follow the preview below to see in action a report containing both predefined and regular parameters or go further and try the Transactions per Account report example on your own.



The supported list of predefined parameters by report type are:
  • Clients/Groups
    • CENTRE_ID, CENTRE_KEY / GROUP_ID, GROUP_KEY
  • Branches/Centres/Users
    • BRANCH_ID, BRANCH_KEY / CENTRE_ID, CENTRE_KEY / USER_ID, USER_KEY
  • Loan Accounts/Deposit Accounts
    • ACCOUNT_ID, ACCOUNT_KEY
    • CLIENT_ID, CLIENT_KEY or GROUP_ID, GROUP_KEY
  • Loan Groups
    • ACCOUNT_KEY
    • GROUP_ID, GROUP_KEY
  • Loan Transactions/Deposit Transactions
    • TRANSACTION_ID, TRANSACTION_KEY
    • ACCOUNT_ID, ACCOUNT_KEY
    • CLIENT_ID, CLIENT_KEY or GROUP_ID, GROUP_KEY

Note: The names of the parameters should be identical when declared in the Jasper report. For example the BRANCH_ID parameter should have the P{BRANCH_ID} signature.

Jasper report configuration:
The result set compliant with the criteria is served in a paginated fashion, 10.000 items per page.  Make sure to build such pagination algorithm when expecting to work with larger sets of data to avoid unexpected truncation.

Supported Fonts:
Mambu currently supports the following fonts:
  • Deja Vu Serif
  • Deja Vu Sans
  • Deja Vu Sans Mono
  • Myanmar3 (regular type only)
  • Sans Serif (default font, not available for export)
These fonts work properly when they are exported to PDF and other file formats. Other fonts are currently not supported. Notice that Jasper Studio uses two sets of fonts fontName and pdfFontName (visible in the advanced section of the element), these two sets of fonts can be configured independently, which means that the report can render fine in a preview, but break when exporting to PDF if the font is not available. More information about fonts at the Jasper Reports Ultimate Guide (PDF, p. 128).

 

support@mambu.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete