Home > SQL Azure, SQL Azure Reporting Services > Publishing Reports to SQL Azure Reporting Services

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

clip_image001

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

clip_image003

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

clip_image004

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

clip_image005

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

clip_image007

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

https://SERVERNAME.ctp.reporting.database.windows.net/ReportServer

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

clip_image009

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

clip_image011

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.

clip_image013

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”

clip_image015

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

clip_image017

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 !!!

Advertisements
  1. December 15, 2011 at 9:16 am

    Great post,

    Do you know how to save the SQL Azure database user name and password, so it will not prompt for the credentials to connect to database?

    Thanks

    Like

  1. No trackbacks yet.

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: