none
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.
    Sunday, March 04, 2012 8:55 PM

Answers

  • 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

    Monday, March 05, 2012 2:35 AM
  • 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.

    Monday, March 05, 2012 8:23 AM

All replies

  • 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 )




    Sunday, March 04, 2012 10:27 PM
  • 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.
    Sunday, March 04, 2012 10:48 PM
  • 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

    Monday, March 05, 2012 2:35 AM
  • 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 )

    Monday, March 05, 2012 4:43 AM
  • 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.

    Monday, March 05, 2012 8:23 AM