Error while running report

Hi,
I updated my birt from 2.2.2 to 2.5 and all my reports are running fine with small changes. But few of them where I used measures and dimensions are creating problem. I am using cross tab in all my reports. I am getting the following error. Any suggestions???

Caused by: org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:186)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75)
at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:882)
... 49 more
Caused by: org.mozilla.javascript.EvaluatorException: The outer query results does not exist. This might be caused by a "_outer" reference in a query without parent query. (#1)
at org.mozilla.javascript.DefaultErrorReporter.runtimeError(DefaultErrorReporter.java:109)
at org.mozilla.javascript.Context.reportRuntimeError(Context.java:922)
at org.mozilla.javascript.Context.reportRuntimeError(Context.java:978)
at org.eclipse.birt.data.engine.olap.script.JSCubeBindingObject.get(JSCubeBindingObject.java:54)
at org.mozilla.javascript.ScriptableObject.getProperty(ScriptableObject.java:1575)
at org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRuntime.java:1363)
at org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRuntime.java:1345)
at org.mozilla.javascript.gen.c77._c0(:1)
at org.mozilla.javascript.gen.c77.call()
a

Find more posts tagged with

Comments

mwilliams

Hi ayyalaraj,

Can you recreate this issue with the sample database? If not, can you attach your report design you're having issues with? Thanks.

ayyalaraj

Hi Michael,
Here is the rptdesign. I could not able to regenerate the issue with sample db.
I got a work around for this Michael. But I have other problem which I need your help. Following is the new issue.

I uploading another rptdesign (application_analysis_daily_sampledb.rptdesign)with sample db. I am trying to add one more column called average to the cross tab report after Grand Total. Could you please let me know how to do that?
If it is not possible with cross tab, can I do the same report using table?

Thanks,
Ayyalaraj

mwilliams

Ayyalaraj,

I don't think you'll be able to add the new column. I responded to your other thread about this saying that you could add another element to the total column and make it "inline" in the advanced properties. Then, you could use padding, etc. to make it look spaced how you want it. You could create a dynamic table to do a similar thing if you could figure out how many columns you need the table to have.