Reporting Services with SQL Azure

Abstract

Research for this chapter found that other than a few blog and forum posts, not much information is available regarding the use of SQL Server Reporting Services (SSRS) with SQL Azure. The goal of this chapter is to provide a brief overview and example of how to use SSRS and Report Designer to build reports for SQL Azure, to discuss ways you may be able to improve your SSRS experience with SQL Azure, and to look at ways to improve reporting performance.

Note

All the projects throughout this book have used Visual Studio 2010, which uses the .NET Framework 4.0. But because SQL Server 2008 R2 ships with Visual Studio 2008 BIDS, this example uses version 3.5 of the .NET Framework. So, don’t be confused by what you see in this chapter’s figures versus what you see in other chapters.