Latest Topics

Measures MDX in Report return No such tuple on axis 0

2012-02-11

I have an MDX query that works but when put into an iReport report I get "No such tuple ([Measures].[a]) on axis 0." Thing is I can bring up the dimenions no problems. Just measures it cannot. The query is below. It's funny because the measures are on axis 1 so I placed flipped the query and placed measures on axix 0 with the same "No such tuple ([Measures].[a]) on axis 0" error. [Order Fulfillment and Survey] is a virtual cube, I also tried with a cube and a much simplier query without cross joins and the same issue happens. I'm using iReport 4.1.3. JasperReports version 4.1.3. Java 6 Update 25. Not that it matters but Oracle 11g DB.

Does anyone know how to resolve this?

Code:

SELECT
NON EMPTY [Service Order].[Day].Members ON COLUMNS,
NON EMPTY CrossJoin({
[CSAT],
[Measures].[a],
[Measures].[b]
},
[Product Type].Children
)
) ON AXIS(1)
FROM [Order Fulfillment and Survey]

jasper report is running immidiately instead of specified time

2012-02-10

Hi,

check the below code. I am making webservice call to schedule a report to run after 5 mins. but this report is running immidiately. how to avoid that??

Thanks.

Code:

JobSimpleTrigger trigger = new JobSimpleTrigger();
            trigger.setOccurrenceCount(1);
            Calendar calendar = Calendar.getInstance();
            System.out.println("current calendar --->" + calendar) ;
            calendar.add(Calendar.MINUTE,5);
             System.out.println("After calendar --->" + calendar) ;
            trigger.setStartDate(calendar);
            trigger.setRecurrenceIntervalUnit(IntervalUnit.fromString(jr.getIntervalUnit()));
            job.setSimpleTrigger(trigger);

Using JasperReports 4.5 with CustomJSONDatasource and Java 1.4 Compiler

2012-02-09

Hi,

We are still on WAS 6.0 with JAVA 1.4...

We are getting a compiler error, we are using JasperReports 4.5 with CustomJSONDatasource and Java 1.4.

It works with Java 1.5. The errors say 1.4 does not support Generics.

Does anyone know of a workaround for this?

Thank you in advance,

Vivian

Error after copy paste Jasper Library into my application folder

2012-02-09

Hi,

I got this error after copy paste Jasper Library into my application folder. Please someone help me to solve this problem. Do i need to do some changes in my coding?

java.lang.NoSuchFieldError: PRINTSCALING
	net.sf.jasperreports.engine.export.JRPdfExporter.exportReportToStream(JRPdfExporter.java:466)
	net.sf.jasperreports.engine.export.JRPdfExporter.exportReport(JRPdfExporter.java:362)
	net.sf.jasperreports.engine.JasperExportManager.exportReportToPdf(JasperExportManager.java:184)
	net.sf.jasperreports.engine.JasperRunManager.runReportToPdf(JasperRunManager.java:283)
	ekptg.report.EkptgReportServlet.createPDFReport(EkptgReportServlet.java:426)
	ekptg.report.EkptgReportServlet.doService(EkptgReportServlet.java:248)
	lebah.servlets.ServletTemplate.doPost(ServletTemplate.java:37)
	lebah.servlets.ServletTemplate.doGet(ServletTemplate.java:18)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

TQ

Create Filter on Large Table

2012-02-08

We are using Jaspersoft 3.7 to build reports for a customer

I have a domain containing 3 tables

Activity -Approx 42000 rows

Employee - Approx 70000 rows

Training History - Approx 2.4 million rows

I create an adhoc report with this domain and if I choose activity, I cannot add a filter to a column in the table which contains 42000 distinct values.

eg. The table has a code and title column.

Fairly standard would be to provide a filter on code so the uesr could filter a report by a specific activity.

However - adding this filter just causes Jasper to crash with the error:

com.jaspersoft.jasperserver.api.JSExceptionWrapper: Errors were encountered when compiling report expressions class file: 1. Too many constants, the constant pool for test_1328086159146_494356 would exceed 65536 entries public class test_1328086159146_494356 extends JREvaluator <-----------------------> 1 errors

Any suggestions of ways to get around this would be hugely appreciated.

How to convert from jasper to RTF without frame text

2012-02-08

Hi,

Im having a problem when converting Jasper to RTF which after converting I got the RTF file with all texts are in frame. It may difficult for me to edit the RTF file..Is there any solution to solve this problem. I used JRExporter code in my Java code. For example please refer attachment.

Strange exception on JasperFillManager.fillReport()

2012-02-07

Hi, I am getting an exception calling JasperFillManager.fillReport() that I am having trouble tracking down a good description of:

point a

point b

point c

