web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

AX, SSRS, and table field arrays

(0) ShareShare
ReportReport
Posted on by 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)
  • Hariharans87 Profile Picture
    3 on at

    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.

  • Suggested answer
    b_radlyjames Profile Picture
    3,155 on at

    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.

  • Verified answer
    Hariharans87 Profile Picture
    3 on at

    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.

    SSRS-EDT-Array-Issue.png

  • Martin Dráb Profile Picture
    237,789 Most Valuable Professional on at

    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.

  • b_radlyjames Profile Picture
    3,155 on at

    Hariharan,

    That was it!  Thank you!!!

  • b_radlyjames Profile Picture
    3,155 on at

    Martin,

    I would disagree. =)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans