I have an SSRS report built in Visual Studio 2019 for Dynamics 365 that has a single subreport in it. The subreport has passed only 1 parameter - AccountID. In the subreport I have a function expression on one of the fields that checks date of now vs. date of the record and highlights that field if the date of the record is within a year of today. When I run the subreport by itself, using the AccountID in question, it works just fine in Dynamics and the field in question doesn't highlight as it doesn't fit the expression which is good. If I run the main report, that field highlights even though it doesn't fit the expression.
Is there something about functions within subreports of SSRS reports being called within Dynamics 365 that it doesn't like the functions?
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.