Use CSV DataSource and change the data later with sql in Jaspersoft Studio



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

elias.tabarez.lopez's picture
Joined: Feb 2 2017 - 12:05pm
Last seen: 2 years 8 months ago

1 Answer:

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.

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago