How to create output on jasper based on input in bonitasoft

Q&A
1

I have some problem. Does anyone here know how to create an output(PDF) on jasper with the input from bonitasoft? For example, I input some data into bonita and that data store on database. And I want the same data to output on jaspersoft studio file(.jrxml).

Thanks.

2

Hi.
The jrxml file is a input file that you need to create with a tool like Jasper IReport.
Then you can use this file as an input in the Jasper connector for Bonita and create your pdf report.

You can find some informations here :
http://community.bonitasoft.com/answers/create-custom-report-using-jasper#node-16125

3

Adding to the note above. Follow the below steps to query the data from Bonita data source into Jasper studio report.

  1. Define bonita connection/datasource details in the studio.
    The bonita datasource details can be found from bitronix-resources.properties which is located in bonita conf folder.
  2. Define the query that loads the required fields that need to be displayed in the report. At this moment you would need to understand the Bonita Data model and different tables
    where the process data is stored. Some of the major tables that need to know are,
    a) Process_Instance - where all data related to case creation (open cases) are stored.
    b) Data_Instance - where all variables data is stored. This table has FK relation to Process_Instance table via containerid column
    c) Arch_Process_Instance - where all archived case data is stored.

You can connect to databse based on vendor type, for example by default Bonita uses H2 database. I know this information is not sufficient, but you can connect to db and explore more about the data model.

One final point is, bonita stores the case variables data into Clob, and Blob except Integer data types. For example Date variable would be stored into clob as xml like ####. Let me know if you need any more help.

Thanks,
Hari Alla

4

I got through this way: http://documentation.bonitasoft.com/jasper-50-0

5

Adding to the note above. Follow the below steps to query the data from Bonita data source into Jasper studio report.

  1. Define bonita connection/datasource details in the studio.
    The bonita datasource details can be found from bitronix-resources.properties which is
    located in bonita conf folder.
  2. Define the query that loads the required fields that need to be displayed in the report. At this moment you would need to understand the Bonita Data model and different tables where the process data is stored. Some of the major tables that need to know are,
    a) Process_Instance - where all data related to case creation (open cases) are stored.
    b) Data_Instance - where all variables data is stored. This table has FK relation to
    Process_Instance table via containerid column
    c) Arch_Process_Instance - where all archived case data is stored.

You can connect to databse based on vendor type, for example by default Bonita uses H2 database. I know this information is not sufficient, but you can connect to db and explore more about the data model.

One final point is, bonita stores the case variables data into Clob, and Blob except Integer data types. For example Date variable would be stored into clob as xml like ####. Let me know if you need any more help.

Thanks,
Hari Alla