Eclipse BIRT Designer Version 2.6.1.v20100902 Build <2.6.1.v20100915-1750>in/templates/blank_report.gifltr96Library IDdynamicLibrary ID Data SetdataSetRow["LIBRARY_ID"]dataSetRow["ASSET_SOURCE_NAME"]stringtruesimplelist-boxfalsetrueUnformattedcontentBidiFormatStrILYNNmetadataBidiFormatStrILYNNoracle.jdbc.driver.OracleDriverjdbc:oracle:thin:@mgr.virtual.aedc.extra.aexp.com:13111:VDOERR1Paavva2QW1leDEyMzQ=LIBRARY_IDLIBRARY_IDLIBRARY_IDASSET_SOURCE_NAMEASSET_SOURCE_NAMEASSET_SOURCE_NAME1LIBRARY_IDstring2ASSET_SOURCE_NAMEstringERR_DataSource1LIBRARY_IDLIBRARY_IDstring2ASSET_SOURCE_NAMEASSET_SOURCE_NAMEstringTO_CHAR(B.DT+93,'MON-YYYY')TO_CHAR(B.DT+93,'MON-YYYY')TO_CHAR(B.DT+93,'MON-YYYY')NVL(A.CNT,0)NVL(A.CNT,0)NVL(A.CNT,0)1TO_CHAR(B.DT+93,'MON-YYYY')string2NVL(A.CNT,0)decimalERR_DataSource1TO_CHAR(B.DT+93,'MON-YYYY')TO_CHAR(B.DT+93,'MON-YYYY')string2NVL(A.CNT,0)NVL(A.CNT,0)decimal= ADD_MONTHS ( TRUNC (SYSDATE, 'Q') , -9 )
AND "TARGET-DEPLOYMENT-DATE" < ADD_MONTHS ( TRUNC (SYSDATE, 'Q'),15)
GROUP BY (TRUNC ("TARGET-DEPLOYMENT-DATE" ,'Q'))
ORDER BY TRUNC ("TARGET-DEPLOYMENT-DATE")
) a,
(SELECT ADD_MONTHS ( TRUNC (SYSDATE, 'Q') , -12) as dt from dual UNION
SELECT ADD_MONTHS ( TRUNC (SYSDATE, 'Q') , -9) as dt from dual UNION
SELECT ADD_MONTHS ( TRUNC (SYSDATE, 'Q') , -6) as dt from dual UNION
SELECT ADD_MONTHS ( TRUNC (SYSDATE, 'Q') , -3) as dt from dual UNION
SELECT ADD_MONTHS ( TRUNC (SYSDATE, 'Q') , 0) as dt from dual UNION
SELECT ADD_MONTHS ( TRUNC (SYSDATE, 'Q') , 3) as dt from dual UNION
SELECT ADD_MONTHS ( TRUNC (SYSDATE, 'Q') , 6) as dt from dual UNION
SELECT ADD_MONTHS ( TRUNC (SYSDATE, 'Q') , 9) as dt from dual UNION
SELECT ADD_MONTHS ( TRUNC (SYSDATE, 'Q') , 12) as dt from dual UNION
SELECT ADD_MONTHS ( TRUNC (SYSDATE, 'Q') , 15) as dt from dual ) b
where a.quarter_start_date (+) = b.dt
order by b.dt]]>1.0QUARTER_START_DATE11270NullableQUARTER_START_DATEQUARTER_START_DATE7CNT2200NullableCNTCNT22]]>htmlnew Date()]]>2.5.1Bar ChartSide-by-side0.00.00.00.03.03.03.03.0-1-1-1-11255000false0255255255true0.00.00.00.03.03.03.03.0-1-1-1-11255000falsetrue550255000false02552552550.00.00.00.00.00.00.00.03.03.03.03.0-1-1-1-11255000falsefalse0255000false2.02.02.02.0VerticalTop_Bottom1255000trueRightSeries