Home > SSRS Expert > SSRS #68 – Windows File Share in Data-driven Subscription

SSRS #68 – Windows File Share in Data-driven Subscription

Here is a blog I posted , SSRS #60 – Steps to implement a data-driven subscription, a few month ago.

A friend recently had a challenge of the following requirements:

  • Produce 4 reports daily/monthly from 4 existing SSRS report.
  • Use prior day/month as reporting day/month, but use default or All for all other report parameters.
  • Send all 4 reports in 4 PDF files to business in one email.

My friend made the following design decisions:

  • use the 4 existing SSRS report; do not create new reports so maintenance of the reports reside in one report.
  • use data-driven subscription to meet the dynamic requirements of report parameters.
  • use Windows File Share option to push the report to a shared location on the server.
  • once all 4 reports are ready on the shared drive, send them out to business as attachments in email.
    It turned out that using the Windows File Share option can be very confusing. Here are a few tips my friend shared with me. Thanks to her tips.

      1. The data source choice in Step 1 has nothing to do with the access to the shared location on the server.

    The choice of the data source in this case is used by the Report Services to retrieve the dynamic subscription data from your SQL table. It has nothing to do with the account you are going to use (in the later step) to deliver the report to the shared location.

image

2. The account you use to deliver to the shared location, must be a network account. It cannot be a SQL account.

image

image

3. One some servers, the account you use to deliver to the shared location, must be a domain service account.

You must communicate with your system administrator to get the appropriate write access to the shared folder.

Categories: SSRS Expert
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: