How to connect to reporting database
Use your administrator account to login, in Administration->Database->Create New Database, fill-in related information. That's it.
JERT release package includes only jdbc driver for hsql. If you need to connect to other type of database, please add the corresponding jdbc driver lib to your classpath.
How to create report
After the database is created, we can begin to add desired reports.
In Administration->Reports->Create New
currently we have 3 reporting type we can choose from:
- A. STATIC_QUERY
Static sql query report; the user does not need to do any inputs to the report, we can freely input any sql query, such as:
select * from user
- B. SIMPLE_PARAMETER_QUERY
Simple fixed parameter query report; the user is required to input certain parameters in order to get query search results, such as:
select * from user where age > #age#. Here the parameter needs to be surrounded by "#".
- C. DYNAMIC_PARAMETER_QUERY
<plain>select * from user where 1 = 1 </plain>
<dynamic type="isNotNull" append-before="and age > " parameter-name="age"/>
<dynamic type="isNotNull" append-before="and sex = " parameter-name="sex"/>
When the user inputs only the age parameter, it will result in the following query:
select * from user where 1 = 1 and age > 18
When the user inputs age and sex parameters, it will result in the following query:
select * from user where 1 =1 and age > 18 and sex = 'male'
If the report has parameter(s), you need to set the parameter type.
Type: please set it according to the database parameter type
Optional: the parameter is not required
DefaultValue: the default value for the parameter
Import/Export Report Definition
In Administration->Reports->Export ALL To XML, this will export all the definition files in the database.
You can export single report definition by clicking on each report defintion.
In Administration->Reports->Import From XML, this will import the exported XML file back into database.
You can use this feature to do report definition backup, restore, or report migration across similar databases.