Thursday 13 August 2015

Enable Pre Filter in SSRS Report for Dynamics CRM in FetchXML

Simply add enableprefiltering="1" attribute to entity node in FetchXML

For example:

    
        
        
        
        
    


It will create a parameter field for entity ID automatically in format CRM_
We can also set the name for the parameter field in FetchXML using prefilterparametername=""
If the report is uploaded to CRM solution without prefiltering enabled, we need to delete that report in the solution and upload prefiltering enabled report again.

No comments:

Post a Comment