Resources For IT Professionals
Post an article
Wikis - Page Details
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using the Report Abuse link in the footer.
Wiki  >  TechNet Articles  >  SQL Azure Reporting Samples

SQL Azure Reporting Samples

SQL Azure 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 SQL Azure Reporting Preview.



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 SQL Azure subscription that you have access to:

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

Loading AdventureWorks into SQL Azure

 Also, see Getting Started Guide for Database Administrators (SQL Azure 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 (SQL Azure Reporting).

Return to Top

Embedded Reporting Sample for Windows Azure

Sample Name Description
AzureReportingPreviewCodeSamples README.txt Requirements and notes
  ReportViewerRemoteMode
Displays reports published to a SQL Azure 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 Azure Reporting report server.

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

Return to Top

See Also

SQL Azure Reporting Overview
SQL Azure Overview
Windows Azure Survival Guide
, , , ,
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 26 Feb 2011 3:57 PM

    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?

  • 4 Mar 2011 4:28 PM

    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.

  • 22 Oct 2011 10:14 AM

    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,

  • 22 Oct 2011 10:15 AM

    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,

Page 1 of 1 (4 items)