AX, SSRS, and table field arrays

(0) Share

Report

Posted on by b_radlyjames

3,155

I have created my own custom EDT that is an array. It has 13 elements, the first of which is automatically created so I created 2-13.

Everything is fine until I try to use this in an SSRS report. When I refresh the dataset in SSRS, I see the array populated as 13 different fields like so:

MyFieldArray

MyFieldArray1

MyFieldArray2

...

MyFieldArray12

This is a little strange in that AX uses 1-13 not 0-12 but didn't seem to bad...

The problem is that if, in AX, I set myFieldArray[1], that can come through into SSRS into ANY of the fields in the dataset... Could be MyFieldArray6, or MyFieldArray2. It changes each time I run the report.

Have I set something up wrong?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Hariharans87 3 on at

Like (0)

Report

You mean, if you assign the value to myFieldArray[1], but that value is displaying in the SSRS report MyFieldArray6 field.

Example, I have the address array field, i assign value to addresss[1]. In SSRS address1 is empty and address2 is displaying address1 value.

If the above example match your problem, Please let me know that how you are assign the value to the array fields in the temp table (SSRS report datasource). Please share your code.

Was this reply helpful? Yes No
Suggested answer

b_radlyjames 3,155 on at

Like (0)

Report

myTable.MyFieldArray[1] = myValue;

And yes, if I set it to 1 in AX I have to get out of 6 or another location. The locations are constantly changing.

Was this reply helpful? Yes No
Verified answer

Hariharans87 3 on at

Like (1)

Report

It is not changing randomly. I have reproduced this issue.

The problem is in the the SSRS dataset fields name creation part.

Please don't look the dataset fields name. Please have a look on the SSRS dataset field alias property. It is the correct mapping with the table fields.

Was this reply helpful? Yes No
Martin Dráb 237,789 Most Valuable Professional on at

Like (0)

Report

No, it's not strange that the first index is 1. It's exactly how it's designed in Dynamics AX. That other languages use zero-based indexes is irrelevant.

Was this reply helpful? Yes No
b_radlyjames 3,155 on at

Like (0)

Report

Hariharan,

That was it! Thank you!!!

Was this reply helpful? Yes No
b_radlyjames 3,155 on at

Like (0)

Report

Martin,

I would disagree. =)

Was this reply helpful? Yes No