How to control number of columns after pivoting date as column
change the inner query to following using TOP () GROUP BY and ORDER BY to limit to 8 distinct date

SELECT  TOP (8) CONVERT(VARCHAR(10), ReportedDate, 120)  AS ReportedDate 
FROM    Activity       
GROUP BY CONVERT(VARCHAR(10), ReportedDate, 120)
ORDER BY ReportedDate