Microsoft Dynamics AX (Archived)

Adding New Table in Existing RDP class for Report

(0) Share

Report

Posted on by Nakul

1,185

Hello

I am trying to add a new table in PurchPurchaseorderDP class

Took the reference of this post

community.dynamics.com/.../107781.aspx

but when running report "No report data table with name mytable exists in report schema for data provider PurchPurchaseOrderDP." error is reflecting and not report is not opening .

Please tell me possible solution

Thanx in advance..

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Denis Macchinetti 16,444 on at

Like (0)

Report

Hi Nakul

In the link below you can find your same issue.

Verify that the report is bound to tables that exist and do not bind multiple datasets to a single report data provider class.

Instead, define the report to have the multiple tables pointing to the same dataset.

technet.microsoft.com/.../gg731894.aspx

Also, as the comment at the end of the page, try to restart SQL Server Reporting Services.

Was this reply helpful? Yes No
Dick Wenning 8,705 Moderator on at

Like (0)

Report

2 times the same table will not work, I tried that, did not work

as long the processing create the content for both tables,

in your used example you add something

[

SRSReportDataSetAttribute(tableStr(NEWTABLETmp))

]

public NEWTABLETmp getNEWTABLETmp()

{

select NEWTABLETmp;

return NEWTABLETmp;

}

the NEWTABLETmp should be filled in the processing method

Was this reply helpful? Yes No
MylesHollywood 5 on at

Like (0)

Report

I'm having this issue too. This is a standard report that has two data sets pointing to the same DP.

DataSet -> Report Data Provider -> Table

PurchPurchaseOrderLine -> PurchPurchaseOrderDP -> PurchPurchaseOrderTmp

PurchPurchaseOrderDS -> PurchPurchaseOrderDP -> PurchPurchaseOrderHeader

The second table reference to the DP class is the PurchPurchaseOrderHeader.

I have synchronized the tables, recompiled and compiled forward all report classes and restarted SSRS, removed the usage data for all related forms and AOT objects.

When I open Visual studio and refresh the report data I still get the same error.

I'm using VS 2010 SP1 10.0.40219.1

AX Components 6.2.1.5.8.0

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

I don't think it's your issue as long as the report can be built and deployed. I had the same error but the report builds and deploys successfully.

Since I installed CU8 and VS 2013 Report Building Tools I didn't get that error anymore. Try that and tell me if it works!

Was this reply helpful? Yes No
Suggested answer

Kalpanath CS on at

Like (0)

Report

Dear All,

The issue is solved by restarting the reporting server.

Regard's

KP

Was this reply helpful? Yes No