["Can't add cell" Excel/xlsx export with detectCellType = true]

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

[How to start Jasperserver 5.0 on Jboss 7.1.1]

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.

[missing columns in excel output]

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?

[Email not sent in Jasper Report Scheduling]

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

[How to write SQL with dynamic parameter]

set the default value for the Parameter to "%" (I thought I mentioned it...)

Change the "=" sign to LIKE and you get what I said.

[How to write SQL with dynamic parameter]

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.

[How to write SQL with dynamic parameter]

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

SELECT * FROM City WHERE name LIKE "London";

[Sum last line is excluded (when using a subreport variable) [resolved]]

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

[Sum last line is excluded (when using a subreport variable) [resolved]]

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

[Sum last line is excluded (when using a subreport variable) [resolved]]

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

[Sum last line is excluded (when using a subreport variable) [resolved]]

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

[Sum last line is excluded (when using a subreport variable) [resolved]]

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:

1. Create a subtotal variable $V{subtotal} in the main report
   1. Set it to calculation type: System
   2. set the resettype to the correct value (report, group)
2. Add another return value to the report (select the subreport, in the properties add a new Return Value)
3. Assign the return value $V{v1} from the subreport to $V{subtotal}
4. Calculation type: "Sum"

 

 

 

Post Edited by maartenalbers at 02/17/2012 16:28

[group and subgroup]

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

[query designer]

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

[How to return values to master report from subreport]

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

[Sum Question]

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

[set iReport thousand separator]

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

[4.5 SubReport error AFTER publishing to JasperServer [can't locate sub-report-name.jrxml]]

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

[problem uploading report with subreport using Jasperserver and iReport (both v4.5.0)]

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

[problem uploading report with subreport using Jasperserver and iReport (both v4.5.0)]

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

[problem uploading report with subreport using Jasperserver and iReport (both v4.5.0)]

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:

1. create subreport
2. create main report
3. open repository
4. go to folder
5. "add new JasperReport"
6. select the main report
7. select database source on the repository that works (verified by using a simple report)
8. uploading starts <note: here I would expect the dialog to replace the paths>
9. "Message: (NULL)"
10. refresh repository (Main.jrxml is there, but not the subreport)
11. add the subreport.jrxml in the resources folder
12. download Main.jrxml edit the jrxml variables to refer to: "repo:subreport.jrxml" and upload again
13. 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