Use CSV DataSource and change the data later with sql in Jaspersoft Studio
Posted on March 1, 2017 at 1:23am
Hello
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?
Thanks
But then I want to manipulate the data with sql statements
Joined: Feb 2 2017 - 12:05pm
Last seen: 2 years 8 months ago
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.
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago