Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Cannot view reports in Report Manager Expand / Collapse
Author
Message
Posted Wednesday, August 27, 2014 9:02 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 8:48 AM
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
Post #1607879
Posted Wednesday, August 27, 2014 9:05 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 8:59 AM
Points: 341, Visits: 307
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.
Post #1607881
Posted Wednesday, August 27, 2014 9:37 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 8:59 AM
Points: 341, Visits: 307
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.
Post #1607897
Posted Wednesday, August 27, 2014 9:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 8:48 AM
Points: 29, Visits: 48
Many thanks. Will review later on.

BTW, is there a way to thank people on this forum?
Post #1607902
Posted Wednesday, August 27, 2014 9:51 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 8:59 AM
Points: 341, Visits: 307
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.

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
Post #1607904
Posted Thursday, August 28, 2014 12:09 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 8:48 AM
Points: 29, Visits: 48
Indeed, excellent info.

Once again thanks.
John
Post #1608132
Posted Friday, August 29, 2014 4:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 16, 2014 5:11 AM
Points: 243, Visits: 2,717
Have you tried running your browser in Admin mode (run as Administrator)
Post #1608535
Posted Friday, August 29, 2014 4:41 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 8:48 AM
Points: 29, Visits: 48
Yes,I ran both the browser and SSDT in admin mode.
Post #1608542
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse