[Showing image from database]

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

[I give up,]

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.

[iSeries and JDBC connection using JTOpen]

where is the attached file

[iSeries and JDBC connection using JTOpen]

where is the attached file

[String convert to Date Format]

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()

[convert string variable to date]

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

[as400 help please]

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'

[as400 help please]

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

[forget other posts]

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

[Big Decimal]

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

[Help on installing on os x]

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

[Help on installing on os x]

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

[nothing shows]

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.

[as400]

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

[as400]

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.

[as400]

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.