Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

A worked example of using spatial and olap data in Reporting Services

In my last post I went through a possible approach for showing spatial and olap data that the RSPB are planning to evaluate, now I want to show you how this might look in an example. First of all an apology, I am not going to pay the £1500 to license UK postcodes as this… Read more

Spatial and OLAP data in Reporting Services

I spent a very interesting afternoon last week with the IT team at the RSPB to explore what they could do to combine their mapping data with the olap cubes they have in analysis services. The only out of the box solution in SQL Server for spatial data is the map control in reporting Services… Read more

SQL Server Reporting Services interop part 2

I forgot one thing on my recent post on Reporting services interop, Report Builder.  What is Report Builder? it’s an end user (information worker in Microsoft speak), tool that creates a report that can run in SQL Server reporting services.  What this actually means is that it creates a xml file with an .rdl extension… Read more

SQL Server Reporting Services interop

SQL Server Reporting Services is nearly ubiquitous as SQL Server itself, it is in nearly all versions of SQL Server from Express (with Advanced services) to DataCenter edition and will soon be available in SQL Azure.   It’s been around for 8 years and if Microsoft used traditional version numbers it would now be on V5. … Read more

Microsoft Business Intelligence without SharePoint

This might be a strange topic given that the release of SharePoint 2010 is just around the corner, but I wanted to respond to a couple of questions and debates I have been involved with in my temporary role in the partner team. I would like to start by going back to the early days… Read more

PowerPivot Installation

I hope my PowerPivot posts and videos are proving useful, and continuing this them I want to cover off installation. PowerPivot for Excel is a free download for Excel 2010 and simply doesn’t need any edition of SQL Server behind it.  It comes in 32 bit and 64 bit depending on which variant of Excel… Read more

Report Builder 3.0 Shared Report Parts

Report Builder 2 in SQL Server 2008 allows for some collaboration on report design between the business user and the IT professional, but this is limited to a working on a whole report.  A possible scenario would be that the IT guy would create a data source  and a query (dataset) and then hand this… Read more

Using Shared Web Parts in Report Builder 3

Introduction Report Builder 3 is built into SQL Server 2008 R2 report manager and is a click once application.  It is also available as a separate download in the feature pack. At the time of writing the November ctp is the latest verison which can be downloaded from here, and the relevant feature pack is… Read more

Report Builder 3.0 SparkLines

As a graphic designer and geek with a masters around cognitive psychology I am intrigued at how little use is made of the wonderful visualisations in many modern BI tools be they from Microsoft, Oracle IBM or SAP. Ignoring this trend, I wanted to show a new visualisation tool in SQL Server 2008 R2 called… Read more

Using SQL Server 2008 R2 Report Builder 3 with Bing Maps

This article shows you how to get started with Report Builder 3 (RB3) and Bing Maps. I could use adventure works to show you this but I thought you might want to see a little bit of our green and pleasant land instead. To do this I have put  the previous SQLBits venues into a… Read more