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

2 comments:

  1. Hi

    I get the below error.

    There are some clauses that have errors in them please remove them and try again.

    I have removed the default filters in the report.

    Any idea?

    ReplyDelete
  2. Hi Varun I Ve get the same error. Have you fixed it

    ReplyDelete