Are you using the default values check marked in the subscription's report parameters.?
From: [email protected] [mailto:[email protected]] On Behalf Of Gary Ossewaarde Sent: Wednesday, August 21, 2013 7:21 PM To: [email protected] Subject: [mssms] Report Subscription Hi All, I have a report subscription (CM12SP1, SQL Server 2012, on Windows Server 2012) of a custom report I made. It's supposed to give the past 14 days of virus infections of when it's run. However, it seems to be showing the past 14 days of when the subscription was created. If I run the report on its own, manually, I get the correct results. Otherwise, I seem to get the results as if I ran it the day the subscription was created (like it's cached the report or the date). It's the "Infected Computers" but with a modified StartDate/EndDate. StartDate and EndDate are a query: select DATEADD(day,datediff(day,0,GetDate())- 14,0) as StartDate, DATEADD(day,datediff(day,0,GetDate()),0) as EndDate Any ideas? My security guy would really like an up-to-date report, not the same old report in his inbox every day :) Gary
