SSRS Subscription Requirement

  • 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?

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply