[Maturin]

Hi,

I had problem with the previous version of my eclipse reports. So I upgraded to myEclipse 7 https://www.genuitec.com/forums/topic/hide-display-elements-and-export-problem/.
But I am now having some trouble with the designer; the reports are working when I deploy them though.

First: In some of my reports I use computed columns, with the following code:

DateTimeSpan.minutes(row["startTime"],row["endTime"])

But I am now getting loads of exception, it looks like the functions in DateTimeSpan are not accessible, I am basically getting “DateTimeSpan” is not defined. (Once deployed it seems to be running fine)

Second when I open a dataset and go to the query section I get a “java.lang.NullPointerException”. I have tried to create another project with a simple dataset but it keeps happening and I can’t seem to find why! (Once deployed it seems to be running fine)

Am I missing a package somewhere? I would appreciate any help.

Thanks and regards,
Maturin

[Maturin]

ok sorry I did not see this post before https://www.genuitec.com/forums/topic/myeclipse-7-0-report-can-t-open-quot-query-quot-in-data-se/ for the dataset. But there is still is an issue with DateTimeSpan.

Thanks.

[Maturin]

I am still getting exceptions while trying to run reports (with computed columned and function from the DateTimeSpan packages) within the Myeclipse viewer? Is this also a bug or am I missing something?

Thanks

[Brian Fernandes]

Maturin,

When you upgraded to ME 7, did you modify your project to use new BIRT 2.3.1 libraries or are you continuing to use the same project? FYI upgrade instructions are here: http://www.myeclipseide.com/documentation/overview/technical/myeclipse_reports_upgrade.html. When you said “loads of exceptions” I assume you’re talking about exceptions in the error log when you are editing the report with the designer?

Second when I open a dataset and go to the query section I get a “java.lang.NullPointerException”. I have tried to create another project with a simple dataset but it keeps happening and I can’t seem to find why! (Once deployed it seems to be running fine)

I’m afraid this is a bug which has already been fixed for the next release. To edit the query you would need to edit the SQL in the .rptdesign file directly.

Sorry for the inconvenience caused, please let me know we can assist further.

[zhoun]

https://www.genuitec.com/forums/topic/reporting-functions-lists-empty/
Is this the same questions as the above?
The Reporting Functions are missing in version 7.0

[Maturin]

Hi Brian,

When upgrading to ME 7, I created a new project added the reporting capabilities and then imported the reports etc. Anyway the first problem I had which is editing a query using the designer will be fixed in the next release thats fine thanks.

But I still have no answer for my second issue when using the DateTimeSpan packages (DateTimeSpan.minutes(row[“startTime”],row[“endTime”]) to create computed columned. I get an error (see below) when I try to view the report by clicking on the “preview” tab in MyEclipse, but the report works perfectly once it is deployed, any Idea?

Table (id = 90):
– Fail to compute value for computed column “WorkingTime”.
A BIRT exception occurred: There are errors evaluating script “DateTimeSpan.minutes(row[“startTime”],row[“endTime”])/60″:
ReferenceError: “DateTimeSpan” is not defined. (<inline>#1).. See next exception for more information.
There are errors evaluating script “DateTimeSpan.minutes(row[“startTime”],row[“endTime”])/60″:
ReferenceError: “DateTimeSpan” is not defined. (<inline>#1).
data.engine.CompCol.FailRetrieveValueComputedColumn ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Fail to compute value for computed column “WorkingTime”.A BIRT exception occurred: There are errors evaluating script “DateTimeSpan.minutes(row[“startTime”],row[“endTime”])/60″:ReferenceError: “DateTimeSpan” is not defined. (<inline>#1).. See next exception for more information.There are errors evaluating script “DateTimeSpan.minutes(row[“startTime”],row[“endTime”])/60″:ReferenceError: “DateTimeSpan” is not defined. (<inline>#1). at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1109) at
….

zhoun my problem is not exactly the same but maybe they are related!

Thanks and regards.
maturin

[Author]

Posts