Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cannot view reports in Report Manager


Cannot view reports in Report Manager

Author
Message
JohnPapa
JohnPapa
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 48
One possibly relevant piece of info is that with the specific login john-pc\Administrator, I cannot get the combobox options when I click on the combobox selector in Report Manager.

For the above, I log in as john-pc\john and run Report Manager and SSDT as Admin.

When I log in as User Administrator then I have access to the combobox options.

Do I need to change something in user Administrator?

John
PHYData DBA
PHYData DBA
Mr or Mrs. 500
Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)

Group: General Forum Members
Points: 560 Visits: 533
JohnPapa (8/27/2014)
One possibly relevant piece of info is that with the specific login john-pc\Administrator, I cannot get the combobox options when I click on the combobox selector in Report Manager.

For the above, I log in as john-pc\john and run Report Manager and SSDT as Admin.

When I log in as User Administrator then I have access to the combobox options.

Do I need to change something in user Administrator?

John

What you might need to change are your SSRS configuration settings.
Again, these setting are dependant on your environment and your use. You should go to TechNet and check out the Books Online and set-up guides. They are very useful.
PHYData DBA
PHYData DBA
Mr or Mrs. 500
Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)

Group: General Forum Members
Points: 560 Visits: 533
JohnPapa (8/27/2014)
Thanks PHYData DBA,

Will look into your suggestion. I've spent a couple of days on this issue, which must be easier than it seems.

What data can I provide to help you help me?

The report data can be found at
https://dl.dropboxusercontent.com/u/13473531/Junk/Files.zip

Thanks,
John

John, I think you are getting to what your issues are now.
After reading your last post (made after this one) you are now looking at how your Server is running the report and using the data source.
This has nothing to do with your report or it's code in SDT 2012.
It is about how reports need to access data because of your SSRS settings and configuration.
My recommendations: Create and use Windows Accounts as the Service and Execution accounts. Make sure to read the SSRS set-up guide for how to create these accounts correctly. Make sure to ready the SSRS set-up guide for you version/edition of SQL Server. It's important that your SSRS server is configured correctly. Even the Dropdown control settings are changed by this.
JohnPapa
JohnPapa
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 48
Many thanks. Will review later on.

BTW, is there a way to thank people on this forum?
PHYData DBA
PHYData DBA
Mr or Mrs. 500
Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)

Group: General Forum Members
Points: 560 Visits: 533
JohnPapa (8/27/2014)
Many thanks. Will review later on.

BTW, is there a way to thank people on this forum?

There is, and you just did it. :-D

BTW - Here is a direct link to some great information:

http://download.microsoft.com/download/6/1/6/616FF1A6-9269-4A0B-83F8-D9024AA39FA5/SQLServerReportingServicesGuide.pdf
JohnPapa
JohnPapa
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 48
Indeed, excellent info.

Once again thanks.
John
Scott Murray-240410
Scott Murray-240410
SSC Veteran
SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)

Group: General Forum Members
Points: 249 Visits: 3067
Have you tried running your browser in Admin mode (run as Administrator)
JohnPapa
JohnPapa
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 48
Yes,I ran both the browser and SSDT in admin mode.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search