Showing posts with label sql. Show all posts
Showing posts with label sql. Show all posts

Monday, June 6, 2011

PreFiltering CRM 2011 Reports

Report prefiltering in CRM 2011 narrows the scope of a report, return faster results and can lead to more revelant data.  Instead of just creating a report parameter, report prefiltering uses the Advanced Find fetch queries.  This allows the creation of end user defined queries while still in CRM.

A sample query:
SELECT name, accountnumber
FROM FilteredAccount as CRMAF_Account


For more information click the link below!

Happy Coding!

Dynamics Blog Link:
http://blogs.msdn.com/b/crm/archive/2009/03/06/microsoft-dynamics-crm-pre-filtering-tips.aspx