danielbahn

Hello, I'm working with Jasperserver and iReport. I have a Report with a subreport(in the detail-band). In the subreport is a Query to a SQL-database. The subreport returns the value 'price' to the main Report into the variable 'price'. Now, I print the Price in the mainreport and it works, but now I have a variable "sum": type: double calculation: sum type reset: report countertype: nothing expression for variable: $V{price} initial value: $V{price} when I print this variable on the summary-band it gives me the sum of the price but it always forgets the last price of the detail-band! For example: 1. value of $V{price} in detail-band: 10 2. value of $V{price} in detail-band: 10 3. value of $V{price} in detail-band: 10 4. value of $V{price} in detail-band: 10 5. value of $V{price} in detail-band: 11 value of $V{sum} in summary-band: 40 why? can anybody help me please? Thank you so much

Thank you for your reply, Sorry, but I did not. Maybe it is a bug?!?

Hello, I hobe anybody can help me. I'm working with iReport 3.0.0 and jasperserver. I've got a report with a subreport. To the Main-report I give by parameter date values, The subreport get this parameters dircetly. In the settings of the subreport (in the Main-report) I added Parameters: Parameter: "von" Expression: "$P{von}" Parameter: "bis" Expression: "$P{bis}" When I print this parameters in the subreport they are correctly, but now, if I put them in the query (in the subreport) for example: select * FROM db.table0 table0 where table0.date >= $P{von} and table0.date <= $P{bis} the value of the Parameter, which I print for testing, increments automaticaly on every page?!? why?? I saw this at page 10, that the date is incremented by one day, then I looked at the time (It's a datetime field) it increments on every page. When I remove the parameters from the query. the values of the date-parameters do not change. Generally, parameters can not be changed from the report or not? thank you so much best regards