Dynmaic parameter on Subscription report

Is it possible to have a dynamic parameter value such as current date
to a subscription base report?
Thanks,
Voss.Yes. You can set the default parameter =today() in the designer.
"Voss" wrote:
> Is it possible to have a dynamic parameter value such as current date
> to a subscription base report?
> Thanks,
> Voss.
>sql

Dynamically change From address for data driven subscription?

Is this possible? We need to set the from address differently for groups of
people so if the email bounces the right person sees it. Any help would be
greatly appreciated!I don't think it is possible. As a workaround consider implementing a rule
that will examine the subject of the bounced e-mail and forward it to the
right e-mail.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"MurrayT" <MurrayT@.discussions.microsoft.com> wrote in message
news:BE29E3E6-1536-4588-A129-99F07B3F7A01@.microsoft.com...
> Is this possible? We need to set the from address differently for groups
of
> people so if the email bounces the right person sees it. Any help would be
> greatly appreciated!
>

Dynamic Subscriptions in SQL Server 2005

Is there a way to dynamically populate the To: email address from a
database when setting up a subscription?
We would like to search a database for user activity and only deliver
reports to the user that that activity pertains to.
If not in native Reporting Services is there an add-on that will do
this?On Apr 14, 11:59=A0am, DaveK <1027...@.gmail.com> wrote:
> Is there a way to dynamically populate the To: email address from a
> database when setting up a subscription?
> We would like to search a database for user activity and only deliver
> reports to the user that that activity pertains to.
> If not in native Reporting Services is there an add-on that will do
> this?
Yes, data driven subscriptions, available in the Enterprise version,
has the ability to set all delivery specific settings and report
parameters based on a query executed at run-time.

Dynamic Subscription Parameters

Ok I've seen this question asked often, but it appears no one has come
up with an answer.
I have a report that is viewed most often though a portal with the
default parameters of startdate (yesterday) and enddate (today). Now
the request has come in for a different group of people to be able to
create their own subscription for this report, but they want to see the
data on a weekly basis.
So the question is... Are there any expressions, bits of code, code
words etc that will be accepted on a user subscript to set the date for
a report (without using the default)
I've tried...
=Today()
=datetime.today.adddays(-1).tostring("mm/dd/yy")
datetime.today
datetime.today(adddays(-7)
NOW
but every time I enter one of those in the parameter box, they revert
to the default value.Why not have the parameter as a flag instead of dates, 1 = daily, 2 =weekly then default the dates used in the query based on the flag?
If the report must be available for ad-hoc runs with date parameters
available to users as well, simply have the flag parameter as well as
date parameters, hide the flag parameter in Report Manager, and default
it to zero to indicate that the date parameter be used instead. Your
data query will be a little more complex but it shouldn't be too bad.
--
Regards
Chris
Ches Weldishofer wrote:
> Ok I've seen this question asked often, but it appears no one has come
> up with an answer.
> I have a report that is viewed most often though a portal with the
> default parameters of startdate (yesterday) and enddate (today). Now
> the request has come in for a different group of people to be able to
> create their own subscription for this report, but they want to see
> the data on a weekly basis.
> So the question is... Are there any expressions, bits of code, code
> words etc that will be accepted on a user subscript to set the date
> for a report (without using the default)
> I've tried...
> =Today()
> =datetime.today.adddays(-1).tostring("mm/dd/yy")
> datetime.today
> datetime.today(adddays(-7)
> NOW
> but every time I enter one of those in the parameter box, they revert
> to the default value.|||Oh I love it when people think out of the box!!!!
Great suggestion. I'll look into implementing today.|||Oh I love it when people think out of the box!!!!
Great suggestion. I'll look into implementing today.