bandellwork

Update. I used the sum Sales_Sum automatically generate by iReports. The problem now is that it keeps a running sum from month to month. So Jan the bar would be 13500 Feb 27000 and so on. Is there a way to reset sum to 0 for each month?

I am working on a school project and need a little help. A little background of what I am trying to do. I have a query that brings back sales totals for each month of a year for products, services, and maintance. so the results look like the following. Month Sales ProdOrSales Jan 10000 Services Jan 2500 Products Jan 1000 Maintance Feb 9000 Services Feb 3000 Products Feb 1500 Maintance and so on for each month I am trying to create a multi axis chart that includes a line graph and a bar graph. The line graph works the way I want it to. Each category has it's own line (Services, Products, Maintance). I am having problems with the bar graph. I want the bar graph to total all three categories for each month. However it only goes up to the category that has the highest amount. Any ideas on how I can sum the totals for the month. Thanks for any help.

I found the problem. iReports was pointing to jdk1.6.0_29 which has a bug with the driver manager. The line, DriverManager.getConnection(theConnectionString, theUserName, thePassword); get hung when running a java application. So I download jdk1.7.0_02 and pointed iReports to that jdk and now it is able to connect to the database.

I recently downloaded iReport 4.5.0 an upgrade from 4.1.0. However when I imported the settings and try to run a report the report output would just say FILLING Report. So I went to test the connection and as soon as I click test the application freezes. I have the sqljdbc4.jar in the class path and all of the same jars as in the older version. I even went back to the old version and now it also freezes when test is click. Any ideas what the issue could be?

Ok so I think I norrowed down the problem. The database was recently updated to SQLServer 2008 from 2005. When I try to test the connection the ireport just hangs and I have to eventually end the process. I still have the jdbcsql4.jar file in the class path so I am not sure why it is getting hung. Any ideas?

I have a report already developed in iReport designer. However when I went back to make a vew minor change I upgrade from 4.0.2 to 4.1.3. I import the old settings and the sql jar file to connect to the database however when I try to preview the report the preview never opens. I get the following in the output. Compiling to file... C:Userschristopher.m.bandelDocumentsiReportsMemoADST.jasper Compiling subreports.... Subreport C:Userschristopher.m.bandelDocumentsiReportsMemorandum_subreport1.jrxml already compiled. Subreport C:Userschristopher.m.bandelDocumentsiReportsMemorandum_subreport2.jrxml already compiled. Charset used: UTF-8!!!! Compilation running time: 57,558! Filling report... Locale: English (United States) Time zone: Default Any help would be appreciated.