I need to embed my report in our company portal site, which is run by SharePoint.
What is the best way to do this? Can anyone please help me?
Is this just a matter of copying & pasting URL for the report, and embed into html file…?
*This report has to be Auto-refreshed every day
*I do not want to send reports to SharePoint Library.
I want the report to be open and updating itself 24/7
The easier method is to add a Page View web part, and give it an openDocument link to your report. Be sure to include the sRefresh=Yes parameter. This will open the report in a frame and refresh it. The only downside (such that it is) is that the full BO toolbar will be displayed, not just the report body.
You could instead use Integration Option for Microsoft Sharepoint (IOMS), which will provide native support for displaying BO content in SharePoint.