The Reports Designer
Index
- Create a Chart
- Create a Simple Report
- Create a Master-Detail Report
- Deploy Analyst BI on external server
Introduction
Reports Designer is a DbSchema tool featuring different types of charts and customizable database reports. The Report sheets can interact with one another.
Open the Sample Project

The Reports Wizard

The Designer Structure
The designer contains the main panel 'Panel'. This contains cells. Inside any cell, we can place other panels or tables, with their own cells, etc. Like this, we can build a hierarchy of tables and panels. Different panels and tables are using different colors (green, blue, etc.).

Our report contains a panel and a table. The table is placed in one of the panel cells. This cell is merged on the right with the other cells from the same row. Empty cells are marked with a solid line, and cells having a component with a dotted line.

Table Properties

Insert Columns or Rows and Merge Cells
Right-clicking the chart cell you can add other rows or columns. You can select multiple cells and merge them.

Create New Components

Create a Report
Similar to a chart, you can create reports. This report was created using the 'offices' table wizard.

Interaction Between Sheets


Sheet Properties

Create a Master-Detail Report
From the wizard you can create master-detail reports. In the image below, we list offices with their employees.

As we can see, there are two tables imbricated one in another.

The first table data source query is:
SELECT * FROM "PUBLIC".offices
And the second table data source query is:
select * from employees where `officeCode`='${officeCode}'
The queries are parsed using Groovy templates, where the ${...} and <%....%> are considered Java expressions.
These expressions are receiving the data from the parent containers (tables, panels) data source queries as variables.
The officeCode variable is generated by the first table data source query and is used in the WHERE clause of the child table data source query.
Notice the quotes: '${officeCode}', as this is a string in the query.
How to Create a Chart
From the Wizard you can choose to create a chart. The chart needs to be configured and is not yet visible. Click the red cell in the designer to configure the chart.

Configure Chart Axis

Last Changes
Here I changed the chart type to 'Pie' and I edited the data source script to order the countries by population, with a limit of 20 countries. Press 'Apply' and you should see the chart below.

The data source looks like this:

View Chart in System Browser

Deploy Tomcat WAR
The Analyst BI sheets can be deployed as Tomcat WAR applications and can run independently. You can export the created application under any tomcat instance.
- Download and install Tomcat. The installation file is usually a zip file that you have to unpack. Go to the 'bin' folder and execute 'startup.bat'. This will start the tomcat server. This may request to set the JAVA_HOME variable pointing to your current Java installation folder. Do this by pressing the 'Win' key ( with the Windows logo ) + Break, then 'Change settings' / 'System properties' / 'Environment Variables'. After setting JAVA_HOME you will have to close and reopen the command prompt and execute again 'startup.bat'.
- Edit the tomcat-users.xml file from the tomcat conf folder.
<role rolename="tomcat"/> <user username="tomcat" password="tomcat" roles="manager-gui"/>
- Restart the Tomcat server.
- Login on 'http://localhost:8080' and follow the link 'Manage App'. There you can upload the generated war file.
- Browse to 'http://localhost:8080/war_file_name'