Have you been looking for a way to retrieve and view query results faster? Pre-filter the data!
Data pre-filtering in Microsoft Dynamics CRM reports lets you retrieve and display result sets quickly, makes reports context-sensitive, and allows reports to be filtered using the Advanced Find feature. Data pre-filtering complements data filtering supported by Microsoft SQL Server Reporting Services, which limits the data returned by reports. There are two ways that you can enable data pre-filtering:
For detailed information about enabling data pre-filtering on reports, including query examples and the limitations of using automatic data pre-filtering with complex queries, see Using Filters in a Report .
Great post - Looking for more which stir the passion for SSRS 2008 development in more of the developers hearts :) How can custom reporting be painless?