Automating the MOSS -SSRS site export.

Mon, 29 Jun 2009 22:35:45 Z

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

Automating the MOSS -SSRS site export.

Mon, 29 Jun 2009 23:28:12 Z

Add a content editor WebPart and add this code:

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/

Automating the MOSS -SSRS site export.

Tue, 30 Jun 2009 03:03:49 Z

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.

Automating the MOSS -SSRS site export.

Tue, 30 Jun 2009 08:12:47 Z

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

Automating the MOSS -SSRS site export.

Tue, 30 Jun 2009 16:10:57 Z

Raghavan,

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

Thanks for your suggestion.