SQL Server Performance

SSRS 2008 oout put locations

Discussion in 'SQL Server 2008 Reporting Services' started by jassie, Feb 10, 2011.

  1. jassie New Member

    I would like to know how to automate SSRS 2008 R2 to a file directory structure. I would like to set this up as a subscription.
  2. satya Moderator

    Do you want to control the subscription programatically?
    You can take help of tools, there are three you should know of:
    - RSConfigTool – (Start menu > SQL Server 2008 > Configuration > Reporting Services Configuration): for troubleshooting, Finding Urls, Configuration Report Server.
    - Report Manager – (http://<yourserver>/reports): for Managing your reports.
    - Business Intelligence Studio – (Start menu > SQL Server 2008 > SQL Server Business Intelligence Development Studio): for Creating and editing your reports.
  3. jassie New Member

    I would like to be able to control the standard subscription in SSRS 2008 r2 to a file share directory using the standard edition of sql server
    2008 r2, I would use the following link:
    http://msdn.microsoft.com/en-us/library/ms157386.aspx.
    The situation I have would be like the followiing:
    1. I want to be able to write to a directory structure that has three levels. The file share directory would look like:
    a. higher level would be region like midwest, east-coast, and west-coast.
    b. The middle level would be state level like Iowa, Ohio, oregon, california, etc...
    c. The third level would be the city name like Council bluffs (which is in Iowa and higher level would be the midwest). Another example would be the city of Anaheim (which is in California which is in the west-coast.)
    To be able to store files in this directory strucutre, could I accomplish task using a standard subscription? If so is there a url you can point me to that would give more details?
    If not, would one of the following two choices be an option:
    - Write a .net application that would accomplsih this task for me? If so, do you have a url I can look at for a reference? If not, I will look on the internet to see how to write this .net code and/or would you recommend what forum group would I ask this question to?
    - Would setting up the standard subscription to e-mail addresses help and then use the
    e-mail addresses to write the file to reports to the file share work?
    If the above does not work, would you recommend writing a .net application to accomplish this task?
  4. satya Moderator

    May be related to other question that its not available in Standard Edition and if you are not able to accomplish it is alwasy better to write in .NET or relevant language to get what you want.
    But make sure to think about scalability and performance if it is going to be used extensively.

Share This Page