topic Re: How can i generate report? in Alfresco Forum

How can i generate report?

vamsinipun — Tue, 28 Nov 2017 12:46:36 GMT

Hi,I am using activiti in my spring web application. i register students data every data. I would like to generate a report which contains one month data of registration. How can i generate?

Re: How can i generate report?

fegor — Wed, 29 Nov 2017 17:00:07 GMT

Hi!

But what do you want to do exactly? You can use the integration of JasperReports or Freemarker or XML, or Apache POI to generate Word documents, and so on.

Regards.

Re: How can i generate report?

vamsinipun — Thu, 30 Nov 2017 05:12:47 GMT

Ya you are right. I will explain details of my issue. Assume one process which represents student registration and approval. it has two tasks. Those are

1. Registration Task

it contains following fields like registration date, name, registration no, dob and address.

2. Approval Task

it contains fields like approval checkbox

Now i need a report like how many students are registered in given from date and to date with student details. The report like

From Date: 20/11/2017 To Date: 30/11/2017

Registration Date | Name | Registration No | DOB | Address

Re: How can i generate report?

fegor — Thu, 30 Nov 2017 08:18:31 GMT

Ok, this is more functional what operational but, i think you can save this information (date, name,...) in a relational database and after you can use this information as a datasource from JasperReports for example.

Re: How can i generate report?

vamsinipun — Thu, 30 Nov 2017 08:59:44 GMT

K. We need to maintain this information in separate tables. So, i will maintain activiti tables and my custom tables both. right?

Re: How can i generate report?

fegor — Thu, 30 Nov 2017 09:06:10 GMT

Yes, then you can duplicate this information or use de history services os tasks:

historyService.createHistoricDetailQuery().variableUpdates().taskId(historicTask.getId()).list();