Sample 19 - RTD Reports

This example shows how to create refreshable Excel reports based on database data with db.rtd.

The formulas look like

=RTD("db.rtd",,$A$1,"s08.viewSales","SalesPersonCountry","USA","SUM(NetSum)")

where cell C1 contains a connection string like

System.Data.SqlClient;Data Source=mssql.savetodb.com;Initial Catalog=AzureDemo100;Password=Usr_2011#_Xls4168;User ID=sample08_user1