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 these instructions.
Wiki  >  TechNet Articles  >  Windows Azure SQL Reporting Samples

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

, , , , , , , [Edit tags]
Leave a Comment
  • Please add 7 and 7 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 3 Jul 2012 10:19 AM

    patmas57 edited Revision 9. Comment: Branding update

  • 4 Mar 2011 4:07 PM

    Mary Lingel MSFT edited Revision 3. Comment: fixed typo

  • 1 Feb 2011 4:15 PM

    Mary Lingel MSFT edited Revision 2. Comment: Updated links and formatting

  • 1 Feb 2011 2:24 PM

    Mary Lingel MSFT edited Revision 1. Comment: fixed format

  • 1 Feb 2011 2:23 PM

    Mary Lingel MSFT edited Original. Comment: Added links to download sites on code gallery

Page 1 of 1 (5 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 1 Feb 2013 3:50 AM

    Nice article

  • Posted by
    on 3 Jul 2012 10:19 AM

    patmas57 edited Revision 9. Comment: Branding update

  • Posted by
    on 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,

  • Posted by
    on 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,

  • Posted by
    on 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.

  • Posted by
    on 4 Mar 2011 4:07 PM

    Mary Lingel MSFT edited Revision 3. Comment: fixed typo

  • Posted by
    on 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?

  • Posted by
    on 1 Feb 2011 4:15 PM

    Mary Lingel MSFT edited Revision 2. Comment: Updated links and formatting

  • Posted by
    on 1 Feb 2011 2:24 PM

    Mary Lingel MSFT edited Revision 1. Comment: fixed format

  • Posted by
    on 1 Feb 2011 2:23 PM

    Mary Lingel MSFT edited Original. Comment: Added links to download sites on code gallery

Page 1 of 1 (10 items)