Windows Azure SQL Reporting ReportViewer-SOAP API usage sample

Technologies

Windows Azure, Windows Azure SQL Reporting, Windows Azure SQL Database

Topics

Windows Azure SQL Reporting

Platforms

Cloud

Requirements

Primary Language

en-US

Last Updated

8/28/2012

License

Custom

View this sample online

Introduction

These sample projects demonstrate how to embed a Microsoft ReportViewer control that points to reports hosted on SQL Reporting report servers and how to use SQL Reporting SOAP APIs in your Windows Azure Web application.

Prerequisites

You must install the Windows Azure Software Development Kit (SDK) 1.3 or later to run this sample. You can get the latest version at Windows Azure SDK Downloads.
An active account for SQL Reporting with the server name, username, and password. See http://go.microsoft.com/fwlink/?LinkID=204134.
Reports hosted in your SQL Reportinginstance. See the related sample at http://archive.msdn.microsoft.com/SQLAzureReports.

Building the Sample

Use administrator privileges to launch either Microsoft Visual Studio 2010 or Microsoft Visual Web Developer Express 2010. To do this, in Start | All Programs | Microsoft Visual Studio 2010, right-click the Microsoft Visual Studio 2010 (or Microsoft Visual Web Developer Express 2010) and choose Run as Administrator. If the User Account Control dialog appears, clickContinue. The Windows Azure compute emulator requires that Visual Studio be launched with administrator privileges. For more information about Windows Azure Compute Emulator and other SDK tools, see Overview of the Windows Azure SDK Tools.
In Visual Studio, on the File menu, click Open, and then browse to folder where you extracted the samples, then browse to the SQLReportingAdminSample folder. Open SQLReportingAdminSample.sln file.
In Solution Explorer, under ManagerPermission project, open Web.Config.
If Solution Explorer is not already visible, click Solution Explorer on the View menu.
Open the Web.Config from ReportViewerRemoteMode and SOAPManagement projects. Update the appSettings section with the values similar to the ones shown below:

Edit|Remove

<appSettings>
    <!-- Specify the server name of the SQL Reporting instance. This is found in the URL: https://<RSSERVER_NAME>/ReportServer. -->
    <add key="RSSERVER_NAME" value="instance_name.account_name.windowsazure.mscds.com" />
    <!-- Specify the username used to access the SQL Reporting instance. -->
    <add key="RSUSERNAME" value="username"/>
    <!-- Specify the password used to access the SQL Reporting instance. -->
    <add key="RSPASSWORD" value="password"/>
    <!-- Specify the path of the report hosted in SQL Reporting. This used by the ReportViewer Server Mode project. -->
    <add key="RSREPORT_PATH" value="/dir/subdir/report_name" />
  </appSettings>

<appSettings> 
    <!-- Specify the server name of the SQL Reporting instance. This is found in the URL: https://<RSSERVER_NAME>/ReportServer. --> 
    <add key="RSSERVER_NAME" value="instance_name.account_name.windowsazure.mscds.com" /> 
    <!-- Specify the username used to access the SQL Reporting instance. --> 
    <add key="RSUSERNAME" value="username"/> 
    <!-- Specify the password used to access the SQL Reporting instance. --> 
    <add key="RSPASSWORD" value="password"/> 
    <!-- Specify the path of the report hosted in SQL Reporting. This used by the ReportViewer Server Mode project. --> 
    <add key="RSREPORT_PATH" value="/dir/subdir/report_name" /> 
  </appSettings>

In the above example, consider replacing the values for RSSERVER_NAME, RSUSERNAME, RSPASSWORD and RSREPORT_PATH with appropriate values from your SQL Reporting report server.
Press F6 to build the application from Visual Studio. Press F5 to debug the application. Set one of the projects, ReportViewerRemoteMode or SOAPManagement, as Start UP to see the corresponding results.

Description

SQL Reporting Reports with ReportViewer control: The ReportViewer controls manage the authentication cookie, making your tasks easier. To display reports deployed to a SQL Reporting report server in the ReportViewer controls, you supply the report server URL and the report path as you would for any server report, and implement the IReportServerCredentials interface and use it in ServerReport.ReportServerCredentials. This sample demonstrates the usage of ReportViewer control with SQL Reporting reports.
SQL Reporting SOAP APIs: The SQL Reporting SOAP API provides several Web service endpoints for developing custom reporting solutions. The management functionality is exposed through the ReportService2005 Namespace and ReportService2010 Namespace endpoints. For the list of unsupported SOAP APIs in SQL Reporting, see Guidelines and Limitations for Windows Azure SQL Reporting. This sample demonstrates the usage of SOAP APIs to integrate SQL Reporting with .NET applications.
In the current implementation, the login credentials are stored in the configuration. It is recommended to use a mechanism to encrypt and protect the user credentials while trying to access the Windows Azure SQL Reporting portal.

Source Code Files

"SOAP Management demonstrates how to connect to the SOAP endpoint of an SQL Reporting instance and perform management tasks.
"ReportViewer Remote Mode" demonstrates how to host a SQL Reporting report in ReportViewer, running in Windows Azure.

Windows Azure SQL Reporting ReportViewer-SOAP API usage sample

Introduction

Prerequisites

Building the Sample

Source Code Files

More Information