How to build an SQL Server Reporting Services report with SQL Azure using Visual Studio 2010?

Question

How do you build an SQL Server RSR  to use SQL Azure using Visual Studio 2010? Read the related topics still confused.

Answer 1

Do you mean SSRS report with SQL Azure as the Data source?

OR

Do you mean: How to deploy reports on SQL Azure reporting services (with SQL Azure as data source)?

[For second case: I would point you to an article that i wrote; please click here - it goes through the process in step by step fashion. I believe that would be of help.]

---

Paras Doshi (Blog: ParasDoshi.com | Twitter: @Paras_Doshi )

Answer 2

SSRS report with SQL Azure as the Data source. I have a client clickounce program and I want to provide the client user the ability to print reports using the AZURE data source. My reports are tables or graphic plots.

Answer 3

Hi Mike,

Reporting Services supports SQL Azure as datasource, to include data from SQL Azure Database in your report, you must have a dataset that is based on a report data source of type SQL Azure. This built-in data source type is based on the SQL Azure data extension. Use this data source type to connect to and retrieve data from SQL Azure Database.

For more information about SQL Azure Connection Type (SSRS), please see: http://msdn.microsoft.com/en-us/library/ff519560.aspx 

Thanks,

---

Challen Fu

TechNet Community Support

Answer 4

As challen Fu mentioned, SSRS has support for connecting to SQL Azure Database.

And to make sure that clients could access the SQL Azure, you may have to configure SQL Azure firewall accordingly.

---

Paras Doshi (Blog: ParasDoshi.com | Twitter: @Paras_Doshi )

Answer 5

Business Intelligence Development Studio (or BIDS) ships with the client components of SQL Server.  It is a separate type of Visual Studio project that can be used to create Reporting Services report.  There is no version of BIDS that works with Visual Studio 2010 - it only works with Visual Studio 2008. 

You don't need to have a separate installation of Visual Studio 2008.  It will be installed when you install the client components of SQL Server.