Using AXEnumProvider as the dataset for parameters in reports
When you use Enum as a parameter in reports, it works well within the AX client. However, to deploy it to the Enterprise Portal (EP), the parameter lookup must be built through the AX Enum provider. This recipe will discuss how an Enum provider can be added to a report and used in parameters.
Getting ready
To verify the recipe output, you may require the enterprise portal configured for your Dynamics AX installation.
How to do it…
In the report, identify the Enum field that must be added to the parameters. Drag it to the Parameters node to create a new parameter.
Create a new dataset and set the Data Source Type to AX Enum Provider. Click on the ellipsis button (…) on the Query property.
In the application explorer, click on DataDictionary | Tables and select the table that has the enumerator, then go to Fields and select the Enum field and identify the Enum that it uses. Type the value in the Query property in the dataset.
This will...