SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Hiding the Show/Hide details button on the Report Server


Hiding the Show/Hide details button on the Report Server

Author
Message
tsmith-960032
tsmith-960032
SSC-Enthusiastic
SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)

Group: General Forum Members
Points: 192 Visits: 217
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.
Luke L
Luke L
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3920 Visits: 6127
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
stangman5l
stangman5l
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 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??
thomas.briscoe
thomas.briscoe
SSC Rookie
SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)

Group: General Forum Members
Points: 31 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)
skanker
skanker
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1139 Visits: 1385
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
billparks
billparks
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 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!! :-)
rama.b315
rama.b315
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 58
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 ?
billparks
billparks
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 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");
rama.b315
rama.b315
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 58
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
billparks
billparks
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 23
Yes, in the quotes put javascript with a ":" colon.
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