Search code examples
reporting-servicesdynamics-crmssrs-2008dynamics-365fetchxml

Filter Dataset Result based on Parameter Value

I am working on Microsoft Dynamics Reporting service. My requirement is to show records which is dated 3 years or earlier from a given date. The parameter I have is a date selection field. What I am trying to achieve is get records based on my condition from the date I have selected on the parameter.

To filter data based on the current date, I can use:

<condition attribute="modifiedon" operator="olderthan-x-months" value="36" />

But, to get the data filtered based on the parameter value is what I can't figure out.

Can someone help me with this?

Solution

  • We can add a dynamic date for the report. We can add another date which will have a custom code to have a date 3 years prior to the input date or current date. This date can be referenced to the FetchXML query to filter the records.