Get year for parameter using SSRS with fetchxml query

Question

Hi

I am writing a SSRS report using fetchxml as I'm connecting to D365.

I need to have a parameter of year (will hopefully do a number of years as dropdowns).

Does anyone know how I filter on this for fetchxml? I need to relate it to the created on field

Thanks
Lee

Answer 1

Hi @Lee Chamberlain ,

Not familiar with fetchxml query so I did some online research for you.

Here is the link for your reference:

https://community.dynamics.com/365/f/dynamics-365-general-forum/406444/ssrs-fetchxml-date-field-with-year-parameter

https://www.daymandynamics.com/how-to-add-an-option-set-as-a-parameter-in-a-ssrs-report/

You may also post the issue on the D365 for more suggestions.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October