SRSS Report only displaying Header info but no data for certaing roles AX 2012

(0) Share

Report

Posted on by CBNestor

Hi all,

If have two users. One is System administrator and the other is System user with a cutom Role called AKS_ProdCalcTrans; this last role has read persmission to two reports includind the tables that are related to them and to the ProdTableListPage (sice the output buttons to those reports are here)

So this second user is able to display one of the reports with full information and the other report is only displaying the header but no data. Here I snip of how this is set up for you guys to undestand

All entry points has AccesLevel:Read and all the tables in the privileges has EffectiveAccessL Read ( of curse the System administrator can see all report as it should be, even if I assign it the second user.)

I have the same question (0)

All responses (16)

Answers (1)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Nestor,

Is this a DP based report or a query based report,

If it is a DP based report, have you given permissions for the temp table to the new permission?

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report

I am kinda new with reporting, so forgive If I cannot give you the right answer,

Both report are filtering the Parameters using the same extions of SrsReportRunController (prePromptModifyContract) as far as I know I am not envolving/program any temporary table.

Thats why I wonder If almost both are made the same way but with slight different tables in their queries why Only one of them is showing all data.

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

I am assuming you are using a query as datasource for the report.

Could you please check each of the tables under the privilege node and check that none of them have the "Effective access" property set to "NoAccess". It should be set to "Read" atleast.

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report

Hi Gunjan,

Yes I did made sure. the infolog normally will prompt a message the the user has no right to read a specific table. but yes all tables are set to Read in the table permissions of the privilege

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Nestor,

Could you please take a screenshot of the tables in the query?

Also, can you tell me the table you are using for the details section? You should be able to get it from the report design.

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report

This are the tables for the query, I am not sure about the details section? sorry can you show me

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Nestor,

Could you try adding ProdCalcTrans with Read property under the Report design parameters and set the access to read?

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report

This I have to do it in visual Studio?

I need to link that table in the Query I guess. because I dont think this table is needed

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

No. Not in VS. I assumed you are using this in your report .

All the tables you have added to the security privilege, could you please add under the Permissions\Tables node in the SSRS report? All of them should have "Read" access property.

I used your image only here

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report

Hi Gunjan,

Yes they all have Read access as well, I also added the ProdCalcTrans (with read access), still no success

Was this reply helpful? Yes No