Jump to content

maartenstachanov.com

Members
  • Posts

    32
  • Joined

  • Last visited

maartenstachanov.com's Achievements

Explorer

Explorer (4/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Collaborator Rare

Recent Badges

0

Reputation

  1. When I export a report to excel I get an exception saying that it can't add a cell. If I turn off the detectCellType it is no problem, but else I do have this problem. The report has normal patterns for dates and numbers (#,##0.00) and (yyyy-mm-dd) applicationContext.xml: [/code]I am using jasperserver 4.7.0
  2. After I follow the installation procedure for the war file, the war file and the mysql-connector are in the deployments folder. When I start the jboss server (7) standalone mode I get the error below, does anybody know a work around? (I already filed a bug report) ---- 17:48:47,049 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Starting deployment of "jasperserver.war" 17:48:53,295 WARN [org.jboss.as.server.deployment] (MSC service thread 1-7) Class Path entry avalon-framework-4.2.0.jar in "/home/maarten/apps/jboss7/standalone/deployments/jasperserver.war/WEB-INF/lib/fop-0.95.jar" does not point to a valid jar for a Class-Path reference. 17:48:53,303 WARN [org.jboss.as.server.deployment] (MSC service thread 1-7) Class Path entry batik-all-1.7.jar in "/home/maarten/apps/jboss7/standalone/deployments/jasperserver.war/WEB-INF/lib/fop-0.95.jar" does not point to a valid jar for a Class-Path reference. 17:48:53,312 WARN [org.jboss.as.server.deployment] (MSC service thread 1-7) Class Path entry commons-io-1.3.1.jar in "/home/maarten/apps/jboss7/standalone/deployments/jasperserver.war/WEB-INF/lib/fop-0.95.jar" does not point to a valid jar for a Class-Path reference. 17:48:53,320 WARN [org.jboss.as.server.deployment] (MSC service thread 1-7) Class Path entry serializer-2.7.0.jar in "/home/maarten/apps/jboss7/standalone/deployments/jasperserver.war/WEB-INF/lib/fop-0.95.jar" does not point to a valid jar for a Class-Path reference. 17:48:53,329 WARN [org.jboss.as.server.deployment] (MSC service thread 1-7) Class Path entry servlet-2.2.jar in "/home/maarten/apps/jboss7/standalone/deployments/jasperserver.war/WEB-INF/lib/fop-0.95.jar" does not point to a valid jar for a Class-Path reference.
  3. I have this problem that the regular report shows fine. However if I ask it to export it to excel I miss some columns in the report. How is this possible, and how can I prevent this from happening?
  4. From the log I see that it says that the recipient or the sender is not correctly filled. solution: correct the validation regexp. Did you try sending using a single e-mail address (if I glance over the regexp I see it does not match a ",") Code: Post Edited by maartenalbers at 03/15/2012 10:54
  5. set the default value for the Parameter to "%" (I thought I mentioned it...) Change the "=" sign to LIKE and you get what I said.
  6. shivasgk Wrote: I am using below syntax for getting records when user will not enter anything in prompt input ,total information to be displayed select*from mysql.responsetable where Response=$P{Please select response} or 1=1; Please suggest me that would be great help You could replace "=" with "LIKE" and have a default value for the $P{Please select response} = "%" Disadvantage people can also write stuff like "Lon%" which would result in other cities that start with "Lon" aswell.
  7. SELECT * FROM City WHERE name LIKE "%"; (is equivilent to SELECT * FROM City;) SELECT * FROM City WHERE name LIKE "London";
  8. Thanks: that looks promising. (Although it seems a bit peculiar behavior) I'll try it this afternoon.
  9. - create a subreport that returns a value. - assign the value in the main report to variable A - add a sum variable in the main report over A Tried to solve the problem using different evaluation times (report, now, auto, band) neither made a difference. (page, group, and column didn't make sense to me.) Code:database table `test` (id,v1):(1,10),(2,20),(3, NULL),(4,40),(4,50)
  10. Thank you for your reply, I did that and it shows up correctly in the band. However if I calculate a subtotal over v1 doesn't (eventhough I set the subtotal calculation time to now/auto/band/report.) Post Edited by maartenalbers at 02/15/2012 15:46
  11. Ok after some debugging I've narrowed down the problem to the following: after line 1 v1 is set, so if I print the variable at the same time we get line 1 subreport: 10 v1: 0.0 line 2 subreport: null v1:10 line 3 subreport: 20 v1: null line 4 subreport: 30 v1: 20 group sum: 30 (while it should be 60) Post Edited by maartenalbers at 02/15/2012 09:56
  12. I have a subreport that returns a value (to a variable) and a group sum on that variable in a different variable: When the last detail band report returns null it sums correctly subreport v1 = 10 subreport v1 = null subreport v1 = 20 subreport v1 = null sum(subreport v1) = 30 but when I have the last row not null it will not add it to the sum. subreport v1 = 10 subreport v1 = null subreport v1 = null subreport v1 = 20 I will get: sum(subreport v1) = 10 How can I fix this? How to solve: Create a subtotal variable $V{subtotal} in the main report Set it to calculation type: System set the resettype to the correct value (report, group) Add another return value to the report (select the subreport, in the properties add a new Return Value) Assign the return value $V{v1} from the subreport to $V{subtotal} Calculation type: "Sum" Post Edited by maartenalbers at 02/17/2012 16:28
  13. Try putting the "sum" in the bottom. Up there the variables underneath there are not recognized yet.
  14. wrong forum I think: this is the iReport forum. In iReport there is a icon right beside the preview button in the "designer" mode (three discs stacked with an arrow) [Design] [preview] | <database icon> and others...then you will get the "harsh" sql and there is a button "Query designer" Post Edited by maartenalbers at 02/13/2012 10:56
  15. in the sub report - create a variable V set to the value you want to return - remember the type and name of that variable in the main report - create a variable V2 with the same type of V in the sub report. - select the subreport in the main report and go to the properties of the subreport - at the bottom there is something called Return Values click [...] button - click "add" - Subreport variable: type name of V - Local destination var: select V2 - Calculation type: system ok
×
×
  • Create New...