LiveReport Result for Doc. Create and Delete in a single row

Khurram_Amin

How can I display the result for document create by and deleted by in a same row as you can also see in the attached screen show.

Tim_Hunter

You need to pivot the data, offhand I don't know how to do this in mssql, but im sure there is a howto somewhere online.For reference here is how you would do it in oracleSELECT dataid, MAX(value2) filename, MAX(DECODE(auditstr, 'Create',auditdate,NULL)) createdate, MAX(DECODE(auditstr, 'Create',performerid,NULL)) createbyid, MAX(DECODE(auditstr, 'Create',name,NULL)) createbyname, MAX(DECODE(auditstr, 'Recycle',auditdate,NULL)) recycledate, MAX(DECODE(auditstr, 'Recycle',performerid,NULL)) recyclebyid, MAX(DECODE(auditstr, 'Recycle',name,NULL)) recyclebynameFROM (SELECT auditstr, auditdate, dataid, performerid, value2, k.name FROM dauditnew a, kuaf k WHERE a.performerid = k.id AND dataid = 17558786 AND (auditstr IN ('Create', 'Recycle')) )GROUP BY dataid