You’re offline. This is a read only version of the page.
1,075
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
Hi,
what i means is this.
No. I am providing parameter @quote as shown below image:
Hi,
based on the picture, a wrong format of parameter is provide. Look at the Error picture and the parameter. It seems you are providing fetchxml value, instead of a guid.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (