question

LeeChamberlain-1963 avatar image
0 Votes"
LeeChamberlain-1963 asked ZoeHui-MSFT answered

Get year for parameter using SSRS with fetchxml query

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

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @LeeChamberlain-1963,

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.