Windows Azure SQL Reporting Overview

This page contains resources and information that will help you learn more about Windows Azure SQL Reporting. If you are already familiar with SQL Reporting and are looking for product documentation, news and events, or a list of additional resources, please visit the following sites:

Introduction

In this article:

Getting Started
How To
Training
Samples
Feedback and Community

Windows Azure SQL Reporting is a cloud-based service built on the Windows Azure platform, and based on Windows Azure SQL Database, SQL Server, and SQL Server Reporting Services (SSRS) technologies. Unlike SSRS, which is a software product that you install and maintain, SQL Reporting is a service that is hosted on hardware in Microsoft datacenters. SQL Reporting takes care of provisioning and maintaining the hardware and software layer, freeing you to concentrate on report design and management. All you need to do is sign up for the service, get an invitation code, and add SQL Reporting to your existing Windows Azure subscription. For more information on SQL Reporting billing model, see Accounts and Billing in Windows Azure SQL Reporting.

In this release of SQL Reporting, after you add Reporting to your existing Windows Azure subscription, you can do the following:

Publish reports from report server projects from SQL Server 2008 R2 Business Intelligence Development Studio (BIDS).
Write Visual Studio applications that include a ReportViewer control that points to reports hosted on SQL Reporting report servers. Applications can be developed for on-premise or Windows Azure platforms.
View published reports in a browser by supplying the credentials given to you by the report server administrator.
Manage report server contents programmatically through SOAP calls to the report server Web service management endpoint.

Getting Started

Introducing	Introducing Windows Azure SQL Reporting SQL Reporting FAQ
Getting Started	Getting Started with Windows Azure SQL Reporting Signing up: Getting Started Guide for Windows Azure SQL Reporting Understanding report data for DBAs: Getting Started Guide for Database Administrators Writing reports: Getting Started Guide for Report Authors Writing applications with embedded reporting: Getting Started Guide for Application Developers Viewing reports: Getting Started Guide for Report Readers Install Samples. Video Introduction to SQL Reporting (PDC 2010)
Guidelines and Limitations	In Guidelines and Limitations: Feature Comparison of SQL Reporting and SSRS High Level Detail Level Unsupported APIs
Tools	Tool Compatibility
Security	Credentials Summary for SQL Reporting Security in Guidelines and Limitations Overview of Security in Windows Azure SQL Database Security Guidelines for Windows Azure SQL Database Security Resources for Windows Azure Securing your connection string and credentials in your Windows Azure application: Securing Your Connection String in Windows Azure: Part 1 Securing Your Connection String in Windows Azure: Part 2 Securing Your Connection String in Windows Azure: Part 3 Securing Your Connection String in Windows Azure: Part 4
Troubleshooting	Troubleshooting SQL Reporting

Return to Top

How To

Development

How to: Use ReportViewer in a Web Site Hosted in Windows Azure

Return to Top

Training

Report servers and reports	SQL Reporting provides support for reports similar to SQL Server 2008 R2 Reporting Services. For differences, review Guidelines and Limitations. To learn more about SSRS, see the SQL Server Reporting Services developer portal on MSDN.
Developing ReportViewer applications	Windows Azure supports Windows Forms and ASP.NET applications that use a ReportViewer control to embed reporting. For more information, see: Samples Microsoft Reports Samples Environment for Visual Studio 2010 ReportViewer Controls

Return to Top

Samples

Sample	Description
Prerequisites	Before You Begin in Getting Started with Windows Azure SQL Reporting Tool Compatibility in Guidelines and Limitations
Reports samples: SQLAzureReportingPreview ReportSamples	Report data source: AnySQLAzureDatabase.rds Reports: Column_Chart_Sales.rdl, Product_Sales_KPI.rdl, Store_Sales_in_New_York.rdl Report data source: SQLAzure_AdventureWorksLT.rds Reports: Product_Catalog_AWLTAz_2008R2.rdl, Product_Line_Sales_AWLTAz_2008R2.rdl
Windows Azure SQL Reporting ReportViewer-SOAP API usage sample	ReportViewerRemoteMode, displays reports published to a SQL Reporting report server URL that you provide. SOAPManagement, shows how to call ListChildren, from the Web service proxy in ReportingService2010 endpoint, to display a list of published reports. For more information, see Windows Azure SQL Reporting ReportViewer-SOAP API usage sample.
Windows Azure SQL Reporting Admin sample: SQLReportingAdmin Sample	The SQLReportingAdmin sample for Windows Azure SQL Reporting demonstrates the usage of SQL Reporting APIs, and manages (add/update/delete) permissions of SQL Reporting users. For more information, see Windows Azure SQL Reporting Admin Sample.
More information	SQL Reporting Samples

Return to Top

Feedback and Community

Technical Support	Support
Forums	For Windows Azure: Windows Azure Platform forums For Windows Azure SQL Database: Windows Azure SQL Database forum For report authoring: SQL Server Reporting Services forum For ReportViewer: Visual Studio Report Controls forum
Provide feedback	Feedback for SQL Reporting
Blogs	Windows Azure SQL Database Team Blog
SQL Database Announcements	Windows Azure SQL Database Development Center on MSDN
Windows Azure Announcements	Windows Azure Development Center on MSDN
SQL Database account portal	Windows Azure and Windows Azure SQL Database Platform Management Portal