See the Problem Solver of the Month for DecemberCongratulations to Ievgen Miroshnikov for be selected in a random drawing on Jan. 2 for in our monthly Dynamics 365 Community Problem Solver Sweepstakes.
Read aboug Ievgen | Learn how to enter
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
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
Hello CRM365 MVPs,
I have created a FetchXMl report using BIDS and Visual Studio 2015.
Due to the scope of the report, 15 entities have been used to pull all the required information.
Owing to the limitation in Linked Entities, I have created two FetchXML, grouping together all the related entities. The two main entities are Opportunites and Quotes.
The report works perfectly fine when all the linked entities contain at least one record. From the CRM forms, there are fields from a particular entity which are not mandatory field.
For instance, in the Competitors entity, the user may or may not enter a value for the Name field. Also, in the Payment Terms, the fields are not mandatory so the user may leave it blank.
When there is no record in any of the Competitors or Payment Terms entity, I get the error stated in the subject line.
My question is: Is it possible to trap the error in the report, like if there is no record id found for any of the linked entities then the error will be bypassed and the report will still display?
The report has already been deployed to Production and most users are already using it and they get the error when they did not enter any value for the Competitor.
I would recommend you also post this theme at SQL Server community.
It looks like the error is with the parameters in the report. Do you have any custom parameters, or are they just the parameters used for pre-filtering ?
If you've created custom parameters, then you should be able to resolve this by one or more of:
Making the parameters not required
Specifying a default value
Making sure any expression that uses the parameter can cope with null values
Pre-filtering parameters should have a default value, so shouldn't cause this error
You say you have 2 fetchXml queries. Does one data set reference the other ? If so, your problem may be in how you combine the data sets, and not handling nulls correctly
Thank you very much. I have posted this at SQL Server Community
Hello Partner David,
Thanks you very much!
The parameter used was just for pre-filtering as the report is run on a selected opportunity record, and the report is dynamically reading the opportunity record id through JS code.
And yes, I have used 2 fetchxml queries, the first one has Opportunity as the principal entity and the other one has Quote as principal entity.
The report works perfectly fine when there are records in all entities linked to either Opportunity or Quote. The link-type I used for all entities was "outer". It is my assumption that by using the "outer" link, the base record would still be retrieved despite other linked entities having null values. But this is not the case.
Is there anything that can be done through the report itself in order to handle null values in the linked entities.
Business Applications communities