Office Zealot

In this blog, let's take a quick look at how to use a map to display nationwide sales data on a SQL Server report. You can jump quickly to the bottom of this blog entry to see how the report will finally turn out. To try out the steps below, you first need a server running SQL Server 2005 with the AdventureWorks database. You also need SQL Server ...

Welcome back to part 2 of my blog on Database-Driven Excel Charting in SharePoint. If you followed the steps from the first part of this blog, you should have an Excel 2007 workbook with a pivot table calling a stored procedure in SQL Server. In this blog, we'll publish this workbook to Excel and configure SharePoint to allow the workbook to ...

Hello everyone. I'm Gus Collazo, a member of the speakTECH Data Services team. Welcome to my first blog entry for speakTECH. In the future I'll focus my blog entries primarily on SQL Server 2008, PerformancePoint Server, and SharePoint. For my first entry though, since I'm working on a project focused on Excel Services, I'll focus on creating ...