New created SSRS Report Data Provider not showing in Visual Studio Report Designer Dataset Properties

(0) Share

Report

Posted on by Community Member

Hi,

I created new SSRS RDP class, then compiled, restart AOS and refresh the cache, but the RDP doesn't show in RDP list in VS Report Designer dataset query properties, SRSReportParameterAttribute(classStr(ContractClass)) and
SRSReportQueryAttribute('query') attributes are properly declared also extends SRSReportDataProviderBase in the new RDP class.

Here's the current setup of our environment; we have 2 AOS Service on the Test Inv. and we have many companies in different countries which means multi languages is implemented.

Any idea of what would be the possible reasons that a new created RPD won't show in VS RDP list?

Thanks,

Ysrael

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Brandon Wiese 17,790 on at

Like
a
(1)

Report
Copy link

Link copied!

I'm not 100% positive, but I think you must have at least one method marked as SRSReportDataSetAttribute(tableStr(yourtemptable)) to appear to an SSRS report as a data provider.

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

make sure the RDP has valid RDP methods, VS dataset datasource type = RDP, and make sure your default AX Config is set to the Server you are using with AX.

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

[SRSReportDataSetAttribute("yourtmptbl")]

in the method calling your tmp tbl

Was this reply helpful? Yes No
Suggested answer

Iulian Cordobin 8,201 on at

Like
a
(0)

Report
Copy link

Link copied!

Also, do not forget to do a Refresh elements while connected on the AOS you are using to connect with VS.

1 people found this reply helpful.

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks for the inputs, I've found already the solution in this issue. Please refer on the link below for details. Thanks.

community.dynamics.com/.../189660

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Ysrael,

Did you get any solutions? I have the same question, I created a new RDP class in AX but could not see it in VS RDP list.

Was this reply helpful? Yes No
Kanagaraj A 1,254 on at

Like
a
(0)

Report
Copy link

Link copied!

please ensure you have used below Inheritance Class,

"extends SRSReportDataProviderBase" in your DP class

Was this reply helpful? Yes No
Suggested answer

Ajit 8,788 on at

Like
a
(0)

Report
Copy link

Link copied!

Run the full CIL and try restarting AOS service once.

Was this reply helpful? Yes No