Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Hi there All.I want to create a report that produce results based on the records that end-user have selected. This report is on my custom entity that has relation with sales order, sales order as primary entity and my custom entity as related entity.Previously I have created records based on the parameters, but the end-user entered the parameters in the report.Anyways, For this , want to pass selected sales order Id as parameter to the report, Should I use Filtered view of every entity? I have created a parameter named @CRM_SalesOrderId.
with this query :
FROM FilteredSalesOrder AS CRMAF_FilteredSalesOrderId;
I have set the Sales Order Id as default value and available value of the parameter.And this is my main Query :
SELECT Filteredbmsd_receipt.bmsd_totalamount_base, FilteredSalesOrder.salesorderid, FilteredSalesOrder.new_order_code, FilteredSalesOrder.name AS salesordername,
methodreceiptstring.AttributeValue AS methodreceiptattributevalue, methodreceiptstring.AttributeValue AS methodreceiptattributevalue,
methodreceiptstring.AttributeName AS methodreceiptattributename, methodreceiptstring.Value AS methodreceiptvalue,
receiptstatusstring.AttributeValue AS receiptstatusstringvalue, receiptstatusstring.AttributeValue AS receiptstatusstringattributevalue,
receiptstatusstring.AttributeName AS receiptstatusstringname, receiptstatusstring.Value
FROM Filteredbmsd_receipt INNER JOIN
FilteredStringMap AS methodreceiptstring ON methodreceiptstring.AttributeValue = Filteredbmsd_receipt.bmsd_receiptmethod AND
methodreceiptstring.AttributeValue = 2 AND methodreceiptstring.AttributeName = 'bmsd_ReceiptMethod' AND methodreceiptstring.LangId = 1088 INNER JOIN
FilteredStringMap AS receiptstatusstring ON receiptstatusstring.AttributeValue = Filteredbmsd_receipt.bmsd_receiptstatus AND
receiptstatusstring.AttributeName = 'bmsd_receiptstatus' AND receiptstatusstring.LangId = 1088
INNER JOIN FilteredSalesOrder ON ( FilteredSalesOrder.salesorderid=Filteredbmsd_receipt.bmsd_orderid)
where Filteredbmsd_receipt.bmsd_orderid in (@CRM_SalesOrderId)
ORDER BY FilteredSalesOrder.new_order_code, methodreceiptvalue
I have created This as my Main Query, and that one as my parameter query.Did I do right?Now when enter the main query in the main data set and click Referesh Fields It gives me :An item with the same key has already been added.
I removed my created Parameter (@CRM_SalesOrderId) to allow the query to created the parameter, But no success. How can I solve this?And after created that I must select Forms for related record types;Lists for related record types;Reports areain display field of the report, right?
In your query you have " methodreceiptstring.AttributeValue AS methodreceiptattributevalue" two times, that's why you are getting this error "An item with same key has already been added.
Either you need to remove one or need to change name of attribute as "methodreceiptstring.AttributeValue AS methodreceiptattributevalue1"
hope this will help..
Business Applications communities