Creating an Alarmlist

[jan.petersson]

Hi,

I´m trying to create an alarmlist over aq period of the last 24hours, where the number of the alarm is coming from a sql database but the Alarm text is coming from a CSV file

and I want to substitue the number from sql with the coresponding text from the csv file.

I´m using Ireport 5.1

I created a report and asked the sql query, got the number ok. tested it in a listkomponent and got a list of the numbers for the last 24h. all good so far.

tried to create a parameter for the second connection named csvconnection  of type net.sf.jasperreports.engine.data.JRCsvDataSource with its default value as following: new net.sf.jasperreports.engine.data.JRCsvDataSource(new File("E:\andi2\ANDI_HOME\reports\Álarmlists\larmAM6Will.csv"))

but how to use it in the listkomponent as described above is beond me

anywone?