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.
I have updated the query (from Advance query) to change creation date in format of Month-Year
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
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