Greetings.
I have complex grouping need to be done on data, which i dont want to do on database side, with embedded scripting it is not possible either, i have been trying to intercept data from report with Java scriptlet, modify it and put it back in, the problem is that i need whole dataset to do the grouping and the only method in scriptlet which allows me get extracted data is afterDetailEval() which is run by engine last in scriptlet as it seems so i have no other way to put data back in.
Second thing i have tried is setting up a custom data source implementing JRDataSource, which extracts data from db, and implementing JRDataSourceProvider for factory. Now, when i create new data adapter in Studio for factory i implemented running preview produces db Connection error even though i have added MySql Connector jar to project path.
Third thing i have tried is following community documentation instructions for implementing custom data sources
which involves implementing ReportDataSourceService and i can not find this interface in any of the library repositories provided on web. And if i use this method i cant figure out how i can use class implementing ReportDataSourceService in Studio...
My set up : i use MySql as db for jasper server and for data, not sure about what studio has embedded. I use latest community editions for server and Studio. I create my templates in Studio and export them to server. In my case i have to get data with Java somehow and fill it in template after processing. I want to be able to do it in Studio for faster testing as well as be able to export this set up to server for user to interact. Couple of parameters have to be put in by user in my case. Also i will have couple of subreports in my report which run sql queries directly against same db.
Attaching some files that i have been trying to solve this with.
Please advise how can this problem be solved. Thank you.
TravelDataBean.java
TravelDataSourceFactory.java
TravelRow.java
TravelScriptlet.java
BeanDataAdapter.jrdax
Blank_A4.jrxml
DataAdapter.jrdax
