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 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 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
,We have this custom report working perfectly when running in <URL>/Report
But when we run this on the CRM, it gives us an error
Any idea what could be the problem?Anything will be helpful.
Hi Christell,How many paramters you are passing to the report through CRM? I believe you are using pre-filtering in fetchxml.Just check whether parameters are properly being set.Hope this helps.
Is it online or on premise?
How are you calling this report... is it through a custom button using java script.... please share how you are passing the guid of the entity record and the parameters Start Date and End Date?
Thank you for the reply.
It is on premise.
We are calling this report on the Report Entity directly. No custom button.
Menu > Service > Report
We have 2 parameter, Start Date and End Date.
I am not sure if we are using prefiltering in fetch, but I am sure we are using SQL since were on premise.
Are you running the report as shown below or are you opening the record and running the report from there?
How many datasets you are retrieving and how are you passing the guid for that entity? Please share sql query.
If you are running this report for a single record you need to have a parameter guid for the current record and you need to have a custom button for passing the guid as parameter using a java script to the report.
We are running the report on the report entity directly.
We are using shared dataset.
I just find it odd, because we can run the report on the report server but not in the CRM. That is why I'm sure it is not on retrieving the report.
Anything would be helpful.
Can you share the query used to retrieve the shared dataset?
Which entity are you trying to retrieve?
It should work if you are trying to run the report for more than one record.
Apologies for the wrong reply, we use shared data source
Business Applications communities