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

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

Try putting the "sum" in the bottom. Up there the variables underneath there are not recognized yet.

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

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

You'll want to group by PO # xxx and put it to the group band.

I tried that, but it gave an illegal pattern exception or something like that.

Do the id and the name of the subreport on the jasperserver match SUBREPORT-NAME.jrxml? (I think the server searches on id or name of the subreport not the actual filename.)

Thanks for the reply, but I actually need something that doesn't involve people to resolve this problem to XML editing.

I managed to get the subreport working, but it involved manual editing the jrxml. Replace the path to the subreport before you first submit it to the server. edit: the part before you first submit it to the server is because the .jasper file is not regenerated... Post Edited by maartenalbers at 02/03/2012 08:57

I create the report, and the subreport correct: if I press preview in the iReport it works correctly. But when I upload it to the server using the server repository it fails: I don't get the dialog "replace this by that " (${dir} +subreport.jasper" with "repo:subreport.jrxml" instead I get an exception displaying: "Message: (Null)" I even tried manually inserting the repo:subreport.jrxml in the main jrxml. I've tried the following: create subreport create main report open repository go to folder "add new JasperReport" select the main report select database source on the repository that works (verified by using a simple report) uploading starts <note: here I would expect the dialog to replace the paths> "Message: (NULL)" refresh repository (Main.jrxml is there, but not the subreport) add the subreport.jrxml in the resources folder download Main.jrxml edit the jrxml variables to refer to: "repo:subreport.jrxml" and upload again run report: exception is displaying that it cannot find the resource "path/to/subreport.jasper".I also tried to edit the mainreport.jrxml to have the right "repo:subreport.jrxml" and upload the subreport manually but that also fails. Greets, Maarten