Using data from an xls or a csv file. Is it possible?

[dragos_a]

Hi,

 

I need to make a report that will use data from an xls or csv file provided by the logged in user.

Is it possible to make a parameter that will allow the user to select an xls or a csv file and use the IDs from the file in a report, more precisley in the sql query of the report?

 

Thanks,

Dragos

[cmatthews]

 It is possible but you need to do some work in java/jsp, you can have the users provided data source uploaded to some known location that is used as the datasource property in jasperreports. I don't think there is an inherent method that supports the required need but it is completely do-able with some code and known constants.

Clark