yobiwoo

Hi everyone, I need your help urgently. I have try to connect SQL server to Jasperanalysis but failed.I have attach some print screen.Hope u all can help me.thank u in advance.

Hi, thank u for your reply. I would like to do as below A 1 Prodcut A 1.00 2 Product B 2.00 B C D E When we Click A, It should expand and show two extra record.hope you can help me.thanks

Hi Jasper Expert, Can Ireport or Jasperserver does Original Drill Down report WITHOUT using Hyperlink?I have attach the image sample.Hope anyone can assist me.Thank u in advances.

Hi cbarlow3, i have tested using your steps but i having below errors: Error Message com.jaspersoft.jasperserver.api.JSExceptionWrapper: Errors were encountered when compiling report expressions class file: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed: calculator_report1_1330656686625_286414: 211: expecting ')', found ':' @ line 211, column 27. 1 error Can u please help me.thank u in advance.

Dear Friends, As i have promise before that i will upload the documentation regarding the Connection steps.This is the steps that make you easy in do connection.Enjoy with JasperSoft.

Thank u very much Mr.mgeise.It work wonderful.The problem is conflicting between 1.5 & 1.6. Mine using java 1.6 but when i put both in same folder, it taking java 1.5 as default.thank u million sir.U really save my day.I will do full documentation with PrintScreen, so it will benefit everyone.thanks again.

Thank u very much sir for steps all.my IReport connection working fine.For the jasperServer I will go thru & let u know sir.thank u again.

Thank u very much Mr.mgeise, I have try your steps & still having same problem.Together i have attach my documents that have printscreen of settings all.Please correct me if i'm wrong in any steps.thank u so much again for your reply.

Hi, Everyone.Can anyone give me the steps how to connect to Ms SQL Server 2008 R2.So i can refer which step i might miss out.Later, i will do documentation & share it.so it will benefit so everyone.thank u in advance.

Thank u norcenmarco, i have put it in WEB_INF/lib. just wanna make clear that can jasperserver support Ms. SQL Server 2008 R2. thank u very much.

I have put the JDBC driver into the WEB_INF/lib folder and I have put sqljdbc-1.6.jar file int the buildomatic/conf_source/db/sqlserver/jdbc folder. I still didn't manage to connect to jasperserver but able to coonect to IReport using Ms. SQL server 2008 R2. Thank u in advance.

Hi mgeise, This is my Logs; 2012-02-23 17:26:49,234 WARN LoggerListener,http-8080-2:60 - Authentication event AuthenticationSuccessEvent: superuser; details: com.jaspersoft.jasperserver.multipleTenancy.MTWebAuthenticationDetails@fffc7f0c: RemoteIpAddress: 127.0.0.1; SessionId: 9F92FC28AD4CD296B279AA47BD7FEA7C 2012-02-23 17:26:49,234 WARN LoggerListener,http-8080-2:60 - Authentication event InteractiveAuthenticationSuccessEvent: superuser; details: com.jaspersoft.jasperserver.multipleTenancy.MTWebAuthenticationDetails@fffc7f0c: RemoteIpAddress: 127.0.0.1; SessionId: 9F92FC28AD4CD296B279AA47BD7FEA7C 2012-02-23 17:27:57,250 WARN ValidatorImpl,http-8080-6:259 - No rule for parameter [reportDataSource.name]. Using default validation on input=[success_connection]. 2012-02-23 17:27:57,250 WARN ValidatorImpl,http-8080-6:259 - No rule for parameter [reportDataSource.label]. Using default validation on input=[success connection]. 2012-02-23 17:27:57,250 WARN ValidatorImpl,http-8080-6:259 - No rule for parameter [reportDataSource.parentFolder]. Using default validation on input=[/organizations/organization_1/datasources]. 2012-02-23 17:27:57,250 WARN ValidatorImpl,http-8080-6:259 - No rule for parameter [_eventId_testDataSource]. Using default validation on input=[]. 2012-02-23 17:27:57,250 WARN ValidatorImpl,http-8080-6:259 - No rule for parameter [reportDataSource.username]. Using default validation on input=[sa]. 2012-02-23 17:27:57,250 WARN ValidatorImpl,http-8080-6:259 - No rule for parameter [reportDataSource.driverClass]. Using default validation on input=[com.microsoft.sqlserver.jdbc.SQLServerDriver]. 2012-02-23 17:27:57,250 WARN ValidatorImpl,http-8080-6:259 - No rule for parameter [reportDataSource.description]. Using default validation on input=[]. 2012-02-23 17:27:57,250 WARN ValidatorImpl,http-8080-6:259 - No rule for parameter [reportDataSource.password]. Using default validation on input=[rma2012]. 2012-02-23 17:27:57,250 WARN ValidatorImpl,http-8080-6:259 - No rule for parameter [reportDataSource.timezone]. Using default validation on input=[]. 2012-02-23 17:27:57,250 WARN ValidatorImpl,http-8080-6:259 - No rule for parameter [reportDataSource.connectionUrl]. Using default validation on input=[jdbc:sqlserver://CHAM-NB\SQL2008R2:1433;databaseName=cards]. Hope u can help me.

Hi uzair_zaman, I have folow your post in solving this problem but I still having the same problem & it said as normal "Connection fail".Hope you can quide in this.Anyone also can.thanks in advance.Its quite urgent my friends.thank u again.