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.