It's all about the answers!

Ask a question

Problem with BIRT Formatting for an RQM Report


Andrew Trobec (49713144139) | asked Mar 29 '11, 6:53 a.m.
closed Jul 08 '14, 7:52 a.m. by Paul Slauenwhite (8.4k12)
Hello everyone,

I know I'm not supposed to use BIRT for RQM reporting, but I need a very light report that accesses a TER and it's Test Plan.

I have managed to create the table that I need, but I have a problem formatting it. Here is a little info:

An ExecutionResult has a startTime and endTime, which are displayed as date/time fields in RQM. For example, I have an ExecutionResult that has the startTime as "25 May 2010 09:56:21". When I query that field in BIRT, it comes out as an integer with value "-831105021".

In the report layout, I have tried to format the table to display the number as DateTime, but it does not work. I have also tried to create a calculated column that takes the Integer as an input and outputs a date, but the resulting values are incorrect.

Please could somebody help me to format this field so that I can correctly display it in the report?

Thank you in advance for the support!

Best regards,

Andrew

Accepted answer


permanent link
Paul Slauenwhite (8.4k12) | answered Jul 08 '14, 10:09 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
If this is still reproducible, please upgrade RQM (https://jazz.net/downloads/rational-quality-manager/) and retry this scenario.  If the symptom is still reproducible, please open a PMR (see http://www-01.ibm.com/support/docview.wss?uid=swg21507639).
Andrew Trobec selected this answer as the correct answer

Comments
Andrew Trobec commented Jul 08 '14, 2:27 p.m.

Thank you Paul, for finally giving me closure :)

Regards,
Andrew 

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.