For everyone playing with SQL Azure, what are you using for reporting? Do the Visual Studio reports connect seamlessly? What about reporting services?
+1
A:
Reporting Services will still connect and work as normal, BUT there is no SSRS service on the Azure platform. So it means that you will connect (most likely through ADO) from a different data centre (either your own or hosted SSRS) to SQL Azure, meaning that potentially a lot (too much) data has to come down the wire.
SSRS and SSAS for Azure are not officially on the Azure roadmap yet
Simon Munro
2009-12-18 17:30:08
A:
We have at least one customer using ActiveReports with SQL Azure. Just connect with the normal SQL provider for ADO.NET or you can use unbound mode with ActiveReports.
scott
2009-12-19 05:26:18
A:
Hi,
My recommendation for a very fast, full featured reporting solution is Izenda Reports. It runs on SQL Azure and is designed for OEM integration with other Azure apps. It streams data from an Azure db or from an off-site db. Just give it a connection string and go.
dbeng
2010-02-23 17:08:10
A:
SQL Azure Reporting was just announced at PDC10 (Oct 28, 2010) and a CTP should be available by the end of the year: http://blogs.msdn.com/b/sqlazure/archive/2010/10/28/10081543.aspx
Talbott Crowell
2010-10-29 14:58:18