June 2, 2015 at 3:11 pm
Hello all,
I gave a user all required permission to view the SSRS report. User is able to select from the dropdown list but unable to view the data, It is showing a blank screen. Suggestions greatly appreciated.
Thanks!
June 2, 2015 at 3:35 pm
sheba.sql (6/2/2015)
Hello all,I gave a user all required permission to view the SSRS report. User is able to select from the dropdown list but unable to view the data, It is showing a blank screen. Suggestions greatly appreciated.
Thanks!
The credentials that the user is using to run that report does not have access to the stored procedure that drives that dropdown. That would be my first guess.
-- Itzik Ben-Gan 2001
June 3, 2015 at 4:44 am
The credentials that the user is using to run that report does not have access to the stored procedure that drives that dropdown. That would be my first guess.
This. If the data source(s) the report is pointing to use Windows credentials you need to ensure the user running the report has the permissions to the data source and execute permission to an procedures the report uses.
Joie Andrew
"Since 1982"
June 3, 2015 at 7:10 am
I have Credentials stored in the report for the Data source and also i am using a select statement in the report not calling any store procedure. User is able to view another similar kind of report in the same folder but not this report. This is wierd, any suggestions.
Thanks!
June 3, 2015 at 8:35 am
sheba.sql (6/3/2015)
I have Credentials stored in the report for the Data source and also i am using a select statement in the report not calling any store procedure. User is able to view another similar kind of report in the same folder but not this report. This is wierd, any suggestions.
The SSRS report still has data sources tied to it at the report level. Even SELECT statements need a data source.
When you deployed your RDL file to the report server, what options did you choose:
1. A Shared Data Source?
2. A Custom Data Source?
3. Credentials supplied?
4. Credentials stored
5. Windows integrated?
6. Credentials not required?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 3, 2015 at 9:45 am
Can you post the error from the SSRS log?
Joie Andrew
"Since 1982"
June 4, 2015 at 11:11 am
It's a Custom Data Source and Credentials are stored in Report server.
June 5, 2015 at 12:58 am
User i gave permission to view my report, She does not get any error. She can view the dropdown list but when she selects view report it comes as blank screen.
Is it possible to have the user run a query (possibly sitting next to you) in SSMS with his/her account and see what comes back? It sounds like the user might be getting results filtered out due to permissions. I know that CRM uses this model a lot.
Joie Andrew
"Since 1982"
June 5, 2015 at 7:53 am
A permissions problem would most likely result in an error, the fact that the user doesn't get an error and just receives a blank screen leads me to believe that part is just fine. I don't suppose there's any layer of encryption going on is there?
I don't suppose you could upload a screenshot or two of this? I am having trouble visualizing this "drop down" you're referring to... :-D:-D
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 5, 2015 at 9:54 am
My guess here would be the report's fine, just returning no data. As others have said, see if you can run the query in SSMS as yourself and the report credentials & check results.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply