Configuration question on Subscriptions submitted by users.... date related

jamesmetcalf74
jamesmetcalf74 used Ask the Experts™
on
ssrs question with a user submitting a subscription.  Attached is a screenshot of the subscription filters.  The focus is on these two filters for now
Start Date
End Date

The default for the report is set to Start date = today   end date = today + 1 (tomorrow)

This user wants a subscription configured that sets the start date to "Today - "1  and end date set to "today"

is it possible to submit this kind of logic through the subscription interface provided?  if not, best way to tackle this....
ssrs-subscription-question.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
Yes, you can do that and please follow the steps mentioned below for making the startdate and enddate to be with the values you have requested above.. Just replace the below script for the script mentioned in Step 3..
select cast(getdate() as date) startdate, cast(getdate()+1 as date) enddate

Open in new window

https://jackworthen.com/2016/05/06/creating-a-data-driven-subscription-in-sql-server-reporting-services/

Author

Commented:
Thanks Raja
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Welcome, glad to assist!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial