[Jasperreport Excel (.xlsx) datasource]

I am trying to generate a report using excel(.xlsx) datasource .I have been able to create the datasource in iReport. I add the Report Query by clicking the "Get Field from datasource" button.

And all the fields gets generated as needed. But when i click on preview data it throws an error:

java.lang.IllegalStateException: Cannot get a text value from a numeric cell.

The .xlsx file contains some column which have both integer and string values and I think this is the reason for exception.Is there any way to get all the column values as string or any other workaround?

 

I have tried  declaring in jrxml  <field name="InspectionFullNumber" class="java.lang.Object"> <fieldDescription><![CDATA[]]></fieldDescription>  but then too no help.

I really appreciate any pointer

I suspect there should be something to set the cell type to CELL_TYPE_FORMULA before reading the cell content.

[$X{} clause - define columnName as an expression]

yes you are right the ; is not working but the bar | is working.I tested this with postgres

[java.math.BigDecimal in CT- shows 0 instead of ""]

This works but it leaves a blank space in place of the null row group.I am using $V{your_value} as row group.I have tried setting the property of totals to float but the gap remains. Any idea ?

 

[html5 stacked bar chart % symbol]

How to add % symbols to the datalabels in the html5 stacked bar chart. I have checked the same for pie chartin the wiki.But it does not apply for bar chart

[ireport designer unable to save html5 proprties]

I am using ireport 5.0.1 and am using HTML5 charts. There is strange issue i am facing and that is ireport won't same my expression or any changes that i make to a chart when i close and reopen the charts.

This is really frustating.Is this somebody familar with. I have tried it many times the values/expression are just not saved. looks like some bug of the designer. How do i make sure that values get saved ?

Thanks 

 

[Collection and dynamic query]

Create a java class which takes your string as input parameter  and returns any collection/list. call that method to convert your string to collection.

[jasperserver flash chart in linux]

Guys iam really sorry , This was due to the following  changes done by my beautiful and smart client

~apache-tomcat/webapps/jasperserver-pro/WEB-INF/classes/jasperreports.properties

com.jaspersoft.jasperreports.fusion.charts.render.type=html5 .

Posted in case somebody gets struck with same issue.

Thanks

 

[jasperserver flash chart in linux]

I am using charts pro(Stacked bar chart) in one of my report. the flash chart is working fine when i am working with jasperserver 5.0.1 installed in Windows m/c.But when I try to run the same report in the jasperserver 5.0.1 installed in my  linux m/c the charts are falling back to javascript .It's different from the windows m/c .The bar width is increasing and x-axis values alignment is different.overall the chart is not presentable in the jasperserver installed in linux m/c.

Is there any extra setting to display flash charts in the jasperserver installed in a linux m/c ?

Thanks for reading

[java heap space error with crosstab]

i have tried increasing the heap space and bucket limit both.no result.

Do you know how can i check the number of buckets generated. and what can i do to decrease the number of buckets.

Thanks for replying

[java heap space error with crosstab]

I am working on crosstab where there are number of row groups(10) , some column group(1)  and some measeures(10).The cross tab is working fine when i limit the number of rows to 5000.But as i am increasing the number of rows to 10000 it is throughing java heap space error .I have tried decreasing the number of measure and row group.but still the same problem exist when the number of column is high.

I have tried setting the report virtualier in ireport with setting block size :100 min. grow count 100 and maximum size of paged in cache 100.  In that case it is throwing following error .

JRGzipVirtualizer Size: 100
Error filling print... java.lang.OutOfMemoryError: Java heap space null
java.lang.OutOfMemoryError: Java heap space 
    at java.util.HashMap.(HashMap.java:209) 
    at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService$BucketListMap.(BucketingService.java:752)

Can anybody please suggest me something about how to work  with large dataset(75000 +  rows) in crosstab or where i may be going wrong.

 

The error code thrown is

java.util.HashMap.(HashMap.java:209) 
    at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService$BucketListMap.(BucketingService.java:752)

 

Thanks for reading

 

[Excel Sheets dynamic renaming]

Hi Sanda.This solution is working very fine for .xls files but it is not working when i am exporting it to .xlsx file.Can you please suggest something.

Thanks

chandra

[Excel: forcing the page size to LETTER]

I know it's bumping on a dead thread but i am facing this same issue .The property that i am talking about can be achieved by selecting scaling mode --> fit print ranges to width and height.I have tried increasing width and height the document is still breaking into multiple pages when i do a print preview.

Thanks in advance

[Size of the raport is small on the screen - JasperServer 5]

I am not sure about this. but can you please check by changing the report layout to landscape.

[Problem with data input control - format date is wrong after make report.]

the input control that you create in jasperserver must match with the parameter you have in your report. Please make sure the respective parameter names are matching.

[ireport]

there can be only one main dataset per report. you can configure your main query based on parameters.for more than one dataset in a report you have to use subdataset.

[Extra Space between detail and last page footer band]

By default the footer position is at the bootom of the page.If you want the footer right after where the column/detail ends you can set isfloatcolumnfooter to true as an attribute of   jasperReport .

[Report cann't be displayed]

NoClassDefFoundError always means that a class cannot be found, so most likely your class path is not correct.

Please check that commons logging library is in you classpath.

[subreport]

Please make the question more clear. Will be good if you can draw arrow/mark in the attached image showing what it is now and what you want to do.

[ireport]

 

There is  a printWhenexpression property which you can set for the text field.

you can put any expression in that which if true will print the data else will print blank.

 

[Creating and change themes on jasperserver 4.7]

I got the solution.

[Creating and change themes on jasperserver 4.7]

Hi @aleeg Thanks for your answer but i have a question regarding this line "The default theme cannot be modified. " at the starting of second paragraph. is the new modification not going to work even if we replace the css.

Why iam asking this question is because I want to change the shape of the Export button (present in the ViewReport.jsp) I am changing the css of button .css (button capsule mutton up last).but the change is not visible in jasperserver.

[Multiselect question]

I Don't know the exact solution. I guess you have to cast the  publisher_clients to varchar in your input control query.

and

 name="publisher_clients" class="java.util.Collection" nestedType="java.lang.String">.

[Exporting large report using new Excel format file causes JasperServer to melt down.]

I think I have faced this issue earlier .for me it was because of subreports.

[How to hide/ show columns for Jasper Reports with java checkbox]

sure. Please post questions.

[using Group By in Ireport 4.8.0]

Did you try using group header ,footer ?