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

 

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


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
176469
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago
Feedback