• This looks promising. Looking forward for more.

    What are your plans ?

    Visual Studio 2008 or the SSRS report builder ?

    Will you use SQL Server datasets or use FetchXML ? FetchXML did not impress me too much last year when I found out it could not support what I could do easily in T-SQL:

    SELECT AccountIdName, SUM(TotalAmount_Base) AS AccountTotal FROM Invoice GROUP BY AccoountIdName

    A thing to note: caution is required using T-SQL and directly refering to tables instead of views. In its wisdom, for CRM 2013, MS dumped the idea of creating ...ExtensionBase tables when new fields are created with the CRM environment. All custom fields are now added to the ...Base tables. Which means migrating my T-SQL-based reports from CRM 2011 to CRM 2013 I will have to rewrite my T-SQL so stop looking for ...ExtensionBase tables.

    I did not like too much using the Views automatically constructed by the CRM environment, each view returning typically 100 columns when I select only a half-dozen. Not familiar enough with the inner workings of SQL Server to determine whether or not the remaining 94 columns still end-up as dead weight overhead even if not selected.