SSRS Subscription Date Parameters [closed]
I have an SSRS report published, and I would like the subscription to sub in today's date as the date parameter every day when it gets emailed out.
But I would like no default date to be set when the user accesses the report directly, so that they may manipulate to whichever date they choose.
Is this possible?
Thanks in advance!
reporting-services ssrs-2008 ssrs-2012 ssrs-tablix reportingservices-2005
asked Nov 20 '18 at 16:02
Jeffrey GarlischJeffrey Garlisch
61
closed as too broad by pushkin, Roman Pokrovskij, lagom, Patrick Mevzek, derHugo Nov 21 '18 at 5:12
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I have an SSRS report published, and I would like the subscription to sub in today's date as the date parameter every day when it gets emailed out.
But I would like no default date to be set when the user accesses the report directly, so that they may manipulate to whichever date they choose.
Is this possible?
Thanks in advance!
reporting-services ssrs-2008 ssrs-2012 ssrs-tablix reportingservices-2005
asked Nov 20 '18 at 16:02
Jeffrey GarlischJeffrey Garlisch
61
closed as too broad by pushkin, Roman Pokrovskij, lagom, Patrick Mevzek, derHugo Nov 21 '18 at 5:12
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I have an SSRS report published, and I would like the subscription to sub in today's date as the date parameter every day when it gets emailed out.
But I would like no default date to be set when the user accesses the report directly, so that they may manipulate to whichever date they choose.
Is this possible?
Thanks in advance!
reporting-services ssrs-2008 ssrs-2012 ssrs-tablix reportingservices-2005
asked Nov 20 '18 at 16:02
Jeffrey GarlischJeffrey Garlisch
61
I have an SSRS report published, and I would like the subscription to sub in today's date as the date parameter every day when it gets emailed out.
But I would like no default date to be set when the user accesses the report directly, so that they may manipulate to whichever date they choose.
Is this possible?
Thanks in advance!
reporting-services ssrs-2008 ssrs-2012 ssrs-tablix reportingservices-2005
reporting-services ssrs-2008 ssrs-2012 ssrs-tablix reportingservices-2005
asked Nov 20 '18 at 16:02
Jeffrey GarlischJeffrey Garlisch
61
asked Nov 20 '18 at 16:02
Jeffrey GarlischJeffrey Garlisch
61
asked Nov 20 '18 at 16:02
Jeffrey GarlischJeffrey Garlisch
61
asked Nov 20 '18 at 16:02
Jeffrey GarlischJeffrey Garlisch
61
asked Nov 20 '18 at 16:02
Jeffrey GarlischJeffrey Garlisch
61
61
closed as too broad by pushkin, Roman Pokrovskij, lagom, Patrick Mevzek, derHugo Nov 21 '18 at 5:12
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as too broad by pushkin, Roman Pokrovskij, lagom, Patrick Mevzek, derHugo Nov 21 '18 at 5:12
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
A solution is to create another parameter like @isForSubscription (and you put it as hidden), that accept True or False (you have to put default_value = False) and you change the default date value parameter to something like
= iif(Parameters!isForSubscription.Value is True, Today(), nothing)
Then, when you configure your subscription, you just need to put @isForSubscription=True
I don't remember exactly but I did something similar once and it worked.
answered Nov 20 '18 at 17:13
NickNickNickNick
1698
Thank you! I just ended up just including an if statement in my stored proc that changed my run parameter to todays date if it was NULL, then set the subscription to pass null for the parameter!
– Jeffrey Garlisch
Nov 21 '18 at 19:42
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
A solution is to create another parameter like @isForSubscription (and you put it as hidden), that accept True or False (you have to put default_value = False) and you change the default date value parameter to something like
= iif(Parameters!isForSubscription.Value is True, Today(), nothing)
Then, when you configure your subscription, you just need to put @isForSubscription=True
I don't remember exactly but I did something similar once and it worked.
answered Nov 20 '18 at 17:13
NickNickNickNick
1698
Thank you! I just ended up just including an if statement in my stored proc that changed my run parameter to todays date if it was NULL, then set the subscription to pass null for the parameter!
– Jeffrey Garlisch
Nov 21 '18 at 19:42
add a comment |
A solution is to create another parameter like @isForSubscription (and you put it as hidden), that accept True or False (you have to put default_value = False) and you change the default date value parameter to something like
= iif(Parameters!isForSubscription.Value is True, Today(), nothing)
Then, when you configure your subscription, you just need to put @isForSubscription=True
I don't remember exactly but I did something similar once and it worked.
answered Nov 20 '18 at 17:13
NickNickNickNick
1698
Thank you! I just ended up just including an if statement in my stored proc that changed my run parameter to todays date if it was NULL, then set the subscription to pass null for the parameter!
– Jeffrey Garlisch
Nov 21 '18 at 19:42
add a comment |
A solution is to create another parameter like @isForSubscription (and you put it as hidden), that accept True or False (you have to put default_value = False) and you change the default date value parameter to something like
= iif(Parameters!isForSubscription.Value is True, Today(), nothing)
Then, when you configure your subscription, you just need to put @isForSubscription=True
I don't remember exactly but I did something similar once and it worked.
answered Nov 20 '18 at 17:13
NickNickNickNick
1698
A solution is to create another parameter like @isForSubscription (and you put it as hidden), that accept True or False (you have to put default_value = False) and you change the default date value parameter to something like
= iif(Parameters!isForSubscription.Value is True, Today(), nothing)
Then, when you configure your subscription, you just need to put @isForSubscription=True
I don't remember exactly but I did something similar once and it worked.
answered Nov 20 '18 at 17:13
NickNickNickNick
1698
answered Nov 20 '18 at 17:13
NickNickNickNick
1698
answered Nov 20 '18 at 17:13
NickNickNickNick
1698
answered Nov 20 '18 at 17:13
NickNickNickNick
1698
1698
Thank you! I just ended up just including an if statement in my stored proc that changed my run parameter to todays date if it was NULL, then set the subscription to pass null for the parameter!
– Jeffrey Garlisch
Nov 21 '18 at 19:42
add a comment |
Thank you! I just ended up just including an if statement in my stored proc that changed my run parameter to todays date if it was NULL, then set the subscription to pass null for the parameter!
– Jeffrey Garlisch
Nov 21 '18 at 19:42
Thank you! I just ended up just including an if statement in my stored proc that changed my run parameter to todays date if it was NULL, then set the subscription to pass null for the parameter!
– Jeffrey Garlisch
Nov 21 '18 at 19:42
Thank you! I just ended up just including an if statement in my stored proc that changed my run parameter to todays date if it was NULL, then set the subscription to pass null for the parameter!
– Jeffrey Garlisch
Nov 21 '18 at 19:42
add a comment |
