Tuesday, March 20, 2012

Report subscription to sharepoint

I want to setup a subscription for a report to be copied out to a sharepoint
site. Is this possible? If so, then how do I do it?Hello DilWorth,
If you could use the UNC path to access the Sharepoint Site, you could
setup a Fileshare subscription to copy the report to the sharepoint site.
File Share Delivery in Reporting Services
http://msdn2.microsoft.com/en-us/library/ms159264.aspx
Also, if you want the user to see the report in the sharepoint site, you
could apply the reporting services web part for sharepoint.
The webpart is located C:\Program Files\Microsoft SQL
Server\90\Tools\Reporting Services\SharePoint. You could install the
webpart and implement it in the site.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I am interested in the webpart that you speak of that is located in
C:\Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint.
I went to a presentation that Microsoft did for our company on SRS. They
did a demo on how to post reports to SPS. When asked about the webpart, they
said that as long as you had SP2, this part should appear in our gallery of
webparts. It does not.
When Microsoft was over at my company doing a Business Scorecard
presentation, I asked the developer that said this to come to my desk and
"show me". It wasn't there. He said I did not have SP2. I verified that
the files in a Q article that indicated whether or not one had SP2 were
there; they were. So, it would appear that I have SP2; however, I cannot
locate this webpart. Once I do located it, how do I install it? Do you have
some advice or a Q article or two you could point me to?
Thanks!
-Eleanor
"Wei Lu [MSFT]" wrote:
> Hello DilWorth,
> If you could use the UNC path to access the Sharepoint Site, you could
> setup a Fileshare subscription to copy the report to the sharepoint site.
> File Share Delivery in Reporting Services
> http://msdn2.microsoft.com/en-us/library/ms159264.aspx
> Also, if you want the user to see the report in the sharepoint site, you
> could apply the reporting services web part for sharepoint.
> The webpart is located C:\Program Files\Microsoft SQL
> Server\90\Tools\Reporting Services\SharePoint. You could install the
> webpart and implement it in the site.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||I was able to get the rswebparts.cab installed and able to the part to a
page; however, when I am trying to connect to reporting services, the show
report in function is grayed out.
Do I have some sort of permission issue?
Thanks!
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>

No comments:

Post a Comment