Default date parameter in subscription

Hi all. Does anyone know how I can provide today's date as a subscription's
default date parameter? I thought I might be able to just state =Today() or
something similar when creating the subscription but it doesn't seem to work
out.
Thanks in advance.When you publish the report initially on the report server, the default
value of the report parameter has to be =Today. Expressions as parameter
values can only be defined on the initial report publishing.
Every explicitly user-specified parameter value on the report execution or
when setting up a subscription will be interpreted as constant value and not
as expression.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raul R" <roller8@.hotmail.com> wrote in message
news:ehkI80%231EHA.3820@.TK2MSFTNGP11.phx.gbl...
> Hi all. Does anyone know how I can provide today's date as a
subscription's
> default date parameter? I thought I might be able to just state =Today()
or
> something similar when creating the subscription but it doesn't seem to
work
> out.
> Thanks in advance.
>|||This may be a dumb question, but how do you set default values for parameters
when publishing?
I tried by going into the dataset properties and under the parameters tab
setting the value next to one of my params to '=datetime.today.adddays(-1)'
but when running the report i'm still prompted for the values...
My goal is to have this report setup w/ subscriptions that automatically run
using the previous days date, and also provide the flexibility to the user so
they can enter any date range they want...
Thanks!
"Robert Bruckner [MSFT]" wrote:
> When you publish the report initially on the report server, the default
> value of the report parameter has to be =Today. Expressions as parameter
> values can only be defined on the initial report publishing.
> Every explicitly user-specified parameter value on the report execution or
> when setting up a subscription will be interpreted as constant value and not
> as expression.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Raul R" <roller8@.hotmail.com> wrote in message
> news:ehkI80%231EHA.3820@.TK2MSFTNGP11.phx.gbl...
> > Hi all. Does anyone know how I can provide today's date as a
> subscription's
> > default date parameter? I thought I might be able to just state =Today()
> or
> > something similar when creating the subscription but it doesn't seem to
> work
> > out.
> >
> > Thanks in advance.
> >
> >
>
>|||Once a report is published on a report server and you then publish a report
with the same name and the same report parameter names, the information from
the new report gets merged with the old report. This is very useful for
production environments where you have your data sources pointing to
production databases and probably certain constant parameter default
settings. Hende, just "updating" the report won't trash your configuration
settings.
If you want to avoid this behavior, just delete the report from the report
server before you publish it again. Then the default values specified should
take effect.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ben Sullins" <BenSullins@.discussions.microsoft.com> wrote in message
news:1EDE6675-EF22-47D4-A832-8FD90481D141@.microsoft.com...
> This may be a dumb question, but how do you set default values for
parameters
> when publishing?
> I tried by going into the dataset properties and under the parameters tab
> setting the value next to one of my params to
'=datetime.today.adddays(-1)'
> but when running the report i'm still prompted for the values...
> My goal is to have this report setup w/ subscriptions that automatically
run
> using the previous days date, and also provide the flexibility to the user
so
> they can enter any date range they want...
> Thanks!
> "Robert Bruckner [MSFT]" wrote:
> > When you publish the report initially on the report server, the default
> > value of the report parameter has to be =Today. Expressions as parameter
> > values can only be defined on the initial report publishing.
> > Every explicitly user-specified parameter value on the report execution
or
> > when setting up a subscription will be interpreted as constant value and
not
> > as expression.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Raul R" <roller8@.hotmail.com> wrote in message
> > news:ehkI80%231EHA.3820@.TK2MSFTNGP11.phx.gbl...
> > > Hi all. Does anyone know how I can provide today's date as a
> > subscription's
> > > default date parameter? I thought I might be able to just state
=Today()
> > or
> > > something similar when creating the subscription but it doesn't seem
to
> > work
> > > out.
> > >
> > > Thanks in advance.
> > >
> > >
> >
> >
> >