Microsoft dynamics AX : SSRS Report data not shown, even temp data filled in AX 2012

HI, recently I have come across an issue related to SSRS report data not showing for a user, even after full access is assigned with in the privileges

 

Issue:

New privilege was created with menu item access ‘Delete’ i.e full access

priv-1

priv-2

 

This privilege is assigned to specific role to open the report. But when open report , SSRS report show blank data

 

priv-3

Note: When try to open the report via Admin, the record was shown correctly, and even i tried to debug the ‘process-report’ method with limited permission and found out that data is populating correctly in to the temporary table.

 

Resolution: Explicit permissions were given to the table , under Priviliges>permissions>table. I added the table and gave Effectiveaccess – readonly

priv-4

 

Result: Report started showing data

priv-5

 

 

Advertisements

One response to “Microsoft dynamics AX : SSRS Report data not shown, even temp data filled in AX 2012

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s