aviral7187

fyi java version - 1.6 tomcat version - 5.5.20 given driver: com.microsoft.sqlserver.jdbc.SQLServerDriver given url: jdbc:sqlserver://host:1433;databaseName=yourDatabase

Hi I started working with JasperServer and iReports recently. I successfully created a report in iReport, and wanted to deploy it to JasperServer. The data source for the report id SQL Server 2008. The problem is that whenever i try to add a data source in jasperserver and test connection it gives the following error The server encountered an internal error () that prevented it from fulfilling this request. org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.UnsupportedClassVersionError: Bad version number in .class file I have included the jar file for Sql Server 2008 - sqljdbc4 in the lib folder of tomcat which is \jasperserver-pro-3.7\apache-tomcat\common\lib Please help and let me know how can i establish the JDBC connection to Sql server 2008. Thanks in advance Aviral

Hi Carl, Thanks a lot for your help. I will get back to you as soon as my reports start working. Thanks again Cheers Aviral

Hi, I started working with iReports a week back, and found it really good. But now i am stuck with an issue. I dont know how to create a drill down chart. I have made 3 charts using chartspro. The first chart gives the total sales for 3 months, the second is total sales breakdown zone wise, the third is total sales break down city wise in each zone. I want to make a drill down chart, where, when the user clicks the columns representing the monthly total on the 1st chart, the 2nd chart comes up for that month, and when the user clicks on the zone column in the second chart, the 3rd chart comes up. I have tried including subreports, but that doesnt solve the purpose. Any help would be appreciated. Thanks Aviral