SSRS with RDP

(0) Share

Report

Posted on by Faqruddin

1,909

Dears,

There is a table called PSAQUOTATIONTMP in AX2012R3, I added one new field called Name1. I use this field in insertPSAQUOTATIONTMP()[Related to PSAQUOTATIONDP RDP class]. So I can retrieve this field in my Project Report. My code as follows but it's not retrieving my desire field...

Table used in RDP class declaration[PSAQUOTATIONDP]:

DirPartyTable partyTable

InsertMethod[insertPSAQUOTAIONTMP()]

m_tPSAQuotationsTmp.Name1 = partyTable.Name;

Please Help me!

Thanks in advance!!!

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (1)

Martin Dráb 239,029 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Could you please elaborate "it's not retrieving my desire field"?

Have you tested that the RDP class successfully fills the field? If not, you have to fix it. If it does, your problem seems to be in the report and not in the class.

Was this reply helpful? Yes No
Suggested answer

Rachit 4,015 User Group Leader on at

Like (1)

Report
Copy link

Link copied!

Hi,

Edit the report in visual studio and refresh the dataset to view the new field you have added .

Once the dataset is refreshed then you can add it in the design.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

5400 7,162 on at

Like (1)

Report
Copy link

Link copied!

You have to select the DirPartyTbale before assign.

\Classes\PSAQuotationsDP\insertPSAQuotationsTmp

DirPartyTable partyTable

Like select firstonly name from partyTable

m_tPSAQuotationsTmp.Name1 = partyTable.Name;

I don't know your scenario. what criteria you want to pass for partyTable selection.

Was this reply helpful? Yes No
Faqruddin 1,909 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply. This is how I declare DirPartyTable, I'm working on project quotation reports customization and I need sales man info from DirPartyTable field "NAME".

Was this reply helpful? Yes No
Faqruddin 1,909 on at

Like (0)

Report
Copy link

Link copied!

Hello Rachit, thanks for your reply. I know dataset refresh but the problem is after Depoly the report Its not retrieving the "NAME1" field. Please check my code above.

Thank you!

Was this reply helpful? Yes No
Faqruddin 1,909 on at

Like (0)

Report
Copy link

Link copied!

Dear Matin - Please check I post my code. I mean I need to retrieve the "DirPartyTable" field called Name. So I create the Name1 as a temporary field in "PSAQUOTATIONTMP" table later I deploy this field in main Report. But its not retrieved any Name!!!

Thank you!!!

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report
Copy link

Link copied!

dir.jpg"/api/data/v9.1/msdyn_richtextfiles(EE91FE4C-659F-4061-9F17-B20E3052BB3D)/msdyn_imageblob/$value?size=full">

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
DirPartyTable partyTable; partyTable = DirPartyTable::findRec(HcmWorker::findByPerson(m_tSalesQuotationTable.WorkerSalesTaker).Person);

//as above you have to select party record of sales taker which is basically sales man

after that assign value

m_tPSAQuotationsTmp.Name1 = partyTable.Name;

Was this reply helpful? Yes No
Faqruddin 1,909 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your replies. It didn't execute anything, please check my code...

Was this reply helpful? Yes No
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
it should be working fine now.

for experimental purpose do following

m_tPSAQuotationsTmp.Name1 = "My Test Name";

Run the report:-

if data appears on report that means incremental CIL is missing. also restart to reporting services and aos can bring difference

if data does not appear that means something wrong out of ax i.e. at VS, try to refresh dataset and redeploy repot

Was this reply helpful? Yes No