setup a subscription for the previous day's report to be generated

[Ethel Lazaro]

Hi

I have setup a subscription for a report to run on a daily basis and be delivered by email. However, when creating the subscription it asks for me to enter a specific date range. After providing this date(eg 31-OCT-2011), now I find that it delivers the report successfully every day but it uses the same date, ie the report of the 31st?s data range is generated and emailed every time.

I want it to use the previous days date when running this report. Please can someone guide me how I go about configuring this.

Any help is highly appreciated.

[Iosif Sainiuc]

Post by Ethel Lazaro
Hi
I have setup a subscription for a report to run on a daily basis and be delivered by email. However, when creating the subscription it asks for me to enter a specific date range. After providing this date(eg 31-OCT-2011), now I find that it delivers the report successfully every day but it uses the same date, ie the report of the 31st?s data range is generated and emailed every time.
I want it to use the previous days date when running this report. Please can someone guide me how I go about configuring this.
Any help is highly appreciated.

If i understand correctly the problem than you're report has a date type parameter, let's say @Date. In order to send the previous date as parameter value to the report you need to set a default value to @Data using the expression :
DateAdd("d",-1,Today()).