Currently, we have SQL Server 2012 R2. Looking to produce some reports and have them automatically run and have converted to PDF with the possibility of automating an email to send to subscribers of specific reports. Going back and forth in my mind about SSRS and Crystal Reports. Think I will go with SSRS.
If this isn't the correct area to post, please let me know.
1) Is it possible to build a report once and then have it automatically run on a schedule?
2) Will it automatically save it as a pdf?
3) What version of SSRS would I need and is there a cost associated with what I am looking to do?
4) Am I assuming correctly that I can install SSRS on my desktop to then connect to the server to create the reports?