Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Subscription -Date Variables

Author  Topic 

ZMike
Posting Yak Master

110 Posts

Posted - 2010-12-16 : 20:40:16
Hi all,

I have not found an answer to this but I'd think one would exist so I'm hoping somone may already know the answer.

We have a few Reports on Reporting Services that we dont want to default dates.

We wabt to let the users decide dates (They usually want a Daily, Weekly and Monthly versions of the report)

If I default the actual report to say Yesterday I'd use the following
= DateAdd(DateInterval.Day, -1 ,Today())


Is there logic that can be put in the subscription so you can default the days ??
   

- Advertisement -