How to call subscription through stored procedure with parameters
up vote
0
down vote
favorite
I know that there is an option to call subscription with parameters from stored procedure by data driven subscription but this is possible just in SQL Server enterprise and I don't have it in the company I am working for.
Does any one know if there is an option to all subscription with parameters from the stored procedure without data driven subscription?
sql-server ssrs-2012 edited Nov 11 at 11:41
marc_s
567k12810971248
asked Nov 11 at 8:35
Tehila
32
add a comment |
up vote
0
down vote
favorite
I know that there is an option to call subscription with parameters from stored procedure by data driven subscription but this is possible just in SQL Server enterprise and I don't have it in the company I am working for.
Does any one know if there is an option to all subscription with parameters from the stored procedure without data driven subscription?
sql-server ssrs-2012 edited Nov 11 at 11:41
marc_s
567k12810971248
asked Nov 11 at 8:35
Tehila
32
If you mean data driven reports then yes; that is a feature only available in Enterprise edition. You can, however, replicate the feature by manipulating the XML. There are plenty of guides out there on how to achieve this, but I recommend decent testing first.
– Larnu
Nov 11 at 14:56
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I know that there is an option to call subscription with parameters from stored procedure by data driven subscription but this is possible just in SQL Server enterprise and I don't have it in the company I am working for.
Does any one know if there is an option to all subscription with parameters from the stored procedure without data driven subscription?
sql-server ssrs-2012 edited Nov 11 at 11:41
marc_s
567k12810971248
asked Nov 11 at 8:35
Tehila
32
I know that there is an option to call subscription with parameters from stored procedure by data driven subscription but this is possible just in SQL Server enterprise and I don't have it in the company I am working for.
Does any one know if there is an option to all subscription with parameters from the stored procedure without data driven subscription?
sql-server ssrs-2012 sql-server ssrs-2012 edited Nov 11 at 11:41
marc_s
567k12810971248
asked Nov 11 at 8:35
Tehila
32
edited Nov 11 at 11:41
marc_s
567k12810971248
asked Nov 11 at 8:35
Tehila
32
edited Nov 11 at 11:41
marc_s
567k12810971248
edited Nov 11 at 11:41
marc_s
567k12810971248
edited Nov 11 at 11:41
marc_s
567k12810971248
567k12810971248
asked Nov 11 at 8:35
Tehila
32
asked Nov 11 at 8:35
Tehila
32
asked Nov 11 at 8:35
Tehila
32
32
If you mean data driven reports then yes; that is a feature only available in Enterprise edition. You can, however, replicate the feature by manipulating the XML. There are plenty of guides out there on how to achieve this, but I recommend decent testing first.
– Larnu
Nov 11 at 14:56
add a comment |
If you mean data driven reports then yes; that is a feature only available in Enterprise edition. You can, however, replicate the feature by manipulating the XML. There are plenty of guides out there on how to achieve this, but I recommend decent testing first.
– Larnu
Nov 11 at 14:56
If you mean data driven reports then yes; that is a feature only available in Enterprise edition. You can, however, replicate the feature by manipulating the XML. There are plenty of guides out there on how to achieve this, but I recommend decent testing first.
– Larnu
Nov 11 at 14:56
If you mean data driven reports then yes; that is a feature only available in Enterprise edition. You can, however, replicate the feature by manipulating the XML. There are plenty of guides out there on how to achieve this, but I recommend decent testing first.
– Larnu
Nov 11 at 14:56
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53247068%2fhow-to-call-subscription-through-stored-procedure-with-parameters%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
If you mean data driven reports then yes; that is a feature only available in Enterprise edition. You can, however, replicate the feature by manipulating the XML. There are plenty of guides out there on how to achieve this, but I recommend decent testing first.
– Larnu
Nov 11 at 14:56