Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Jazz Reporting service

Hi

I am using CLM 6.0.1. I have a TASK which has a estimate of 0.5 hrs and Time Spent is entered as 0.5 hrs.

When I generate a JRS report it is shown as 0.00. Please let me know how to display the decimal values .

The SQL query modified for Planned and Actual Work is

 CAST(SUM(T2.PLANNED_WORK)/3600 AS DECIMAL(15, 2)) AS PLANNED_WORK,
 CAST(SUM(T2.ACTUAL_WORK)/3600 AS DECIMAL(15, 2)) AS ACTUAL_WORK,

Please let me know URGENTLY.

Regards
Niranjan V

1 vote



One answer

Permanent link
Hi Niranjan,

This is a product defect (reproducible in JRS 6.0.2) and APAR has been created: PI66786.

As a possible workaround, change the Artifact type to Quality Management or Requirement Management (instead of Change Configuration Management):
1. Create a simple new report using the Quality Management's test case artifact.
2. Go to the Advance tab and click Edit Query button.
3. Delete existing query and paste the SQL query that was created previously
4. Click Validate Query to update the variables in the Format section.
5. Go to Format section and set the variable type to decimal for both ActualWork and PlannedWork column.
6. Enter the name for the report and then click Save
7. Click Run and the decimal value will be shown in the Actual Work and Planned Work columns.

1 vote

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,017

Question asked: May 23 '16, 3:40 a.m.

Question was seen: 1,971 times

Last updated: Aug 02 '16, 8:52 p.m.

Confirmation Cancel Confirm