SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS Subscription Requirement


SSRS Subscription Requirement

Author
Message
gayathric.devi
gayathric.devi
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 2
SSRS Subscription Requirements:
Brief Information about the Reports
· We have two SSRS parameterized reports which are linked. First report has a link to the other report.
· Both of the reports have same parameters and second report accepts all parameters from first report when we click on the link in the first report.
· One of the parameter is the first report is Lan Id which is accepting our User Name.
· Parameters have cascading logic applied.
Tasks to be done:
· We need to create 12 subscriptions for the first report and 13 subscriptions on the second report.
· These subscriptions are based on different combinations of the parameter values selected in the drop down which will give different output of the single report (multiple filter results of the same report).
· We need to subscribe these reports to a share point site.
Issues We are facing:
· As per my analysis, we can opt for standard subscription only for one instance of the report and those parameter values we need to specify as default values in the rdl file.
· In this requirement as we are opting for multiple subscriptions of the single report; I think we need to go for Data Driven Subscription. Is it correct?
· But when I click for new Data Driven subscription I get an error saying:
“Data-driven subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or if a linked report, the link is no longer valid.” (In my case credentials are stored)

· Can I create Data Driven subscription for a report having multiple parameters?
· Can I create Data Driven subscription for a report having a link to other report?
Issues facing to deliver reports on share point site:
· Can we deliver reports to share point site using Windows File share?
· Or Do I need to have a share point integrated mode report server?
· If so need details whether we can modify the report server to achieve that?

Sue_H
Sue_H
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: General Forum Members
Points: 33324 Visits: 9534
gayathric.devi - Saturday, December 2, 2017 11:37 AM
SSRS Subscription Requirements:
Brief Information about the Reports
· We have two SSRS parameterized reports which are linked. First report has a link to the other report.
· Both of the reports have same parameters and second report accepts all parameters from first report when we click on the link in the first report.
· One of the parameter is the first report is Lan Id which is accepting our User Name.
· Parameters have cascading logic applied.
Tasks to be done:
· We need to create 12 subscriptions for the first report and 13 subscriptions on the second report.
· These subscriptions are based on different combinations of the parameter values selected in the drop down which will give different output of the single report (multiple filter results of the same report).
· We need to subscribe these reports to a share point site.
Issues We are facing:
· As per my analysis, we can opt for standard subscription only for one instance of the report and those parameter values we need to specify as default values in the rdl file.
· In this requirement as we are opting for multiple subscriptions of the single report; I think we need to go for Data Driven Subscription. Is it correct?
· But when I click for new Data Driven subscription I get an error saying:
“Data-driven subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or if a linked report, the link is no longer valid.” (In my case credentials are stored)

· Can I create Data Driven subscription for a report having multiple parameters?
· Can I create Data Driven subscription for a report having a link to other report?
Issues facing to deliver reports on share point site:
· Can we deliver reports to share point site using Windows File share?
· Or Do I need to have a share point integrated mode report server?
· If so need details whether we can modify the report server to achieve that?


You can have multiple parameters with regular subscriptions or data driven subscriptions. Refer to:
Create, Modify, and Delete Standard Subscriptions (Reporting Services in Native Mode)

The following lists when you would opt for Data Driven Subscriptions:
Data-Driven Subscriptions

Credentials to run reports need to be stored - the data sources need the option selected for Credentials stored securely in the report server. Refer to:
Store Credentials in a Reporting Services Data Source

How things work for links to other reports depend upon how you are linking those, if the subscriber has access, etc. For example, Go to URL can work if the subscriber has access to that URL. So it depends.

You can deliver reports to a Windows File Share. Whether you use Sharepoint as a File share or not is a Sharepoint thing. You'll need to research whether than makes sense or not and consider the limitations. Here is one article on such to get you started:
Using SharePoint as a file share? Limitations you need to be aware about

You would also need to deal with SSRS requirements for delivering the report to a file share - things such as no folders, just to the share:
File Share Delivery in Reporting Services

Some of this all changes if you were in Sharepoint mode instead of native mode. Changing to Sharepoint mode might be documented by MS somewhere but I cant find any current docs. I believe you can do some of it in SharePoint Central Administration. Here is an old MS document on changing:
Changing SQL Reporting Services from Native mode to Integrated mode in a BI test environment

Sue



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search