SSRS My Subscriptions view

Subscriptions failing after migrating a Native mode SSRS Report Server database

I was recently involved with the migration of a Native mode SQL Server Reporting Services (SSRS) database from a non-domain server to a domain-based server.  The migration itself was fairly straightforward (as it usually is) thanks to the inherent portability of the Report Server database and required configurations, such as encryption keys and .NET config files.  However, after getting everything up and running on the new server, and successfully testing the reports manually, I discovered that the report Subscriptions were failing. Continue reading “Subscriptions failing after migrating a Native mode SSRS Report Server database” »

The common interface for SSAS query designer

How To Connect SSRS Report Builder to an SSAS Cube

I was asked recently how one could use SQL Server Reporting Services (SSRS) Report Builder construct a report using a SQL Server Analysis Services (SSAS) cube as it’s data source.  The good news is that is just as simple as connecting to a SQL Server database, there’s really very little difference, at least if you using the GUI route. Continue reading “How To Connect SSRS Report Builder to an SSAS Cube” »

How To Enable Remote Errors in SQL Server Reporting Services (SSRS)

Just a quick one for a Wednesday afternoon.  I was recently asked if it was possible to enable remote errors in SQL Server Reporting Services (SSRS), so that people (and applications) could return full error details from RDL execution, without having to consult the local log files.  It’s an incredibly easy task to enable this.  Here’s how: Continue reading “How To Enable Remote Errors in SQL Server Reporting Services (SSRS)” »

Add a new Data Source to an RDL

How To Connect SSRS Report Builder to a PowerPivot Excel file (Sharepoint)

So, you’ve finally got around to setting up that SQL Server 2012 environment and you’re playing about with PowerPivot and SQL Server Analysis Services.  You’ve set up your sharepoint site and you’ve created and uploaded a new spreadsheet using PowerPivot that contains all that tasty cube data.  However, in your haste, you haven’t set up SQL Server Reporting Services Report Builder on the Sharepoint site, so when you open Report Builder on a separate server (or from a local install), and want to connect into your new quasi-cube (via your PowerPivot Excel file), how do you do it?  The Report Builder side of things is not too dissimilar to using a traditional SSAS cube as a Data Source.

The answer, is deceptively simple if you know where to look. Continue reading “How To Connect SSRS Report Builder to a PowerPivot Excel file (Sharepoint)” »

Now I've added my sub report control to both of the 2 tables

How To Create Multi-Column Lists in SQL Server Reporting Services (SSRS)

I recently encountered a scenario where I wanted to display my report content in the form of a multi-column list.  In essence, I was looking to create the SQL Server Reporting Services (SSRS) equivalent of an ASP.NET Repeater, to render my report content both horizontally and vertically (in this case a dynamically repeated SubReport) a number of times dictated by my source dataset.  I spent a little bit of time investigating some more complicated possibilities such as building a matrix of row and column groupings when the solution finally hit me.  It is simply brilliant in its simplicity.  Here’s how to do it. Continue reading “How To Create Multi-Column Lists in SQL Server Reporting Services (SSRS)” »