SSRS Report Using RDP Class, Names Do Not Show Up in The Report

(0) Share

Report

Posted on by Momochi

1,044

Hello people! i'm still learning Dynamics Ax development, I'm practicing making reports but I encountered an issue that I seek your help for it :)
I'm trying to make a report from "VendTable" and "VendTrans" that will display the "account number" of the vendor, their names and the sum of "amountMST" from VendTrans table. The report did display the account numbers and the sum of amountMST but the names are not showing up. This is the logic I used:

1256.Ax3.PNG

and this is the output of the report opened with internet explorer:

6428.Ax2.PNG

I tried making another report which I only retrieve the names and the account numbers and it displayed correctly, so maybe I am wrong with my select statement and join. Your help will be appreciated :D

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Momochi 1,044 on at

Like (0)

Report
Copy link

Link copied!

Yeah I forgot to write that, I did it in infolog but names did not show up too. Thanks for your reply.

Was this reply helpful? Yes No
Verified answer

Momochi 1,044 on at

Like (0)

Report
Copy link

Link copied!

Yeah, I needed to add another "group by" for the names too but since the name field is not in "VendTable" so I needed to make another join with "DirPartyTable" which contains the name field using the relation between "VendTable.Party" and "DirPartyTable.RecId".

Thanks for the hint Mr. Crispin! i'm still new and just started learning the Ax and I get into small issues like these haha

Here is the new working statement:

Here is the new output:

Was this reply helpful? Yes No
Momochi 1,044 on at

Like (1)

Report
Copy link

Link copied!

Indeed, way more optimized haha.

I didn't know about the vendTrans.vendTableName() method! guess there is so much to learn. Thanks again Mr. Crispin!

Was this reply helpful? Yes No
Momochi 1,044 on at

Like (0)

Report
Copy link

Link copied!

Hello Mr. Crispin, I tried to add phone to the report but I had a similar problem where the phone numbers did not show up, I used the method in "VendTable" which is called VendTable.Phone() but it did not work out. Since the "Phone" field is not in "VendTable" and it exists in "LogisticsElectronicAddresses" Table, I tried to find a relation between "VendTrans" Table" and "LogisticsElectronicAddresses" but couldn't find something, that's why I'm trying to use "VendTable" in the select statement so I can use the "VendTable.Phone()" method. Can you please identify my mistake or problem?

Here is my new Code:

Here is the output:

Was this reply helpful? Yes No
Momochi 1,044 on at

Like (1)

Report
Copy link

Link copied!

That did it, thanks for your help a third time Mr. Crispin! It's because I didn't know the purpose of "party" and yeah when I tried the breakpoint, I have seen the "this.party".

Was this reply helpful? Yes No