subscription in 2005, how to define date range dynamically 1

[awaria]

I have a subscription that I want to run once a week using the previoous week's start and end dates.

Is there a function or can someone share the syntax for setting up dynamics dates.

The parameters for the report are Start Date and End Date.

Thank you,

awaria

 

[xlbo]

You just need to set up a data driven subscription - i should be one of the subscription options in the report manager - exactly where it is depends on version of SSRS and whether you are using sharepoint integration mode

In the data driven subscription you are asked to set up a SQL statement that provides sets of values for recipients / parameters etc - all you then need to do is to use SQL to grab teh dates you want and assign them to the parameters

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question