I'm trying to determine how difficult it is to automate a process using Powershell. Using Report Builder, I created a simple report with a single parameter, the ID number of the list I use as a datasource. I can open the report, enter the ID and I get the report. Is it possible to use Powershell to run the same report, pass in the ID, export the report as a PDF and save it in the Shared Documents library in the same site?
Maybe something like this? Essentially what this guy is doing is using the WinForms Report Builder dll to pull in the SSRS report and export it using code.
You can upload the file once you have it through code that looks similar to this (referenced from Todd Klindt):
$Web = Get-SPWeb $WebURL $List = $Web.GetFolder($DocLibName) $Files = $List.Files $Files.Add($DocLibName +"/" + $FileName,$PDFExportedFile.OpenRead(),$false)