Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Handle Fetch XML resul...

Handle Fetch XML result data in CRM Report

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all.
I have one main dataset by 1 entity and use prefiltering on it. Also I have 3 "child" datasets which take ids of needed records from main dataset through Report Parameter. So, this parameter allows multiple values and can not allow null. So in case when user check specific filters for fetch xml query which don't return any values, report throw error like this "the expected parameter has not been supplied for this report".
Is it possible to return some default value from fetch xml query in case we don't have any records by specific filters? Or maybe you could propose some other possible solutions. Please fill free to ask additional information which needed.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

innovativeaj 175 on at

Like (0)

Report

RE: Handle Fetch XML result data in CRM Report

Hi Rostyslav, you can add a Default Value in your Report Parameter pProperties. Here's a screenshot that might help