SharePoint/Project Server 2010 (BI) - auto PDF generation of a SSRS report
This is really more or a less a SSRS question as used as a part of Project Server 2010 - BI. We have a project report (rdl file), which is essentially a SSRS report and it can be exported into PDF file via the SSRS report viewer control. There is a requirement for some automatic way to have the same report be generated for all the projects in the EPM system and stored in their PDF versions individually or in a one big file (on the file system). (The report server has been configured in "SharePoint integrated" mode and this report is stored in a document library inside BI of SharePoint/Project Server 2010) Any suggestion about how to handle this request would be highly appreciated. Thanks in advance.
May 9th, 2012 10:30pm

Sounds like a SSRS question and not specific to PS...Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights. Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
Free Windows Admin Tool Kit Click here and download it now
May 9th, 2012 10:56pm

Sure. Thanks Chris for re-directing this post to this forum. Lets see if some one from this forum can provide some feedback/comments on my original query above!! Thanks.
May 10th, 2012 9:11am

Hi Srini-coder, From your description, you want the report to be exported to a PDF file automatically and saved to the SharePoint site. If I have misunderstood you, please feel free to correct me. Based on your scenario, you can achieve your goal by creating a subscription for the report. A subscription is a standing request to deliver a report at a specific time or in response to an event, and in a specific file format that we specify in the subscription. By default, we can create subscriptions that send reports to a shared folder or to an e-mail address. If the report server is configured for SharePoint integrated mode, we can also send a report to a SharePoint library. In this issue, you can create a Standard Subscription for the report, set the schedule which controls the report processing, set the report rendering format to PDF, and then deliver the subscription to a library within the same SharePoint site. To create the subscription, the report must use stored credential to connect to the data source. In addition, you must have Add Items permission on the SharePoint library to which the report is delivered. For the details information, please see: Create and Manage Subscriptions (Reporting Services in SharePoint Mode)SharePoint Library Delivery in Reporting Services Hope this helps. Regards, Mike Yin
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2012 3:49am

Mike is absolutely correct You may have an issue if the report contains multiple parameters, and you wish to auto generate the report based on multiple combinations of those parameters. Your solution is to create multiple subscriptions - one for each combination of report parameters. This however can get unwieldy quite quickly. The solution to this problem is to use data driven subscriptions. http://msdn.microsoft.com/en-us/library/ms159150.aspx The only problem with data driven subscriptions is that they require the Enterprise version of SSRS, which may not be the case for everyone. In those cases, I have blogged a solution that will do the trick that uses SSIS - http://whitepages.unlimitedviz.com/2012/04/how-to-automate-sharepoint-report-creation-with-ssis-and-ssrs/ Hope this helpsJohn
May 11th, 2012 9:25am

Thanks for the responses. As per the original request the exported PDFs have to be get saved on the file system. Based on my further research on the NET, I am now really looking for some feedback on using the reportingservice2006 asmx Web Service in-case some one can suggest how this can be used for the purpose of generating PDF from a SSRS report. Thanks again.
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 1:11am

Hi Srini My link above details precisely such a scenario (It uses SharePoint libraries instead of the file system, but the file system is actually a lot easier). It's a step by step walkthrough. http://whitepages.unlimitedviz.com/2012/04/how-to-automate-sharepoint-report-creation-with-ssis-and-ssrs/ Good luckJohn
May 15th, 2012 6:44am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics