nkendrick

EDIT: *** Deleted by Author *** Turned out to be a non-problem! Post edited by: nkendrick, at: 2008/03/27 15:32

Hi, I am trying to make a unique (but repeatable) reference by concatenating a string with a timestamp as part of an Access 97 query via the Sun ODBC-JDBC connector: tbl_PET_Pet.Pet_Time_Updated + tbl_PET_Pet.PET_Pet_Reference as uniqueid The report complains that the textfield cannot be cast from a timestamp to a string so I have tried various permutations in the query, such as: cast (tbl_PET_Pet.Pet_Time_Updated as varchar(20)) + tbl_PET_Pet.PET_Pet_Reference as uniqueid, But the query won't build - Missing Operator. Am I getting the syntax wrong for an ODBC query? Any ideas?

Hi - can you put comments in queries using the Sun ODBC-JDBC connector? /* This does not work and throws an error */ I have tried a few other delimiters too without success. Thanks

Hi, I am doing some testing in ireport 2.0.2 (also tried 2.0.1) with the following query on a mysql database: select a.maindate, a.accbook_clientid, a.transid, a.odate, a.surname from (select accbook.`clientid` AS accbook_clientid, transid, accbook.date as odate , clients.surname as surname, case when length(accbook.date) = 8 then STR_TO_DATE(accbook.date,'%d-%c-%y') when length(accbook.date) = 10 then STR_TO_DATE(accbook.date,'%d-%c-%Y') else '1970-01-01' end as maindate from accbook left join clients on (clients.clientid = accbook.clientid))a order by a.maindate In phpmyadmin this query takes about 15 seconds to process about 396K records but when I run it in ireport, after a few minutes I get: Error filling print... java.lang.OutOfMemoryError: Java heap space null java.lang.OutOfMemoryError: Java heap space at java.text.RuleBasedBreakIterator.readTables(Unknown Source) at java.text.RuleBasedBreakIterator.<init>(Unknown Source) at java.text.BreakIterator.createBreakInstance(Unknown Source) at java.text.BreakIterator.getBreakInstance(Unknown Source) at java.text.BreakIterator.getLineInstance(Unknown Source) at java.text.BreakIterator.getLineInstance(Unknown Source) at java.awt.font.LineBreakMeasurer.<init>(Unknown Source) at net.sf.jasperreports.engine.fill.TextMeasurer.renderParagraph(TextMeasurer.java:288) at net.sf.jasperreports.engine.fill.TextMeasurer.measure(TextMeasurer.java:249) at net.sf.jasperreports.engine.fill.JRFillTextElement.chopTextElement(JRFillTextElement.java:535) at net.sf.jasperreports.engine.fill.JRFillTextField.prepare(JRFillTextField.java:543) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:343) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:323) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:282) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1382) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:692) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:275) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:791) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:695) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:943) at java.lang.Thread.run(Unknown Source) Print was not filled. Try using an EmptyDataSource... All advice appreciated. Thanks

Hi, is there an easy to follow guide on using iReport with MS Access? I have got to grips with connecting to mysql and MS-SQL data sources and Access is my next challenge! Any input would be appreciated. Also, is it possible to connect to remote Access databases by opening some key ports on a router/firewall? Thanks

Hi Svenn, Yes, the path is right because the reader does start, but it immediately days it cannot find the file. It seems as if the folder+file name string being passed from 1Report to Acrobat contains the wrong information.

Hi Folks, At the end of a very long day (my first with iReport) I managed to post the questions below in the wrong forum so here they are again in all their glory. All feedback appreciated. 1) One thing I have not been able to sort is directly viewing a PDF report in iReport. I have set up my path to the external app (Acrobat Reader 8: C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe), which duly fires up, but then comes up with an error dialogue ending 'the file cannot be found'. If I have a hunt around I *can* open the PDF by clicking on it in Windows explorer so the PDf is being generated. 2) I have created a report that picks up a couple of 'datetime' fields from a mySQL database. The fields are in the form YYYY-MM-DD HH:MM: SS (extra space to avoid auto-generated emoticon!), where the time is always 00:00:00 On some lines in the report, the displayed datetime is correct, but on a few the date shown is 1 day early and the time is shown as 23:00:00. Since the time part is not actually needed, I have modified the field selection to format it to 'date_format(emp_birthday,'%d/%m/%Y')', which seems to have fixed the problem, but I am curious as to why the 'raw' field is sometimes not right and would appreciate knowing whether the behaviour is as expected and/or might trip me up in the future if I don't notice what it's doing? Thanks

Hi, I have created a report that picks up a couple of 'datetime' fields from a mySQL database. The fields are in the form YYYY-MM-DD HH:MM: SS (extra space to avoid auto-generated emoticon!), where the time is always 00:00:00 On some lines in the report, the displayed datetime is correct, but on a few the date shown is 1 day early and the time is shown as 23:00:00. Since the time part is not actually needed, I have modified the field selection to format it to 'date_format(emp_birthday,'%d/%m/%Y')', which seems to have fixed the problem, but I am curious as to why the 'raw' field is sometimes not right and would appreciate knowing whether the behaviour is as expected and/or might trip me up in the future if I don't notice what it's doing? Thanks edit: Apologies - this should be in the iReport forum (it's been a long day) Post edited by: nkendrick, at: 2007/09/14 23:19 Post edited by: nkendrick, at: 2007/09/14 23:21

Hi Folks, I'm on a steep learning curve with iReport (1.5 days so far), but I am making good progress and have 'bought the book'! One thing I have not been able to sort, though, is directly viewing a PDF report in iReport. I have set up my path to the external app (Acrobat Reader 8: C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe), which duly fires up, but then comes up with an error dialogue ending 'the file cannot be found'. If I have a hunt around I *can* open the PDF by clicking on it in Windows explorer so the PDf is being generated. Any tips? Thanks edit: Apologies - this should be in the iReport forum (it's been a long day) Post edited by: nkendrick, at: 2007/09/14 23:20 Post edited by: nkendrick, at: 2007/09/14 23:21