On MSDN you can find an very nice article which provides tips for and answers to frequently asked questions for using Microsoft Office SharePoint Server 2007 with Microsoft Office Excel 2007 and Excel Services. It gleans community-contributed information from the SharePoint – Excel Services forum on the Microsoft Developer Network (MSDN).
Now available is a white paper outlining the technologies and steps required to publish PerformancePoint Monitoring Server dashboards in an Extranet. You can download this white paper from:
My collegue Marc Valk has wrote an excellent blog post about Sharepoint and SSRS integration over multiple servers (not the default all on one box) with the famous double hop issues and how to fix them. Read it here:
http://www.marcvalk.net/2009/04/sharepoint-and-ssrs-integration/
Enterprise search and business intelligence are two categories that have been closely linked to one another for some time. As information continues to rapidly grow, so does the need to navigate and make sense of it. Microsoft has disclosed a detailed road map for its enterprise search products, including the introduction of FAST Search for SharePoint and FAST Search for Internet Business. FAST Search for SharePoint will combine high-end search with the broad portal, collaboration, content management and business intelligence capabilities of SharePoint. Get the full details here.
From the MS BI blog.
Theo Lachev has a new blog post with a step to step guide to integrating Report Builder 2.0 with SharePoint. One thing to notice here: it only works with SQL Server 2008 SP1!
Read the guide here: http://prologika.com/CS/blogs/blog/archive/2009/02/25/report-builder-2-0-clickonce.aspx
Debugging SharePoint can be problematic at times, it does like to hide debugging information from you. The bain of my life recently has been “An unexpected error has occurred” with nothing written to log files, trace or the event log.
Normally I can debug the problem with a little commenting & narrowing down of the problem, but today I have managed to get rid of that error screen completely.
The solution is to change a single entry in web.config, by modifying the line…
<SafeMode MaxControls=“200“ CallStack=“false“…
to…
<SafeMode MaxControls=“200“ CallStack=“true“…
You will also need to set custom errors to ‘Off’ .
<customErrors mode=“Off“/>
You will no longer see the “An unexpected error has occurred” error page and instead you get a lovely ’standard ASP.Net error page’ with the stack trace and everything…development has got that little bit easier!!
We use a closed SharePoint blog for a client with NT security and use the RSS to display the posts on a remote .NET portal. The RSS by default shows items only for a week and uses only 25 items, these setting couldnt be changed so we thought.
but after some extensive SharePoint clicking I finally found the settings page. It wasn’t at the RSS part of the site settings page of the site, it was at the site settings of the List of blog posts. So go to your list, list settings. under Communications you’ll find RSS settings. Here you can edit the “Maximum items to include”, “Maximum days to include” and which Columns to include.
