Use CSV DataSource and change the data later with sql in Jaspersoft Studio
Posted on March 1, 2017 at 1:23am
I want to use a csv file as data source, but then i want manage data with sql sentences in Jaspersoft Studio, is it possible? Can I make charts or lists with the data as it is in csv files?
But then I want to manipulate the data with sql statements
Posted on March 1, 2017 at 1:43pm
You won't be able to manipulate csv data with sql statement using JasperReports. Try using something like hsqldb to use your csv data and then setup jdbc database to hsqldb.