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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Calling a table find m...
Microsoft Dynamics AX (Archived)

Calling a table find method within query or view method

(0) ShareShare
ReportReport
Posted on by Community Member

I'm building a custom SSRS report and am trying to retrieve the ProjLinePropertySetup.LinePropertyId value alongside the ProjId and CategoryId values from an ISV layer table 'SavedTimer'.  It's not a simple matter of joining to the ProjLinePropertySetup using the two fields as a composite key, because the ProjLinePropertySetup table allows for an 'all projects' or 'all categories' option.  The ProjLinePropertySetup table has a helpful find(ProjId, CategoryId) method that will give me the desired value, but I can't work out where I can call this method (unless I create a new temp table and populate it with an RDP class for my SSRS report).  Can anyone please suggest any way of adding a method to the query, or to a view on the query, that will allow me to call the find method, using the values for each row in the 'SavedTimer' table?

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,990 Most Valuable Professional on at

    You can use display methods in query-based reports. Wouldn't it solve your problem?

  • Community Member Profile Picture
    Community Member on at

    Perhaps, yes: by adding a display method on the ISV table, you mean?  I was reluctant to alter objects that aren't mine, hoping just to create new views or queries, but I'll investigate that route, thanks.

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 237,990 Most Valuable Professional on at

    You can create a view and add the method to the view, if you prefer. On the other hand, adding a method to a table isn't a big deal and it's less work for both development and maintenance. Therefore if you have no other reason to introduce the view, I wouldn't do it.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans