sharepoint report subscription

I am creating a subscription on my report on sharepoint to deliver it to document library. Is there a way to specify file name with yesterdays date

for example for todays report file name should be  callreport-09032013.pdf
tommores report name should be callreport-09042013.pdf
Angela4evaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rainer JeschorCommented:
Hi,
sorry but there is not out-of-the-box functionality available.

Possible workarounds:
1. Using SSIS
Execute and save the report using SSIS (SQL Server Integration Services) like mentioned here:
http://whitepages.unlimitedviz.com/2012/04/how-to-automate-sharepoint-report-creation-with-ssis-and-ssrs/
Assuming your subscription is based on a time-related schedule, you then can schedule the package to be run as a SQL Agent job.

2. Using Powershell
You might also be able to create a Powershell script to execute and save the report with your desired filename, scheduled via Windows Scheduled tasks.

HTH
Rainer
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.