[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 114
  • Last Modified:

Sending SSRS reports if a date in the report's result set is in 5 days time

I've got a report I want to send to a recipient dependent on whether the date field in the tablix is five days from today's date. Can I do this via a subscription/data driven subscription in SSRS?
0
Grffster
Asked:
Grffster
  • 2
1 Solution
 
Nico BontenbalCommented:
Yes, you can do this with a data driven subscription.
Create a query to retrieve subscriber data that doesn't return any rows when there aren't and dates five days from now. You have to create a query for this similar to the one that is used by the tablix. You can't refer to the tablix in your subscription. Only to an SQL statement. See the documentation to learn how to use data driven subscriptions:
http://msdn.microsoft.com/en-us/library/ms169673.aspx
0
 
GrffsterAuthor Commented:
Fab, thanks Nicobo. I'll give it a go and let you know how I get on.
0
 
GrffsterAuthor Commented:
Works fab thanks.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now