Windows File Share - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Windows File Share

Author

Topic

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2013-12-05 : 20:28:41

Hi,

I have a requirements to subscribe an SSRS report and save to my PC.
Is there any idea guys on how to do this. I tribe to save in Server and its working but on the local pc i got an error. Thanks.

This is what i did.

\\PHL0154\c$\Docs File

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-12-06 : 05:06:32

you can use report subscription for that. choose delivery method as filesher and give the required path. The service sccount should have access to path where you need to store the reports

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2013-12-08 : 21:40:50

This is what i did in my subscription when saving the report to Server and its working. but if i will subscribe to save the report to my Local drive/computer
what is the exact path to save the report. thanks.

Delivered By: Windows File Server

Path: \\jovabcde69\sample-pubdata\150 - My File\Report\sample.xlsm

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-12-09 : 01:42:22

quote:
Originally posted by Villanuev

This is what i did in my subscription when saving the report to Server and its working. but if i will subscribe to save the report to my Local drive/computer
what is the exact path to save the report. thanks.

Delivered By: Windows File Server

Path: \\jovabcde69\sample-pubdata\150 - My File\Report\sample.xlsm

Use UNC path for that
ie \\yourmachinename\...
or \\YourIPAddress\....
Your folder should be shared giving access to the service account which executes the report from the subscription.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2013-12-11 : 20:25:53

THanks Visakh.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources