Problem with BIRT Formatting for an RQM Report
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
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