Microsoft Dynamics AX (Archived)

New field not shown in report dataset

(0) Share

Report

Posted on by Community Member

Hi all,

i want to customize the CustVendPaymProposal report. My goal is to add a Field to the RDP Table.

Here are my steps i have done so far:

1. On Table "CustVendPaymProposal": Add Field "DocumentNum" ==> EDT: DocumentNum

2. On Class "CustVendPaymProposalController" (Method: "insertCustVendPaymProposalTmp"):

Add the line: "custVendPaymProposalTmp.DocumentNum = LedgerJournalTable.DocumentNum;"

3. Switch to Visual Studio and open the SSRS Report

4. Expand Datasets => Right click on "CustVendPaymProposalDS" => Refresh

And now there is my problem, the Field "DocumentNum" isn't here after the refresh.

- I didn't change the query: "Select * from ..."

- I also checked the design of the Table "CustVendPaymProposal" in SQL Server, where the field is added too.

- I noticed that if i open the report in VS i got this message: " : message AX1053: The model file was saved with an old version of the Dynamics AX Reporting Tools. Saving the file will also update its version to the current version."

I added some Screenshots here:

0636.screen.png

What i am missing?

Thanks for every help!

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Zain Bokhari 3,208 Moderator on at

Like (0)

Report

Hello James,

Did you run an incremental CIL after this?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Zain,

yes i do. I tried also a Full CIL.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Hi,

Please find below screenshot, you need to write code as shown in screenshot.

Then only you will able to see the DocumentNum in visual studio.

And you should add your DocumentNum field in CustVendPaymProposalTmp because the report dataset get the fields from CustVendPaymProposalTmp.

You missed to add field in CustVendPaymProposalTmp.

Thanks

Suersh

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Hi,

Incremental CIL/Full CIL is different and report dataset refresh is different!

Thanks

Suresh

Was this reply helpful? Yes No
Suggested answer

Zain Bokhari 3,208 Moderator on at

Like (0)

Report

Hi James,

I don't think there was anything that you missed. The steps you followed all seem correct. Please try to restart reporting services and AOS as well. Then try to refresh the dataset in VS and deploy your report.

Suresh is right these are two different things but last time strangely the CIL alone resolved this for me.

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Zain,

i tried also to restart the SSRS service and AOS and nothing has happend.

Best regards

James

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

Just delete your report from report server and deploy again in AOT. then you open visual studio, you will able to see that DocumentNum.

Thanks

Suresh

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Suresh,

thanks for your help. I deleted the report and deployed it without any change. I also tried a Refresh in VS after that procedure.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

     Better to Restart,

     1. AOS

     2.SQL server reporting services

     3.Clear report server cache

Thanks

Suresh

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

Thanks all for your help.

But the solution of the problem was, to add the field also to a query namend "CustVendPaymProposal" and not only to the table.

Best regards

James

Was this reply helpful? Yes No