Gary,
That is spot on, you'll set your parameters to return a "default" date based on
the report execution time.
Additionally, you can simplify your start and end date parameters by using:
Return a date 14 days from now
=Dateadd("d",-14,Today())
Steve
From: [email protected] [mailto:[email protected]] On
Behalf Of Johan van Dijk
Sent: Wednesday, August 21, 2013 11:57 AM
To: [email protected]
Subject: RE: [mssms] Report Subscription
It's mentioned in this article as well:
http://blogs.technet.com/b/meamcs/archive/2012/10/22/configuration_2d00_manager_2d00_2012_2d00_editing_2d00_built_2d00_in_2d00_reports_2d00_using_2d00_report_2d00_builder.aspx
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Johan van Dijk
Sent: Wednesday, August 21, 2013 7:47 PM
To: [email protected]<mailto:[email protected]>
Subject: RE: [mssms] Report Subscription
Believe is something you do in church... :)
Check the parameters....if default is set the date should change....(it does it
for me).
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Gary Ossewaarde
Sent: Wednesday, August 21, 2013 7:36 PM
To: [email protected]<mailto:[email protected]>
Subject: Re: [mssms] Report Subscription
I believe so. It runs every day of the week. It's delivered by E-mail, Normal
Priority, includes link and report as MHTML.
From: Johan van Dijk <[email protected]<mailto:[email protected]>>
Reply-To: "[email protected]<mailto:[email protected]>"
<[email protected]<mailto:[email protected]>>
Date: Wednesday, August 21, 2013 1:31 PM
To: "[email protected]<mailto:[email protected]>"
<[email protected]<mailto:[email protected]>>
Subject: RE: [mssms] Report Subscription
Are you using the default values check marked in the subscription's report
parameters...?
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Gary Ossewaarde
Sent: Wednesday, August 21, 2013 7:21 PM
To: [email protected]<mailto:[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
