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 |
One answer
![]()
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. |
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.