Prefiltering in Fetch XML SSRS Report RRS feed

  • Question

  • Hi,

    I want to create a picking slip report (list of products)  for a selected order in CRM 2011 in SSRS 2008.  I'm using a fetch XML dataset to get my initial order details and then loading a subreport for that order to list all the products.  It is working with a "hard coded" order but I want the selected order to print.

    Here is my fetch XML:

    <fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0"> 
    <entity name="salesorder"  enableprefiltering="true" prefilterparametername="CRM_salesorder"> 
    <attribute name="customerid"/> 
    <attribute name="salesorderid"/> 
    <attribute name="new_orderno"/>
    <attribute name="ordernumber"/> 
    <order descending="false" attribute="customerid"/> 
    <link-entity name="contact" alias="a_fd53f109387544beb17eab2203f1ae3e" link-type="outer" visible="false" to="customerid" from="contactid"> 
    <attribute name="mobilephone"/> 
    <attribute name="telephone2"/> <attribute name="emailaddress1"/> <attribute name="telephone1"/> 
    <link-entity name="new_event" alias="a_2f4b62606f7ae2118329000c29bdf7d8" link-type="outer" visible="false" to="new_event" from="new_eventid"> 
    <attribute name="new_venue"/> 
    <attribute name="new_numberofguests"/> 
    <attribute name="new_eventstartdate"/> 
    <attribute name="new_eventenddate"/> <attribute name="new_city"/> 
    <attribute name="new_suburb"/> 
    <attribute name="new_location"/> </link-entity></entity></fetch>

    How can add the CRM_salesorder parameter in my fetch xml dataset query to only show that selected record?  



    Wednesday, April 17, 2013 7:31 AM


  • Hi,

    As far as  i know,you have add enableprefiltering="true" in your first line of your query

    Sindu M

    Wednesday, April 17, 2013 7:44 AM

All replies