Automating the MOSS -SSRS site export.

Question

Hi,

We are developing a SSRS 2005 integrated with MOSS 2007 solution to create a dashboard with SSRS web parts.
One requirement is to export the complete site view containing various web parts to PDF or an image on a schedule or triggered by another process.

Has anyone done anything similar?
Can you provide some direction on how to achieve this?

Any help is appreciated . Thanks 

Answer 1

Add a content editor WebPart and add this code: 

<script> function printWindow(){ bV = parseInt(navigator.appVersion) if (bV >= 4) window.print() } </script> <img src="/imagens/print_ico.jpg" alt="Print This Page"> <a href="javascript:printWindow()">Print This Page</a>  

Install PDF Creator http://sourceforge.net/projects/pdfcreator/  

On print select PDF and you get page site as PDF  

Hope this help...

---

André Lage Microsoft SharePoint and CRM Consultant
Blog:http://aaclage.blogspot.com
Codeplex:http://spupload.codeplex.com/http://simplecamlsearch.codeplex.com/

Answer 2

thanks, but this would be provide a link to print/export the site as a PDF.

I am looking to automate this process without user interaction. At a certain time or triggerred by the some event, the reports would be executed and and the snapshot of the site would be stored in pdf/image.

Answer 3

Hi essbee12,

My understanding:
1) You have many reports created using SSRS and want to display them in the SharePoint
2) You have many SSRS reports [say 4]
3) You want to automate to create all the SSRS [4 reports] to be converted to a PDF

Are you having the SSRS integrated with SharePoint (or) just displaying the SSRS reports in the report viewer web part?

My Suggestion:
1) SharePoint here is mainly used to display the report
2) To automate the PDF creation, trying achieving the requirement in the SSRS end itself
3) You can write .net console / windows app to achieve this
4) Had the data been in SharePoint environment we can try to use SharePoint timer Job, but for your requirement i feel you can handle it without any SharePoint involvement

Hope this helps

---

Raghavan

Answer 4

Raghavan,

The SSRS reports will be deployed in the report viewer web part. 

Thanks for your suggestion.