Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Related table not show...
Microsoft Dynamics AX (Archived)

Related table not showing up in report selection criteria '1:n' menu

(0) ShareShare
ReportReport
Posted on by Stuart Clouston 50

Hi All,

I have a created a custom table called CustMembershipTable.  The table contains a field named CustAccount based on the CustAccount EDT that relates it back to the CustTable.

My issue is that when I open a report dialog, click "Select" to customise the selection criteria, right click on the Customers table and choose 1:n to add my custom table, it's simply not there.  How do I get the new table to appear in this list?

Things I have tried:

- ensured that a relationship exists to CustTable by means of the EDT.

- created a manual relationship between the two tables from both the CustTable side and the CustMembershipTable side.  (CustMembershipTable.CustAccount == CustTable.AccountNum)

- ensured that the new table has a descriptive label: "Customer Membership Table"

- ensured that TableGroup property is set to "Group"

- searched this forum and the Internet for a solution to no avail.

I'm out of ideas and I'd be very grateful to anyone who can answer this one for me.

Thanks,

Stuart

*This post is locked for comments

  • dynamics developer Profile Picture
    dynamics developer 1,272 on at
    RE: Related table not showing up in report selection criteria '1:n' menu

    I am not sure about it but I don't think so.

  • Stuart Clouston Profile Picture
    Stuart Clouston 50 on at
    RE: Related table not showing up in report selection criteria '1:n' menu

    There's actually a fair bit of customisation, so I'm surprised I haven't come across this issue before.  Do cross-references get updated as part of a full application compilation?  (Administration > Periodic > Compile application)

  • dynamics developer Profile Picture
    dynamics developer 1,272 on at
    RE: Related table not showing up in report selection criteria '1:n' menu

    I see, then you must have been updating cross references regularly or there is not a lot of customization yet.

  • Stuart Clouston Profile Picture
    Stuart Clouston 50 on at
    RE: Related table not showing up in report selection criteria '1:n' menu

    Hi Haris,

    Thanks for that.  I tried it the manual way (Tools > Development Tools > Cross-reference > Periodic > Update) in my test environment and it was pretty quick (about one minute).  But I will test and use your script to automate the process for future.

    Thank you!

  • Stuart Clouston Profile Picture
    Stuart Clouston 50 on at
    RE: Related table not showing up in report selection criteria '1:n' menu

    Hi Ievgen,

    That did the trick.  Thank you!

  • Verified answer
    dynamics developer Profile Picture
    dynamics developer 1,272 on at
    RE: Related table not showing up in report selection criteria '1:n' menu

    And since the cross reference update is a time consuming process you might want to run the below job to update all the the cross references using batch job. (make sure not to shut down the server while it's processing and AOS is running)

    static void CrossRefUpdateBatch(Args _args)
{    
    xRefUpdateIL::updateAllXref(true, false, true);
    info("Done, cross reference update batch job created.");
}


  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Related table not showing up in report selection criteria '1:n' menu

    Hi Stuart Clouston ,

    Did you try to build cross references ? As far as I remember AX use them to build this list so if you created new table\edt with relation you need to build  cross references,

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans