Home > SQL Azure, SQL Azure Reporting Services > Creating Reports using SQL Azure Data for SQL Azure Reporting services

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

image

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

clip_image002

Click “Next” on Report Wizard to proceed

clip_image004

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

clip_image006

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

clip_image007

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

clip_image008

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

clip_image009

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

clip_image011

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

clip_image013

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

clip_image015

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

clip_image017

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

clip_image019

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

clip_image021

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

clip_image023

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

clip_image025

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

clip_image027

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

clip_image029

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

Advertisements
  1. No comments yet.
  1. June 19, 2011 at 6:45 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: