SSRS Report is only viewable to Administrator not to another user (Report type -Link to Web Page)

(0) Share

Report

Posted on by Kishor Kumar

3,710

Hi all!!

I have created an SSRS report but when am loading the .rdl with existing file options , the respective reports were not loaded, so I had chosen the Link to webpage options and used the URL as below,

crm-srvr/.../Report.aspx

The respective reports were loaded when logged with Administrator role only, but when am logged with different user respective reports are not loaded.

Any suggestions, what are the things needed to be changed with respective to the security roles?? Or any other things need to be changed?? Needs Help...

Thanks in Advance!!!

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Alex Fun Wei Jie 33,628 on at

Like (0)

Report

make sure you change the setting like this and the user has read privilege in entities.

Was this reply helpful? Yes No
Kishor Kumar 3,710 on at

Like (0)

Report

Hi Wei Jie Fun,

thanks for your response,

I had given the rights as organization only and the another user has read privilege in entities.

But still its loads for Admin not for the another users!!

Any Suggestions Wei Jie Fun??

Thanks in advance

Was this reply helpful? Yes No
Alex Fun Wei Jie 33,628 on at

Like (0)

Report

is it possible to print screen the image for us to take a look ?

Was this reply helpful? Yes No
Kishor Kumar 3,710 on at

Like (0)

Report

Hi Wei Jie Fun,

I had updated the images as below, When Am logged as Administrator then Click the Run Report, its loading as shown below,

But am logging with different user, the respective report is not loading as shown below,

What are things that I have to change to show this reports for all the users in the organization.

Kindly Suggest some solution!! Am Still facing the issues

Was this reply helpful? Yes No
Suggested answer

Alex Fun Wei Jie 33,628 on at

Like (0)

Report

double check your report data source credential, have you set it to using window credential or ?

Was this reply helpful? Yes No
Alex Fun Wei Jie 33,628 on at

Like (0)

Report

only this report having this issue? how about the other reports

Was this reply helpful? Yes No
Kishor Kumar 3,710 on at

Like (0)

Report

Yeah,I have checked it is in windows Authentication Only!!!

Was this reply helpful? Yes No
Kishor Kumar 3,710 on at

Like (0)

Report

yeah only this report is only having this issue, and other reports am using the .rdl file to generate reports.

Was this reply helpful? Yes No
Alex Fun Wei Jie 33,628 on at

Like (0)

Report

is your report involved multiples entities? which methods are you using, fetch xml or sql query?

if you are using sql query, filtered view or normal view?

Was this reply helpful? Yes No
Kishor Kumar 3,710 on at

Like (0)

Report

yeah, am using Multiple Entities Like Account, Contact and opportunity to fetch the data using SQL query for the Filtered Views

Was this reply helpful? Yes No