Windows Azure SQL Reporting Samples

Windows Azure SQL Reporting Samples

Sample reports and a Windows Azure web role with a ReportViewer control that points to the sample reports, is available for download for Windows Azure SQL Reporting.



In this article:


Download Samples

Download samples from Code Gallery on MSDN:


Prerequisites

The samples have the following prerequisites:

Return to Top


Sample Data for Reports

Reports that use the SQLAzure_AdventureWorksLT data source require access to the following database, which must be installed on a Windows Azure subscription that you have access to:

Name Link
Download AdventureWorksLTAZ2008R2
database
AdventureWorks Community Samples Databases for Windows Azure SQL Database (December CTP)
Comparison between Windows Azure SQL Database version and SQL Server version http://sqlblog.com/blogs/john_paul_cook/archive/2010/09/12/sql-azure-differences.aspx
Video

Loading AdventureWorks into Windows Azure SQL Database

 Also, see Getting Started Guide for Database Administrators (Windows Azure SQL Reporting).

Return to Top


Report Samples

Sample Data source Description
SQLAzureReportingPreviewReportSamples README.txt Requirements and notes
  AnySQLAzureDatabase.rds
Column_Chart_Sales.rdl
Product_Sales_KPI.rdl
Store_Sales_in_New_York.rdl
  SQLAzure_AdventureWorksLT.rds
Product_Catalog_AWLTAz_2008R2.rdl
Product_Line_Sales_AWLTAz_2008R2.rdl

 Also, see Getting Started Guide for Report Authors (Windows Azure SQL Reporting).

Return to Top


SQL Reporting application samples for Windows Azure

Sample Name Description
Windows Azure SQL Reporting ReportViewer-SOAP API usage sample README.txt Requirements and notes
  ReportViewerRemoteMode
Displays reports published to a SQL Reporting report server URL that you provide.
  SOAPManagement Calls the report server Web service proxy ListChildren in the ReportingService2010 endpoint, to display a list of reports published on the SQL Reporting report server.
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.

 Also, see Getting Started Guide for Application Developers (Windows Azure SQL Reporting) and How to: Use ReportViewer in a Web Site Hosted in Windows Azure.

Return to Top


See Also

SQL Reporting Overview
Windows Azure SQL Database Overview
Windows Azure Survival Guide

Sort by: Published Date | Most Recent | Most Useful
Comments
  • When I try to install the Azure SQL AdventureWorks samples (LT and DW) I get some errors, mainly about connection errors in DW and some type errors in LT ¿what could be the problem?

  • Only AdventureWorksLT for SQL Azure database is used in these samples, and they were tested in December 2010. The AdventureWorksDW2008R2 database was not used.

    It might be that you are running into SQL Azure database limitations or issues introduced by newer releases. Try posting your question on the SQL Azure forums: social.msdn.microsoft.com/.../threads. For best responses, include details about the specific errors that you are getting about types.

  • See my PASS Summit: SQL Azure Reporting Services Preview and Management Portal Walkthrough - Part 1 and Part 2 posts (oakleafblog.blogspot.com/.../pass-summit-sql-azure-reporting.html) for a fully illustrated walkthrough of creating and testing a sample SQL Azure database and report.

    Cheers,

  • See my PASS Summit: SQL Azure Reporting Services Preview and Management Portal Walkthrough - Part 1 and Part 2 posts (oakleafblog.blogspot.com/.../pass-summit-sql-azure-reporting.html) for a fully illustrated walkthrough of creating and testing a sample SQL Azure database and report.

    Cheers,

  • Nice article

Page 1 of 1 (5 items)