cjasper

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

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

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 ?

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

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

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.

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

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

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

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

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

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

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

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.

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.

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 .

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.

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.

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.

I got the solution.

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.

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

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

sure. Please post questions.

Did you try using group header ,footer ?