Developped SSRS report not showing data to non-admin users

(0) Share

Report

Posted on by Rabih Khoury

110

Dears,

I've Developed an SSRS report from scratch that shows the invoices of a wave. I used the following tables in the picture:

The data is showing correctly when we access the report from a sysAdmin user, but when we access it from a non-admin user only the layout of the report shows (with some data) as shown below:

6787.Report.PNG

And also note that Sales manager, Warehouse manager, Accounts Receivable manager, Customer service manager, and many other roles are assigned to this non-admin user.

Appreciate your help.

Regards.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Chandra Wijaya Seti... 1,145 on at

Like (0)

Report

Have you granted entry point to tables you use as datasource to duty/privilege.

Has the duty/privelge been assigned to those roles?

Was this reply helpful? Yes No
Suggested answer

Agha SirajulDola 555 on at

Like (0)

Report

1 Verify the Role and Duties

2 otherwise, Go to

and assign those users following roles

Was this reply helpful? Yes No
Rabih Khoury 110 on at

Like (0)

Report

This was solved by adding the temp table in the "override permission" section of the role given to the users.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

i face the same issue before , just override permission for your role and add the used temp table in this report.

Was this reply helpful? Yes No