CODEWITHSUNDEEP
ssrs-2008business-intelligence
user3075455
user3075455

Reputation: 21

Auto generate SSRS report daily - excel format - report server

I've been tasked with creating a SSRS report that will automatically run every day @ 2 PM and dump the results via excel format into a designated folder on the report server. Can someone point me in the right direction!?

Thank you!

Upvotes: 1

Views: 1052

Answers (1)

Hannover Fist
Hannover Fist

Reputation: 10870

When you Deploy your report to the Report Server, you can set up a Windows File Share Subscription to place a file in the folder you need.

enter image description here

The folder's permissions will be your nemesis.

Upvotes: 1

Related Questions