Publishing Reports to SQL Azure Reporting Services

In the previous post we saw How to provision and configure SQL Azure Reporting Services account and How to create reports using SQL Azure data for SQL Azure Reporting Services

In this post we will see How to deploy or publish the report to SQL Azure Reporting Services

Open the Report project in SQL Server 2008 R2 Business Intelligence Studio and Right click on Project Name in Solution Explorer


In Project Properties, Specify the “Target Report Folder” and the “Target Server URL”, Target Server URL is the url you provisioned in SQL Azure Reporting Services account and make sure Target Server version is set to “SQL Server 2008 R2”. Click Apply and Ok to save the changes


Right the Project Name again on Solution explorer and click on “Deploy” to publish the report to SQL Azure Reporting Services


For connecting to SQL Azure Reporting Service, it will prompt for user name and password, Please specify the SQL Azure Reporting Services user name and password and click “Ok” to proceed


In Project Build Output, you can verify the status of the Deployment


Once successfully deployed, open Internet Explorer or any compatible browser and open

Replace SERVERNAME with your SQL Azure Reporting Services server name, enter user name and password and click “Sign In”


After successful login, you will be able to see the list of Report folders, click on the target folder we deployed


Now you will be able to see the list of reports available in the target folder, click on the Target Report we deployed to test it.


Since I haven’t saved the SQL Azure database user name and password, it will prompt for the credentials to connect to database, after specifying required credentials, click “View Report”


The Report will be successfully generated based on availability of data. You can export this Report or Print the report.


Now we have successfully deployed the report to SQL Azure Reporting services and preview the reports from SQL Azure Reporting Service Web

Hope you all find this information useful !!!


Creating Reports using SQL Azure Data for SQL Azure Reporting services

In the previous post we saw How to provision and configure SQL Azure Reporting Services account.

In this article, we will see to How to create a report for SQL Azure Reporting Services using data from SQL Azure Database

Click on Start –> All Programs –> Microsoft SQL Server 2008 R2 and open SQL Server Business Intelligence Development Studio


Click on File –> New Project and select Report Server Project Wizard


Click “Next” on Report Wizard to proceed


Specify the name of the Data source and select Type as “Microsoft SQL Azure” and then click “Edit” to define connection string


Specify the name of the SQL Azure database server, specify username (Please enter username@servername) and then password and then Select the database .


Click “Advanced” and specify Application Name and set Encrypt to True, click “Ok” to proceed


Click on Test Connection to make sure the connection works and then click “Ok” to proceed


After connection test is suceeded, click “ok” to proceed and then the defined connection string will be displayed, you can manually verify this as well. Click “Next” to proceed


In Query Designer, you can select the tables and fields you want to display in report, You can also click on “Edit as Text”, if you want to use the query which you already created


After defining the query, click “Run Query” to test and make sure that they query works fine and returns data. After the query runs successfully, click “Ok” to proceed


You can review the query in this screen, if you want to make any further changes, click on “Query Builder…” button to go to query designer window, or else, click “Next” to proceed


Select the report type as “Tabular”, based on your requirement, you can change your report type. Once selected, click “Next” to proceed


Select the Available Fields and move to Displayed Fields, Group Fields and Details based on your report requirement and click “Next” to proceed


Select Report Table Layout and specify whether to display Subtotal or enable Drilldown and then click “Next” to proceed


Select your preferred Report Style and click “Next” to proceed


Enter the Report Name and then click “Finish” to complete


Once the report is generated and saved, it will be previewed automatically


Now you have successfully created a SSRS Report using SQL Azure data for SQL Azure Reporting services.

In the next post, we will see how to deploy this report to SQL Azure Reporting Services and preview the reports  in SQL Azure Reporting Web

Configuring SQL Azure Reporting Services

Login to

Click on Reporting tab on lower left hand corner


Click on “Provision” button


Click Agree to Terms of use statement and then click Next


Select the Windows Azure Subscription account and then click “Next”


Enter the Invitation Code and specify the password and click “Finish”


Now you have successfully configured your SQL Azure Reporting Service account


You can publish your reports from BIDS to the Web Service URL using the Username provided and Password you have setup.

Good Luck !!!

%d bloggers like this: