Hello,
I am developing a FetchXML based SSRS report for Quote in CRM to run from Quote entity. I know I can use single dataset but my requirement is very complex and mandate to use multiple datasets.
For example: I am trying to generate SSRS report using two fetchXML datasets show below. First dataset creates a Parameter and I am trying to use that parameter to filter QuoteProduct records. But I am getting error when I preview report shown below. Am I missing something here? Your help is highly appreciated.
QuoteDS:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="quote" enableprefiltering="1" >
<attribute name="name" />
<attribute name="statecode" />
<attribute name="totalamount" />
<attribute name="quotenumber" />
<attribute name="ownerid" />
<attribute name="new_contactid" />
<attribute name="new_accountid" />
<attribute name="new_pipelinephase" />
<attribute name="new_estimatedclosedate" />
<attribute name="quoteid" />
<attribute name="new_ponumber" />
<order attribute="quotenumber" descending="false" />
</entity>
</fetch>
QuoteProductDS:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="quotedetail">
<attribute name="productid" />
<attribute name="extendedamount" />
<attribute name="new_startdate" />
<attribute name="new_productid" />
<attribute name="new_enddate" />
<attribute name="new_frequencyofbilling" />
<attribute name="uomid" />
<attribute name="quantity" />
<attribute name="priceperunit" />
<attribute name="new_custombilling" />
<attribute name="quoteid" />
<order attribute="new_productid" descending="false" />
<order attribute="productid" descending="false" />
<filter type="and">
<condition attribute="quoteid" value="@quote" operator="eq"/>
</filter>
</entity>
</fetch>
SSRS Data Tools:
Error:
*This post is locked for comments
I have the same question (0)
