Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Reports and problem pu...

Reports and problem pulling Data

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi Everyone,

We are using the Dexterity report writer to generate a basic report that pulls in data from several tables. We tried using a Virtual Table but we think some of the conditions are not able to be implemented. We have to relate several tables together that would not directly tie to the primary table. So we tried creating a view in SQL, and treating it as a table in dexterity.

This seemed to work. The Report allowed us to choose the table and set up the report. But if we run the report it can't pull the data. The view has the select privilege granted to DYNUSER.

Is this a limitation of the report writer or are we missing something?

We have toyed with the thought of using SSRS instead since we know that works better with views and other SQL objects, but are not sure if a SSRS can be called in the same way as a Dex report, for instance of a button event using run report.

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Reports and problem pulling Data

Turned out to be an error in one of the fields in one of the tables that made up the view. The Report works well with the view. Error reporting is not as good as it is with the forms though.