volkerheun

I solved the problem. I used different drivers in iReport I use an older one that works and the newer form Microsoft doesn't. Volker

Hello, I have installed the community edition of Jasperreport and run in problems. I work with ireport for a long time and I have a connection to an MS SQL Server, which works very good. Now I create this connection on Jasperserver, import the report from iReport and the report doesn't work, with the following error. com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection The sqljdbc4.jar is in the Directory /opt/jasperreports/apache-tomcat/lib Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver URL: jdbc:sqlserver://IP:1433;DatabaseName=myDB Code: Any Idea whats wrong? Volker Post Edited by volkerheun at 08/15/2012 15:00

Hello all, I'm new to IReport. I've to generate a Report where the Group header should be printed depending on the GroupSum. I put in the sum-Variable in the "print when expression" but it doesn't word korrekt. For the Group-footer it works. Please help me. Volker

Hello, I've a Report with 2 Groups. the first group will be printed if an expression is true. Now I have the problem, that I want to have the values of the printed groups summed for the second group and the report summary. Is that possible? in incremtent typ I've set Group and as Increment Group I've set the first Group, but it doesn't work/tools/fckeditor/editor/images/smiley/msn/sad_smile.gif! I hope someone can help me. Volker

Hello Everybody, here I am again with a new problem. I've a report with open invoices. The invoices are grouped by customers. If the sum of all invoices is zero the group footer will not be printed. But I've no Idea how to supress the Group header from printing. Have anybody an idea? Thanks. Volker

Hi Christina, thanks a lot. Now it works. Volker

Hello Everybody, I'm new to iReport and run in problems. I have a Report, where a Date-Variable is calculated in Detail-Section. Depending on an other Field the variable get the value of a Date-Field or the Value '01.01.1901'. In the Group-Section I have to calcuate the maximum Value of this Date-Variable. Is that posible? I always get the last Value but not the maximum Value. Properties of the Detail Calculation Name: LastMovement Variable Class: Java.util.Date Calculation: Nothing Reset Type: Report Increment Type: none Variable Expression: $F{tdinv700_koor}.compareTo("StockOrder")!=0 ? $F{tdinv700_trdt} : new Date(01,0,1) Properties of the Group Calculation Name: LM Variable Class: Java.util.Date Calculation: Highest Reset Type: Group Reset Group: Item Increment Type: Group Incremten Group: Item Variable Expression: $V{LastMovement} Can anybody help me? Thanks.