Custom SSRS Reports parameters issue Dynamics 365 On Premise

(0) Share

Report

Posted on by Sreejith.Vijayan

Hello.

We are currently in the process of upgrading CRM 2016 on premise to Dynamics 365 on premise.

Everything is going well, except one major issue that we are facing with some of the custom ssrs reports.

For all the reports that use a parameter from a sql query, the parameters are not being fetched or we are getting an error "The expected parameter has not been supplied for the report"

eg : we have a report where the parameter is obtained from the below sql query

SELECT
CRMAF_Filteredlicence.licenceid
FROM filteredlicence as CRMAF_Filteredlicence

However , the report does not work and we are getting the above error.

Rest all other reports, where there are no parameters or reports running on current record (pre filtered) are working fine.

Kindly requesting some valuable assistance that would help us resolve this issue.

Thanks.

All responses (2)

Answers (0)

Sreejith.Vijayan 25 on at

Like (0)

Report

RE: Custom SSRS Reports parameters issue Dynamics 365 On Premise

This is just an example that I provided. The actual entity name is different.

We were analyzing this issue and noticed that all the reports are working for the old data migrated from crm 2016. The issue is happening only for the new records that we created in our D365 Dev instance
Suggested answer

Alex Fun Wei Jie 33,626 on at

Like (0)

Report

RE: Custom SSRS Reports parameters issue Dynamics 365 On Premise

Hi,

are you sure in your environment there is an entity called Licence "filteredlicence" ?