Creating a suscription on a parameterized report

I have a report that I just created that has a month and year parameter.
this report is needed at the first of every month to show the activity of
previous month. I would like to create a subscription that executes this
report automatically. Can I set up reporting services to automatically run
the subscription based on the previous month and year each first of the
month?This can be achieved by setting the parameters non-queried default values to
something liek this
=Today.AddMonths(-1)
This will grab todays date (execution date) and add a negative month. you
can do AddDays and AddYears...
for the start date and
"Aaronous" <aaronous@.hotmail.com> wrote in message
news:%230afyX%23DFHA.3928@.TK2MSFTNGP15.phx.gbl...
>I have a report that I just created that has a month and year parameter.
>this report is needed at the first of every month to show the activity of
>previous month. I would like to create a subscription that executes this
>report automatically. Can I set up reporting services to automatically run
>the subscription based on the previous month and year each first of the
>month?
>|||I have been using:
=Today.AddDays(-1)
The result is on the first day of the month, the default parameter is the
previous month. After that, it uses the current month. When I first started
doing this, I used iif(Day(Today()=1) & Hour(Now())<6, Today.AddDays(-1),
Today()). This assumed that the monthly subscriptions ran before 6am on the
1st of the month. I now assume that if somebody wants to look at a monthly
report on the 1st, they really want to see the last month.
"Joseph Scalise" wrote:
> This can be achieved by setting the parameters non-queried default values to
> something liek this
> =Today.AddMonths(-1)
> This will grab todays date (execution date) and add a negative month. you
> can do AddDays and AddYears...
> for the start date and
> "Aaronous" <aaronous@.hotmail.com> wrote in message
> news:%230afyX%23DFHA.3928@.TK2MSFTNGP15.phx.gbl...
> >I have a report that I just created that has a month and year parameter.
> >this report is needed at the first of every month to show the activity of
> >previous month. I would like to create a subscription that executes this
> >report automatically. Can I set up reporting services to automatically run
> >the subscription based on the previous month and year each first of the
> >month?
> >
>
>