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»»

Hiding the Show/Hide details button on the Report Server Expand / Collapse
Author
Message
Posted Friday, August 6, 2010 10:47 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 1:01 PM
Points: 75, Visits: 209
Although you can make a folder invisible in the view list, if you click on show details, the folder shows up and the user has access to it. This ocurrs even if the user has the bare minimum permissions. I need to hide this button so the user cannot go to details view.

You may ask, why not just block access to the folder.
The answer is that reports located in that folder have to be able to be called by users through other software, using reportviewer. Blocking access from the server also blocks access via the software.

In short, I need to hide the show/hide details button on the toolbar.

Thank you.
Post #965324
Posted Monday, August 9, 2010 11:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 20, 2014 5:34 AM
Points: 2,651, Visits: 5,990
IT seems to me you might be able to accomplish by modifying the aspx pages that run the report manager, though note that any upgrades/service packs etc might break it. You say the reports need to be accessed by another piece of software and that's why they need to be accessible. Is there any chance you might be able to change the credentials that the other piece of software uses to access those reports? That way you can all access to that folder for that user and exclude the rest of your users.

-Luke.


To help us help you read this

For better help with performance problems please read this
Post #966124
Posted Tuesday, August 17, 2010 1:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 28, 2012 12:49 PM
Points: 9, Visits: 24
Yeah, I am having the same issue. In doing some research on the MSDN blog, I've found that there really is no way to do this except for the modification of the .css file (which will hide it for ALL users including Admins). The only real way to do away with it at this point would be to write your own SSRS site (web page) with a custom security extension. This take time and dollars....

Unless anyone else knows otherwise??
Post #970687
Posted Thursday, October 14, 2010 4:35 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 27, 2011 4:13 PM
Points: 19, Visits: 87
To hide the 'Show Details' button, add the following to your ReportingServices.css file.
#ui_btnSwitchView

{

visibility: hidden;

}



As stated this does hide the Show Details button for everyone, including Admins. However, I created a Bookmark that allows me and others to toggle the Details and List Views in my Favorites Toolbar. This works for IE. I have not tested it for other browsers.

To create the Toggle button in your Favorites Bar, follow the instructions below.

1. Create any favorite on the Favorites Bar.

2. Right-click on the Favorite and select Properties.


3. Select the General tab and rename the Favorite.


4. Select Web Document tab and in the URL add the Javascript.


5. The JavaScript is as follows:


function gotoDetailhref(eid){var elmt = document.getElementById(eid); if (elmt != null){ window.location = elmt.href; } } gotoDetailhref("ui_btnSwitchView");




6. Select OK.


(58.30115757480578, -134.4143772125244)
Post #1004839
Posted Friday, October 15, 2010 4:41 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:46 AM
Points: 900, Visits: 1,269
I do not know if this is what you require but this is how we deal with the issue of hiding details buttons.

We create a new report that acts as a menu for a set of reports and then publish this to the reports server.

Next we edit the url of the 'menu report' as follows:

original

http://d-****/Reports/Pages/Folder.aspx?ItemPath=%2fCAYA%............

to this

http://d-****/reportserver?%2fCAYA%..............

The we send the 'menu' link to the users. If they access reports through this link it hides the details, etc.

There is one drawback to this approach - if the reports has user selectable parameters then this approach does not work. What we do then is for any reports with parameters that needs to be selected we add the original link as a url to the menu. This will then show the buttons which was what you wnated to avoid. I guess therefore this is only a partial solution, but it is one that we have been happy with so far.

It was interesting seeing the other approach listed here and this is something that I may look at in the future.

Tim
Post #1005036
Posted Tuesday, May 22, 2012 12:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 8:49 AM
Points: 4, Visits: 23
This worked great for me! The only modification I made was to prefix the function link with "javascript :" (no space) and ignored the error that javascript does not have a registered program. I also named my Favorite as "Toggle View". Thanks!!
Post #1304377
Posted Wednesday, February 20, 2013 7:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:36 AM
Points: 8, Visits: 22
Hi All,
As thom sugessted, I have fallowed all his instructions like placing the code in the .CSS file
So first bit is working fine then come to second bit like creating favourite link
as he suggested that we should have to paste that Java Script in the URL
I don't understand this part where I need to place that Java script I mean is that after URL or anywhere else ?

http://servername/Reports/Pages/Folder.aspx?/function gotoDetailhref(eid){var elmt = document.getElementById(eid); if (elmt != null){ window.location = elmt.href; } } gotoDetailhref("ui_btnSwitchView")";

this is what I tried but I can't able to see DetailView I should have to see detail view bcz I'm admin
Can anyone guide me through ?
Post #1422074
Posted Wednesday, February 20, 2013 7:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 8:49 AM
Points: 4, Visits: 23
This is what my Favorite (URL) looks like. It actually starts with "javascript" colon. I type the word colon here because if I type it with the word javascript, the editor strips it out automatically when I post.

javascript-colon function gotoDetailhref(eid){var elmt = document.getElementById(eid); if (elmt != null){ window.location = elmt.href; } } gotoDetailhref("ui_btnSwitchView");
Post #1422077
Posted Wednesday, February 20, 2013 7:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:36 AM
Points: 8, Visits: 22
Thanks for your reply. So you want me to try like this
So initially URL does have http://server .......... so I should have to delete this then
I need to paste the below code in the URL box right ? Please correct me if I'm wrong

""function gotoDetailhref(eid){var elmt = document.getElementById(eid); if (elmt != null){ window.location = elmt.href; } } gotoDetailhref("ui_btnSwitchView");

in the Colons I should have to put javascript

if you have give me other example thanks for your help
Post #1422095
Posted Wednesday, February 20, 2013 8:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 8:49 AM
Points: 4, Visits: 23
Yes, in the quotes put javascript with a ":" colon.
Post #1422102
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse