tlavalle

what database are you using, I have done it with oracle, mysql.

I have tried everything i can think of to convert a big decimal field to a date, but to no success. here is what i put in: Date date = (Date)(new SimpleDateFormat("yyyyMMdd")).parse("$F{@RDFDT}") this compiles, but i get errors when i run.

where is the attached file

where is the attached file

That doesn't work. I made a variable and converted my field to string, then proceeded to set the pattern on the properties window and the column looks like this MM/dd/yy 2006/01/01 the variable I have in the expression $f{<fieldname>}.toString()

I created a string variable named dos. i set it to the java.lang.string and then put this in the expression: $f{@rdfdt}.toString() DateFormat formatter = new SimpleDateFormat("yyyyMMdd") Date date = (Date)formatter.parse($f{@RDFDT}) i keep getting parse failed what or where did i go wrong? Post edited by: tlavalle, at: 2006/10/25 14:40

DOH!! I forgot you can do that. It seems to work except now i get SQL Problems:[sql0206]Column hdia1 not in specified tables here is my sql statement select h.@henc# as henc, h.@hdia1 as hdia1, h.@hdia2 as hdia2 from pfcfilso.@enchdr h where hdia1 = '27447' or hdia2 = '27447'

I need some help from someone who is knowledgable with the as400. I have my driver and url correct and working. the problem i am coming to is that the field names have @ in front of them, Also when i compile i either get delete tokens or a bunch of errors. How can I use the the field names with the @ in front or if not what is my best option. thank you in advanced Tony

When I connect to the as400 I get field names like @hatyp, I think the @ is throwing stuff how do I get past this.

I have a field that i am pulling out of an as400 database, I know the field has 2 decimal points but everytime i pull it and put it into the report i get: it.businesslogic.ireport.ReportClassLoader@46f93 net.sf.jasperreports.engine.JRException:ÂErrorsÂwereÂencounteredÂwhenÂcompilingÂreportÂexpressionsÂclassÂfile: 1.ÂSyntaxÂerrorÂonÂtokens,ÂdeleteÂtheseÂtokens ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂvalueÂ=Â(java.lang.String)($F{@HCHG$}); ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ<------> 2.ÂSyntaxÂerrorÂonÂtokens,ÂdeleteÂtheseÂtokens ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂvalueÂ=Â(java.lang.String)($F{@HCHG$}); ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ<------> 3.ÂSyntaxÂerrorÂonÂtokens,ÂdeleteÂtheseÂtokens ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂvalueÂ=Â(java.lang.String)($F{@HCHG$}); ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ<------> 3Âerrors ÂÂÂÂatÂnet.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:193) ÂÂÂÂatÂnet.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:105) ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:127) ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:109) ÂÂÂÂatÂit.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:507) ÂÂÂÂatÂjava.lang.Thread.run(UnknownÂSource) how can i fix this. Please help Post edited by: tlavalle, at: 2006/10/17 19:26

Ok, thats what i thought, but I just seeing if you guys knew of any other wya. Thanks.

Is there an installer for iReports for os x? Or can someone point me in the right direction to install on my MacBook pro?

I am generating a report, my guess is there is no data, but the title and date not showing, and the column headers are not showing. how do i fix this.

hmm, I got the library name, but the files are all header files can some one plz help me to pull this altogether?

Ok, I figured out the connection. the next step for me is how do i use the report wizard to poll in the library and setup the report using only the header files, or am i going to have to create a query in the as400. please can someone help me.

I am using ireports, and i love it. What i am trying to do is connect to an as400, i have the connection, but i can not find the database. can someone point int he right direction to find the DB.