It's all about the answers!

Ask a question

JRS Report not showing result after changing Advance Query


Pankaj Sharma (40352) | asked Mar 17 '16, 3:33 p.m.
edited Mar 17 '16, 3:37 p.m.
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

Be the first one to answer this question!


Register or to post your answer.