wisoo123

I have created a chart customization class according to the description from https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v640/working-java-eclipse and added it to my report like described in https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v640/chart-customizers. I can see the customizer in the "add chart customizer" dialog, but there is a message that says: "The class PieChartColorCustomizer can not be resolved. To run your report you need to update the classpath of your project to provide the customizer class". When I start the report anyway I get the error "net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: Could not create chart customizer instance. ... java.lang.ClassNotFoundException: test.chart.customizer.PieChartColorCustomizer cannot be found by net.sf.jasperreports_6.9.0.final". Can anybody tell me how to set up the chart customizer? Some details on my config: java file: package "test.chart.customizer", class "PieChartColorCustomizer" exported to PieChartColorCustomizer.jar added json file "PieChartColorCustomizer.json" to JasperStudio (windows/preferences/.../ChartCustomizers) with customizerClass="test.chart.customizer.PieChartColorCustomizer" copied jar file from explorer to JasperStudio project explorer (main dir), and selected "Add to build path" from context menu in the chart config dialog the customizer appears, but with the error above

​Did you find a solution for this - I have the same requirement for my report?

Thanks for the advice to use macros in this case. I did already read this blog before, but unfortunately macros are not allowed in our environment.

Hi, when exporting my report to Excel, I would like to put some data (in my case an jpeg) into the excel header row. According to some older posts in this forum, this does not seem to be possible (maybe it works with the help of Java Excel APIs, but I cannot use them inside JasperStudio). I also found a "net.sf.jasperreports.export.xls.sheet.header.center" property, but I don´t know how to set a image file there. Are there any new features in the latest versions of JasperReports, or does anybody know how to write data into Excel header/footer rows? Thanks Wisoo123

In my detail band I placed a table (incl. dataset). Now I want to add a static text element after the table, but only if the table contains data rows. Is there a way to access dataset variables in a "printwhen" expression? Thanks WiSoo

Hi parisalakshmi, casting the date inside my report according to your advice does work. The problem is, that I have a lot of reports with date parameters, and I would have to change all these reports. That´s why I would prefer to modify the JasperServer config so it runs my reports like in previous versions ...

I have a report that receives a date parameter (defined as java.util.date). I call my report with "JASPERSERVER/.../flow.html?...&MY_DATE_PAR=01.01.2015". That date parameter in german format worked fine on my JasperServer 5.6 installation. Now I updated to 6.1, and I always get empty reports. After some research (checked request/response when calling report inside JasperServer web interface) I found out that I get valid reports when using date format "yyyy-MM-dd". Now I checked the Jasper config files. In applicationContext.xml I found parameter "dateFormat" with value "repository.date.format". The "jasperserver_config_de.properties" sets the value for "repository.date.format" on "dd.MM.yyyy", so my date parameter should be valid? How can I tell JasperServer 6.1.1 to accept german dates in urls? Thanks

I have the same problem with Jaspersoft Studio 6.1. Does anybody have a workaround for this, or an explanation why this occurs and if it ever will be fixed?

I found the solution. It is not Jasper related - I changed the way I save the file in C#, and now it works.

Hi, when I try to create a report with the JasperServer rest_v2 API, I receive an blank pdf page. When I use html as output format, it works correctly. I took a look at the created pdf files - they all have different file size and content. But somehow the content of the pdf file seems to be invalid, because there is slways show a blank page. Does anybody know what I am doing wrong here? Thanks! Wisoo

Is there any solution yet - I have the some problem: I always get a java.lang.NullPointerException when connecting from iReport 5.5.1 to JasperServer 5.2/5.5 CP?

In my report query on a postgre DB I use the crosstab function: select * from crosstab('select x,y from table where id=1') as a,b; This works fine as long as the ID is a constant in the query. If I replace the "1" by $P{PAR_ID}, I get an error: "... Error preparing statement for executing the report query ...". The parameter PAR_ID is of type Integer, so this should be OK. Does anybody know how to use parameters inside quoted sql parts? Thanks! Wisoo123

Hi, when I try to add an query via iReport 5.1 -> RepositoryNavigator/Reports/.../Add->Query, I always get the following error: "1-jsexception.folder.not.found.at" I tried different sql queries and datasources, the error is always the same. In the messages.log file I found: java.lang.Exception: 1 - jsexception.folder.not.found.at at com.jaspersoft.ireport.jasperserver.ws.WSClient.putReportUnitResource(WSClient.java:570) at com.jaspersoft.ireport.jasperserver.ws.WSClient.modifyReportUnitResource(WSClient.java:509) at com.jaspersoft.ireport.jasperserver.ws.WSClient.addOrModifyResource(WSClient.java:463) at com.jaspersoft.ireport.jasperserver.ui.resources.QueryDialog.jButtonSaveActionPerformed(QueryDialog.java:592) at com.jaspersoft.ireport.jasperserver.ui.resources.QueryDialog.access$700(QueryDialog.java:41) at com.jaspersoft.ireport.jasperserver.ui.resources.QueryDialog$8.actionPerformed(QueryDialog.java:447) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) Does any know what I can do to avoid this error and add queries ton the JasperServer? Thanks!

Hi Ajinkya, you are right - I tried to create a report this weekend using crosstabs, and it worked better than with tables (but maybe it is possible with them too?). What I couldn´t implement until now: how can I avoid page breaks inside a column group? For example, in my example above all columns "Attr1"-"AttrX" of "Category 2" should be displayed on next page, if one or more columns do not fit on the current page. Wisoo123

Hi, which report structure would you suggest to create a table with the following layout: Category 1 | Category 2 | Category X ------------------------------------------------------------- Attr1 Attr2 Attr X | Attr1 Attr2 Attr X | Attr1 Attr2 Attr X ----------------------------------------------------------------- 1.1. val val val val val val ... 2.1. ... 3.1. ... ... 31.1. Data comes from SQL (Dataset) as (time,category,attr,val). How can I realize these grouping of columns with the table object? I tried to insert group headers into the table->columnHeaderList, but then then content of each category is displayed on a new page. Thanks!