Posts

Showing posts from March, 2017

VS Shortcut for Data View Pane on SSRS Report

To open the Data View pane for an SSRS report do the following. -Open Report -Click on the Report Canvas -Use the following keyboard shortcut Ctrl + Alt + D

CRM SSRS FetchXml PreFiltering Tips

I don't do custom SSRS to often but when I do I consonantly have issues pre-filtering FetchXML in SSRS reports.  The items below are what I have found to be the total set of requirements to make sure it works. Example:  Let's say we have an entity called 'new_house'.  Below is the FetchXML statement I would use in the data set. <fetch mapping="logical" version="1.0"> <entity name="new_hosue" enableprefiltering="true" prefilterparametername="CRM_Filterednew_house"> <all-attributes/> </fetch> Here are the steps i usually take to create this fetch. -Open the query designer and paste in the fetch without the enableprefiltering and prefilterparametername attribute. <fetch mapping="logical" version="1.0"> <entity name="new_hosue" > <all-attributes/> </fetch> -Next add the enableprefiltering="true" attribute then close