Hi all,

I am setting up subscriptions for a number of reports I've created, and I've successfully managed to have them write to the fileshare folder. Some of the reports have date parameters (start and end date etc.), and I've got them working by entering the dates in the parameter values at the bottom of the subscription page. However, what if I want to have the reports run on a daily basis using different dates each day - for example, run using "today" as a parameter, or maybe "today" as the 'end date' and "today - 7 days" as the 'start date'? Is this something I'm going to be able to set up?

Thanks in advance
Scott

hello,my english is pool,
but i would try to make it clear to you

first,create a new table called "dual" in your sql

database,suppost the datebase is called "test",
just one column in the table "dual",
full one datetime recode such as "2007-01-01" in it
you can use any date,it's not important.

suppost that you have set up a dateset
and the sql is:
select count(*)
from product
where sales_date=@tj_date

and @tj_date is the parameter

turn to the "data" item
add a new dataset,"name" item is "rdate"
"Query sting" is the sql
"select getdate()-1 from dual"
or "select '2007-10-27' from dual"

turn to "layout" page item,find and click "report

parameters"
a setting box would come out
if every thing's right,you will find the parameter "@tj_date",
and "Default values" choose "From query"
and you will find "rdate" in the list,just choose it.
ok build your program, it's what you want.