Get rid of the null rows
-
I circled the null rows with red. Under NewstartsDM there is a null column and a null row. In NewstartsCS there is a null row.
I want to get rid of those. Also null columns in NewstartsTELE and Newstartsweb. They are all seperate datasets.
I did this "=IIF(Fields!PCODE.Value = "",TRUE,FALSE)" for NewstartsDM and it just hid the empty PCODE textbox and the rest of the column is showing up null.
select DMNstarts.STARTS DMNstarts,cd.code DMcode,fl.pcode pcode from(
SELECT count(B.TRANS_TYPE) STARTS, B.PROD_CODE pcode, C.GROUP_CODE DMcode
FROM UNICA.DSI_SUBS_STOP_START_DRW B, UNICA.DSI_OFFER_SOURCE C
WHERE B.OFFER_SOURCE = C.CODE AND B.PROD_CODE is not null AND C.GROUP_CODE is not null
AND (B.TRANS_TYPE IN ('3')) AND C.GROUP_CODE IN ('BCST','FLYR','INST','MAIL','SCIN','SLIN')
AND B.PROD_CODE in ('E','3','W','W5','SS','S','4','TS','W2','WS','3S')
GROUP BY B.PROD_CODE , C.GROUP_CODE
)DMNstarts
FULL OUTER JOIN
(
select distinct B.PROD_CODE pcode
FROM UNICA.DSI_SUBS_PAPERS B
where B.PROD_CODE in ('E','3','W','W5','SS','S','4','TS','W2','WS','3S') AND B.PROD_CODE is not null
order by Decode(B.PROD_CODE, 'E',1,'3',2,'W',3,'W5',4,'SS',5,'S',6,'4',7,'TS',8,'W2',9,'WS',10,'3S',11)
)fl on fl.pcode = DMNstarts.pcode
FULL OUTER JOIN
(
select code from UNICA.DSI_OFFER_GROUP
where code in ('BCST','FLYR','INST','MAIL','SCIN','SLIN') and code is not null
order by Decode(code,'BCST',1,'FLYR',2,'INST',3,'MAIL',4,'SCIN',5,'SLIN',6)
)cd on cd.code = DMNstarts.DMcode
order by Decode(fl.pcode, 'E',1,'3',2,'W',3,'W5',4,'SS',5,'S',6,'4',7,'TS',8,'W2',9,'WS',10,'3S',11)
, Decode(cd.code,'BCST',1,'FLYR',2,'INST',3,'MAIL',4,'SCIN',5,'SLIN',6)
-
your images are down...
but if you're talking about NULL, you should use isnothing() in SSRS
-
THanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply