web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Fetch SSRS Report - Op...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested Answer

Fetch SSRS Report - Option Sets

(1) Share

Report

Report

Posted on by CRM2013USER

177

Hello!

Is there a supported method to display an option set in an SSRS report (list of available attribute values from Dynamics) in a Fetch SSRS report downloaded to Word?

For example, if I have a custom option set field in Dynamics with 5 attribute values, the current SSRS report Fields!optionsetone.Value expression exports the selected value from the form on the report. Is there a way to also export all available values from Dynamics in the report so the user could change to another available value (from a drop down) once the report was downloaded?

Thanks!

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Haig Liu Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi CRM2013USER,

Hopefully the following links will help you:.

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

The general forum may not be able to provide you with enough support, so it is recommended to raise a support ticket.

thanks,
Haig Liu

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

Pallavi Phade 102 Super User 2026 Season 1

#2

#3

Abhilash Warrier 55 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans