shree909

Hi , I figured it out myself and will be helpful irfur looking to connect to DB2 First u need to add the db2java.jar file to the classpath then add the db2 jar files then u can enable the jdbc DB2 active. Add Jdbc driver: com.ibm.db2.jcc.DB2Driver Jdbc Url :jdbc:db2://<Hostname>:<port no>/Database name After this u can get connected.. Regards sree

Hi, I am trying to connect to IBM DB2 database. i have added the 2 jar files to the classpath and the lib file . still i am not able to enable the IBM driver on the ireport. i have gone through the community and i was asked to install the db2java.zip file. what does this file means and where can i download from the web. i searched in goolge but i dint find. if someone could help me in esatablishing a connection to the ibm db2 database that would be really helpful.

Hi where can i donwlaod the db2java.zip file. when i go through the ibm website its asking for login credintials i am not an ibm employee, is there a way that i can get downloaded from any site. Thanks

Hey thanks for the reply.. one more thing i need to todo som Adhoc Reporting.. with the server. i am not able to get those options when i installed the server. IS there a different software that can be downloaded.. i am using the community version of server.. Do jaspersoft provide the server other than community version if so plz provide the link.....

Hi, i installed the jaspersoft server and the license got expired and i want to install the new copy and get the license for 30 days. when i intallled the new version and deleted the old version till i get the same error message sayinf that my license has been expired. so how to get the license for 30 days trial for one more time... ]

Thanks for the reply. is there a way that we can do it in the ireport. rather than in etl.

I think u have left same space after the field name in the band. if u compress that band to the field names that u will get avoid the extra space ..

Hi, I have a .csv file with table name ABC and fileds A,B,C,D,E......so on. i get daily one file with all the above filed names same. so how i can load the files into jaspersoft?????????

Thanks for the reply..The reason why i am not able to change the value into currecy mode is the , the value which is coming from database has a string value, when i changes that to the .bigdecimal then it started accepting the formation of the values..

I iI figured it out that we can use the symbols in the text fields and static text only with + operator and enclosing the text in double quotoes.

Hi i am trying the change the number format to the Money value . when i try to change the field patter value to the currency its not displaying the value. Is there a way that i could do it with some coding like" $ #,##0.00".. i tried this but throwing an error. could some one look into this issue. I am new to Jaspersoft and trying to build some reports. is there a good material other than ireport guide and videos .. Helpful answers would be appreciated../ Thanks