Creating an Alarmlist

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?

jan.petersson's picture
Joined: Oct 3 2013 - 11:21pm
Last seen: 9 years 5 months ago

0 Answers:

No answers yet
Feedback