Feb 6, 2012 7:55:43 PM net.sf.jasperreports.engine.query.JRXPathQueryExecuter WARNING: The supplied org.w3c.dom.Document object is null. Exception in thread "main" java.lang.VerifyError: class org.codehaus.groovy.runtime.callsite.GroovySunClassLoader$2 overrides final method visit.(IILjava/lang/String;Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)V at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:634) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) at java.net.URLClassLoader.defineClass(URLClassLoader.java:277) at java.net.URLClassLoader.access$000(URLClassLoader.java:73) at java.net.URLClassLoader$1.run(URLClassLoader.java:212) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:205) at java.lang.ClassLoader.loadClass(ClassLoader.java:321) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294) at java.lang.ClassLoader.loadClass(ClassLoader.java:266) at org.codehaus.groovy.runtime.callsite.CallSiteGenerator.isCompilable(CallSiteGenerator.java:245) at org.codehaus.groovy.reflection.CachedMethod.createPogoMetaMethodSite(CachedMethod.java:227) at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.createCachedMethodSite(PogoMetaMethodSite.java:207) at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.createPogoMetaMethodSite(PogoMetaMethodSite.java:183) at groovy.lang.MetaClassImpl.createPogoCallCurrentSite(MetaClassImpl.java:3014) at org.codehaus.groovy.runtime.callsite.CallSiteArray.createCallCurrentSite(CallSiteArray.java:95) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:46) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:133) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141) at weeklyReport_subreport4_1328328559346_876051.customizedInit(calculator_weeklyReport_subreport4_1328328559346_876051:67) at net.sf.jasperreports.engine.fill.JREvaluator.init(JREvaluator.java:88) at net.sf.jasperreports.engine.fill.JRCalculator.init(JRCalculator.java:111) at net.sf.jasperreports.engine.fill.JRFillDataset.initCalculator(JRFillDataset.java:439) at net.sf.jasperreports.engine.fill.JRBaseFiller.(JRBaseFiller.java:506) at net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:77) at net.sf.jasperreports.engine.fill.JRFillSubreport.initSubreportFiller(JRFillSubreport.java:431) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:369) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:275) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:257) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:473) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummaryNoLastFooterSamePage(JRVerticalFiller.java:1067) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:1032) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:296) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:135) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:836) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:765) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:84) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:624) at Listener.compile_report(Listener.java:84) at Listener.main(Listener.java:185)

Here is the generating code:

JasperDesign jasperdesign = null;

try {

if (doctype.contentEquals("weekly")) {

jasperdesign = JRXmlLoader.load("/root/weeklyReport.jrxml");

} else if (doctype.contentEquals("monthly")) {

jasperdesign = JRXmlLoader.load("/root/monthlyReport.jrxml");

} else if (doctype.contentEquals("custom")) {

jasperdesign = JRXmlLoader.load("/root/customReport.jrxml");

}

// else if (doctype.contentEquals("single"))

// {

// jasperdesign = JRXmlLoader.load("/root/weeklyReport.jrxml"); //

}

else {

throw new Exception("Unknown content type " + doctype.toString());

}

} catch (JRException e2)

{ // TODO Auto-generated catch block e2.printStackTrace();

} catch (Exception e)

{

// TODO Auto-generated catch block e.printStackTrace();

}

System.err.println("point a");

JasperReport jasperreport = null;

try {

jasperreport = JasperCompileManager.compileReport(jasperdesign);

}

catch (JRException e)

{

// TODO Auto-generated catch block e.printStackTrace();

}

System.err.println("point b");

JRXmlDataSource jrxmldatasource = null;

try

{

jrxmldatasource = new JRXmlDataSource("tempfile.tmp");

} catch (JRException e1)

{

// TODO Auto-generated catch block

e1.printStackTrace();

}

System.err.println("point c");

JasperPrint jasperprint = null;

try {

jasperprint = JasperFillManager.fillReport(jasperreport, null, jrxmldatasource); }

catch (JRException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

System.err.println("point d");

I am not sure why a groovy-related class is being invoked, since I have explicitly set the language="java" in the .jrxml file used. Is there a global setting somewhere for the language= parameter?

Jon

Post Edited by dosadi at 02/07/2012 19:05

How to query xmlns= with XPath ?

2012-02-07

Hi,

I am currently trying the new namespace aware feature added in JasperReports 4.0.1. (see http://jasperforge.org/projects/jasperreports/tracker/view.php?id=4500).

It is working fine after patching the JRXmlUtils class as indicated in the issue.

However, I am having difficulties with a specific case where the dataset root element has an xmlns attribute with no prefix.

In that specific case, the XPath query does not return the value. Since I have no prefix for the namespace I siply can get the value.

Has someone already encountered this issue ?

Code:

...

language="java" & xml datasource

2012-02-07

Hi,

I'm creating a report that uses an xml file as a datasource. I have found that when the language is groovy it compiles and displays correctly in iReport 4.5.0, but if I attempt to deploy it as a servlet I get an error about NoClassDefFound for org.codehaus.groovy.control.CompilerConfiguration.

If I change the language to java I get the following (in iReport or as a servlet):

The method subDataSource(String) is undefined for the type JRDataSource

value = ((net.sf.jasperreports.engine.JRDataSource)parameter_REPORT_DATA_SOURCE.getValue()).subDataSource("/User/Application"); //$JR_EXPR_ID=15$

I'm curious why groovy seems to recognize that my datasource is a JRXmlDataSource, but java thinks it is a plain JRDataSource? Has anyone else had this issue? Is it a bug?

If I keep groovy as the language, do I just need to put a groovy .jar file in the deployed servlet app? Thanks for the assistance.

Stephen

Post Edited by jasperme12 at 02/07/2012 15:22

[LineChart] x-axis labels : show only one of two

2012-02-07

Hello all,

First, sorry for my english, maybe I will use bad words or expressions.

Then, as I am not a Java developer, I ask for your help to solve the following problem :

I precise : my problem is not overlaping!

My problem is I do not know how to display only 1 label of 2 (do I say it right?).

Indeed, on this picture, there is not so much data, but in reallity, I have thousands of points to display and I want to show only around 10 labels on x-axis.

I saw here someone doing it ( here: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=83170 ) so I know it is possible throug Customization Class, but I do not know how.

May someone help me to figure it out?

Best regards,