Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 1Discover the latest updates and new features to Dynamics 365 planned April 2021 through September 2021.
Release overview guides and videos Release Plan | Preview 2021 Release Wave 1 Timeline
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All 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