Reporting Services with SQL Azure : Starting a SQL Azure–Based Report

1/22/2011 4:08:21 PM
When you're creating reports that access data from SQL Azure, the process is the same as creating reports that access local data, with one slight difference: the connection to the data. These examples use SQL Server 2008 R2. It comes with Visual Studio 2008 Business Intelligence Development Studio (BIDS), and that is what you use to create and deploy the reports. To create a report, follow these steps:
  1. Open BIDS, and create a new Report Server Project. In Figure 1 the project is called AzureReports, but feel free to change the name. Click OK.


    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.

    Figure 1. New Report Server Project
  2. In Solution Explorer, right-click the solution, and select Add → New Item from the context menu.

  3. In the Add New Item dialog, select the Report template, and name this report Documents, as shown in Figure 2. Click OK.

    Figure 2. Adding a report

At this point, you're staring at a blank report, but you also see a new Report Data tab displayed in the Visual Studio IDE. Your task is to tell the report where to get its data from, and SQL Server 2008 R2 makes it very easy. Prior to SQL Server 2008 R2, you had a couple of data providers to choose from: ADO.NET (SqlClient) and OLE DB. However, R2 added a new SQL Azure–specific provider. You see this shortly.

Top 10
SG50 Ferrari F12berlinetta : Prancing Horse for Lion City's 50th
The latest Audi TT : New angles for TT
Era of million-dollar luxury cars
Game Review : Hearthstone - Blackrock Mountain
Game Review : Battlefield Hardline
Google Chromecast
Keyboards for Apple iPad Air 2 (part 3) - Logitech Ultrathin Keyboard Cover for iPad Air 2
Keyboards for Apple iPad Air 2 (part 2) - Zagg Slim Book for iPad Air 2
Keyboards for Apple iPad Air 2 (part 1) - Belkin Qode Ultimate Pro Keyboard Case for iPad Air 2
Michael Kors Designs Stylish Tech Products for Women
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
Popular Tags
Video Tutorail Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Exchange Server Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe Photoshop CorelDRAW X5 CorelDraw 10 windows Phone 7 windows Phone 8 Iphone