maartenstachanov.com

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

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.

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?

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

set the default value for the Parameter to "%" (I thought I mentioned it...) Change the "=" sign to LIKE and you get what I said.

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.

SELECT * FROM City WHERE name LIKE "%"; (is equivilent to SELECT * FROM City;) SELECT * FROM City WHERE name LIKE "London";

I changed it to a feature request, because it does work, but the interface is confusing.

I finally know what I did wrong, but I still believe that the way this is setup is confusing. I should have used sum at the return variable for the subreport and not the variable at the moment it was caused.

Thanks: that looks promising. (Although it seems a bit peculiar behavior) I'll try it this afternoon.

Appearently it is a known feature that subreports are only calculated for visible bands (prob. to optimize the report)

- 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)

http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=95546 It might be related to this problem. (also by me)

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

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