Post reply

Sending report by email from Reporting Services to Shairpoint?

  • January 7, 2009 at 4:05 pm

    #204725

    I was asked to develop a following thing. On one server there are Reporting Services. I need to create a report and schedule it to run once a week sending a report as an email with the Excel file and I know how to do that.

    A hard part is that email should go to the ShairePoint which is on a different server and leave that Excel file there so other users can access it there without bothering the SQL Server with the heavy SQL query from the Reporting Services all the time.

    I am not familiar with the sharepoint and I don't know if such manipulation between two applciations is even possible.

    Is there any other way on how to automatically publish report from Reporting Services on the Sharepoint?

    Thanks..

    :unsure:

  • January 10, 2009 at 10:48 am

    #924844

    I am unsure of exactly what you are doing but one technique I would consider is to schedule the report, cache it for a week, setup a Page Viewer WebPart in SharePoint, and point that Page Viewer WebPart to the cached report. The Page Viewer WebPart is a special WebPart that basically provides an iFrame function within SharePoint. You just point it to the cached version of the report via the SSRS Web Service functionality and it displays it. This way the SSRS would have to serve up the cached report but would not have to re-query each time it was requested.

    Now if the idea is to keep versions of the report in a SharePoint document library this would not work and you would have to write something that interfaced with the SharePoint document library.

    Good luck

    Mike

  • January 12, 2009 at 7:43 am

    #925267

    I haven't done this, but I'm glad you posted the question because it has been discussed here is past conversations. Sharepoint and ssrs are built to work together, you may have to download some software? Here is a link that should get you going:

    http://blogs.msdn.com/sharepoint/archive/2007/08/02/microsoft-sql-server-reporting-services-installation-and-configuration-guide-for-sharepoint-integration-mode.aspx

    Let us know how it goes...I'm interested to hear about it...

    Thanks

  • January 12, 2009 at 4:21 pm

    #925627

    Unfortunately they need to keep weekly snapshots of the report for the statistical purposes so I still need to upload excel files.. SharePoint is a completely new area for me, we just got it installed. A lot of things to learn...

  • January 12, 2009 at 4:22 pm

    #925628

    Thank you, Bob!

    I am going to investigate it...

  • January 13, 2009 at 7:22 am

    #925860

    Is it possible for you to use the built-in "Report Viewer" webpart included in SharePoint in order to display this particular SSRS Report? Since this webpart is included with SharePoint and built to display SSRS Reports, it seems like this would be the better solution to your issue.

  • January 13, 2009 at 9:11 am

    #926000

    SSRS subscription can be either Email or File Share

    I'd try File Share, and schedule it to a UNC directory, perhaps even SharePoint if you can access it in SSRS

    \\Server\SharedReportFolder

    or hopefully http://sharepoint/Documents/....

    Then SSRS will automatically store the report there in the chosen format, say PDF or Excel

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • January 15, 2009 at 8:25 am

    #927377

    Thanks!

    This will work..

  • July 6, 2009 at 4:01 pm

    #1020740

    I use the technique described (Page Viewer Web Part, report caching) but when I have it cached, the Dundas images in my report don't display in SharePoint-it's just the red x. When the report is not cached everything works fine.

    Any ideas on what the issue is?

    Thanks.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply