My PASS Summit: SQL Azure Sync Services Preview and Management Portal Demo of 10/19/2011 provided a walkthrough of the new Sync Services Preview. This post, which is based on the SQL Azure Reporting Samples TechNet Wiki article of 2/1/2011 (revised 10/11/2011), provides similar treatment of the SQL Azure Reporting Services Preview.
A Service Release, promised by the end of 2011, will implement release versions of these and the other new SQL Azure features described in my Quentin Clark at PASS Summit: 150 GB Max. Database Size and Live Federation Scaleout for SQL Azure post.
This Part 3 covers:
- Creating a Hosted Service and Storage Account for Your Subscription
- Downloading and Opening the SQLAzureReportingPreviewCodeSamples in VS 2010
- Displaying the report in a ReportViewer control in a Windows Azure application.
Part 2 covered:
- Setting up a SQL Azure Reporting Services Preview (SQLAzRSP) server
- Testing the SQLAzRSP server in a browser
- Deploying a sample report from BIDS to the SQL Reporting Services Preview Server
- Viewing the sample report in a browser
- Exporting and printing the sample report from a browser
My PASS Summit: SQL Azure Reporting Services Preview and Management Portal Walkthrough – Part 1 post (updated 10/22/2011) covered:
- Obtaining a Windows Azure Platform Subscription
- Creating a SQL Azure Web server instance
- Downloading the files for and creating the AdventureWorksLTAZ2208R2 SQL Azure database
- Opening a SQL Azure database in SQL Server Management Studio 2008 R2 Express
- Opening a SQL Azure database in the Windows Azure Management Portal’s Web-based Database manager
- Downloading and opening the SQL Server Reporting Preview Report Samples in Business Intelligence Design Studio (BIDS)
- Previewing a Report Sample in Business Intelligence Design Studio (BIDS)
This walkthrough requires completion of the steps in Parts 1 and 2, Visual Studio Web Developer 2010 Express SP1 or higher, and a Hosted Service for your Subscription. You can download Visual Studio Web Developer 2010 Express at no charge here. Visual Studio 2010 SP1 for all versions is available here. This walkthrough uses VS 2010 Ultimate.
Create a Hosted Service and Storage Account for Your Subscription
1. Click the navigation pane’s Hosted Services, Storage Accounts & CDN button, click the Services button to open a list of your subscriptions, and select the subscription for your SQL Azure database and Reporting Services (OakLeaf Cloud Essentials for this example):
Note: See the How to Create a Hosted Service: Windows Azure topic for more detailed information.
2. Click the New Hosted Service button to open the Create a New Hosted Service dialog. Select the Do Not Deploy option and Complete the items, except Package Location and Configuration File, with values appropriate to your organization:
Note: The URL DNS prefix must be unique to everyone’s SQL Azure services.
3. Click OK to create the Hosted Service:
4. Click Storage Accounts in the Navigation Pane to open the Storage Account pane and select the same subscription:
5. Click the Storage group’s New Storage Account button to open the Create a New Storage Account dialog, choose the current subscription, enter a DNS prefix consisting of lower-case letters and numerals only, and select the current region:
6. Click OK to add the Storage Account to the subscription:
7. When the Creating… status changes to Created, click the Storage group’s View Access Keys button to open the View Storage Access Keys dialog, which displays Base64-encoded keys to access your storage account:
Note: The key values are partially obscured to prevent others from gaining access to the storage account.
Download and Open the SQLAzureReportingPreviewCodeSamples in VS 2010
9. Download and save SQLAzureReportingPreviewCodeSamples.zip from the Windows Azure ReportViewer Control Sample (released 2/1/2011, updated 10/11/2011) from the MSDN Download center.
10. Extract all files to a new Documents\My Documents\Visual Studio 2010\Projects\SQLAzureReportingPreviewCodeSamples folder:
11. Launch your Visual Studio 2010 SP1 version, choose File, Open, Projects/Solutions, open the SQLAzureReportingPreviewCodeSamples folder, and select SQLAzureReportingSamples.sln:
12. Click OK to start the Visual Studio Conversion Wizard, click Next and finish to update the solution to VS 2010 SP1 in place.
13. Click OK in the Conversion Complete dialog to open the solution in Visual Studio with ReportViewerRemoteMode as the start-up project. Double-click Solution Explorer’s README.txt node to open the project documentation:
Following is the README.txt file’s content:
These sample projects demonstrates how to incorporate cloud reporting into your application scenarios.
"SOAP Management demonstrates how to connect to the SOAP endpoint of an SQL Azure Reporting instance and perform management tasks.
"ReportViewer Remote Mode" demonstrates how to host a SQL Azure Reporting report in ReportViewer, running in Windows Azure.
To successfully run the sample projects, you need:
- Windows Azure SDK using Microsoft Visual Studio. Installation instructions can be found at http://msdn.microsoft.com/en-us/windowsazure/cc974146.aspx.
- An active account for SQL Azure Reporting with the server name, username, and password. See http://go.microsoft.com/fwlink/?LinkID=204134&clcid=0×409.
- Reports hosted in your SQL Azure Reporting instance.
- To deploy the projects to Windows Azure: An active account at https://windows.azure.com.
TO RUN THE SAMPLES
- Open Global.config in the solution root and supply values for all settings.
- Click Run.
NOTE: Ignore the warnings "The web role is configured using a legacy syntax that specifies that it runs in Hostable Web Core…."
For more information, see SQL Azure Reporting samples: http://go.microsoft.com/fwlink/?LinkId=207630.
14. To be continued on 10/23/2011.