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

JRS Report not showing result after changing Advance Query

Hello Team,

I am using JRS 6.0.0,  I have a req. of populating numbers of change request per month-year e.g.
Jan-2105    4
Feb-2015    5
Mar-2015    7

I have updated the query (from Advance query) to change creation date in format of Month-Year

SELECT DISTINCT T1.PROJECT_NAME,
       CONCAT(CONCAT(
       CASE MONTH(T2.VAL)
       WHEN 1 THEN 'Jan'

       WHEN 2 THEN 'Feb'

       WHEN 3 THEN 'Mar'

       WHEN 4 THEN 'Apr'

       WHEN 5 THEN 'May'

       WHEN 6 THEN 'Jun'
       WHEN 7 THEN 'Jul'

       WHEN 8 THEN 'Aug'

       WHEN 9 THEN 'Sep'

       WHEN 10 THEN 'Oct'
       WHEN 11 THEN 'Nov'

       WHEN 12 THEN 'Dec'

       END

,' - '),YEAR(T2.VAL)),

       COUNT( DISTINCT T1.REFERENCE_ID) AS REFERENCE_ID1,
       COUNT(DISTINCT CASE WHEN T3.VAL >= 10  THEN T3.REQUEST_ID END ) AS VAL2,
       CAST(COUNT(DISTINCT CASE WHEN T3.VAL >= 10  THEN T3.REQUEST_ID END ) AS DECIMAL) / CAST(COUNT( DISTINCT T3.REQUEST_ID) AS DECIMAL) AS VAL1
FROM RIDW.VW_REQUEST T1

LEFT OUTER JOIN RICALM.VW_RQST_TIMESTAMP_EXT T2

ON T2.REQUEST_ID=T1.REQUEST_ID AND T2.NAME='RequestedDate'

  LEFT OUTER JOIN RICALM.VW_RQST_INT_EXT T3

  ON T3.REQUEST_ID=T1.REQUEST_ID AND T3.NAME='com.ibm.workitem.attribute.LateContent'
WHERE T1.PROJECT_ID = 108  AND
(   T1.REQUEST_TYPE = 'RCN' ) AND
(T1.ISSOFTDELETED = 0) AND

(T1.REQUEST_ID <> -1 AND T1.REQUEST_ID IS NOT NULL)GROUP BY T1.PROJECT_NAME,
T2.VAL

My problem is that i can see the result in Preview option but
1) I cannot execute the report(its blank)
2) I am able to select any charts for this, is not populating any chart options.

Please help me

0 votes


Be the first one to answer this question!

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

Question asked: Mar 17 '16, 3:33 p.m.

Question was seen: 2,175 times

Last updated: Mar 17 '16, 3:37 p.m.

Confirmation Cancel Confirm