AX, SSRS, and table field arrays

(0) Share

Report

Posted on by b_radlyjames

3,157

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 30 on at

Like (0)

Report
Copy link

Link copied!

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,157 on at

Like (0)

Report
Copy link

Link copied!

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 30 on at

Like (1)

Report
Copy link

Link copied!

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 238,734 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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,157 on at

Like (0)

Report
Copy link

Link copied!

Hariharan,

That was it! Thank you!!!

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

Like (0)

Report
Copy link

Link copied!

Martin,

I would disagree. =)

Was this reply helpful? Yes No