Dynamics AX 2012 SSRS report enum parameter

Finance and Operations/AX Developer Forum
1

Hi,

Does anybody know why enum parameters are not showing the list of values in Dynamics AX?

I created the report. Then I have added the data set of type AX enum provider. After that I have created the report parameter which uses values from that data set (AX enum provider). When previewing the report in VS it shows the list of enum values, but when I deploy this report and try to launch from Dynamics AX it only shows integer field.

2

Select your parameter and right click on properties—> Values—>

DataSet —> Select your dataset

Value Field —> Name

Label Field —> Label

Now check with preview you will get Enum with name not integer.

Hope it helps.

3

Hi ALL

I created the Enum parameter field but I want to add From Date and To date as fitter parameter ,how I have to do it .

when I am adding the date filed on filter and check by date parameter it is not filtering . I hope it happening only because I set my dataset Dynamics filter as false . so kindly help me on this .

.

Regards

Sumit

4

Hi, I created a report with AX Enum Provider, It work fine in VS.

But it throw error, when running from AX client(AX 2012 R3) and also it don’t show the enum lookup.

Error while setting server report parameters. Error message: The value provided for the report parameter 'XXXXXXXXXXStatus_DynamicParameter' is not valid for its type. (rsReportParameterTypeMismatch)

Anyone have solution reply.

5

I have set ‘Dynamic Filters’ property to ‘false’ in my dataset.

It works good as expected.