Live report formatting

Mamadou_Seck

I have the following report that i need to change THE FORMATTING.

here is the report:

SELECT  count(distinct Apt_ID_#)as 'Number of No Response per Apt'  FROM WF_TPU_IAI
WHERE Mail_Return_or_No_Response='No Response'

union all

SELECT  count(distinct Apt_ID_#)as 'Number of Final Warning Sent per Apt' FROM WF_TPU_IAI  
WHERE  Final_warning_Sent_Ev4 ='1'

union all

SELECT  count(distinct Apt_ID_#)as 'Number of Returned Mail per Apt' FROM WF_TPU_IAI
WHERE Mail_Return_or_No_Response='Mail Returned'

----------------------------------------

output

Number of No Response per Apt  
 3  
 54  
 16  

I would like to have  each of these numbers to be in it's own column

Tim_Hunter

Should be pretty straightforward

SELECT  count(distinct Apt_ID_#)as 'Number of No Response per Apt',null,null  FROM WF_TPU_IAI

WHERE Mail_Return_or_No_Response='No Response'

union all

SELECT  null,count(distinct Apt_ID_#)as 'Number of Final Warning Sent per Apt',null FROM WF_TPU_IAI 

WHERE  Final_warning_Sent_Ev4 ='1'

union all

SELECT  null,null,count(distinct Apt_ID_#)as 'Number of Returned Mail per Apt' FROM WF_TPU_IAI

WHERE Mail_Return_or_No_Response='Mail Returned'

 

However I think there are better ways of getting what you want, for example using case, if your performance is fine I wouldn’t worry about it