Skip to main content
Question

Hide 'Sorting and grouping...' on More drop-list of a report

  • June 21, 2018
  • 0 replies
  • 139 views
Hi, 
I am unable to suppress the 'Sorting and grouping' selection on the 'More' droplist at the top of all my reports. Clicking on it allows users to view field names which is a security issue, messy  and not necessary.

In roles, I have selected:
- Hide UI for creating or customizing reports
- Hide personal settings link
- In user interface, Hide UI for: all 6 options selected.

Thanks.
    This topic has been closed for replies.

    Forum|alt.badge.img+17
    • EvanMartinez
    • Community Moderator
    • June 21, 2018
    Hi Gary,

    Unfortunately in your instance there is not a specific UI component to toggle this option off and on for users. It is built in to allow for further Sorting and Grouping. However, it should only be populating that dropdown that appears with fields that the specific user has field access to. Any field where they are set to permissions of none should not appear in that list. This does mean they might see fields they have access to but aren't on the typical forms and reports they can use but they will not see the name of fields they have been given permissions of none for. I hope this information is helpful Gary. 
    • anomDiebolt
    • Registered
    • June 21, 2018
    Using your favorite script injection technique you can remove that option with one line of code:
    $("#A1").remove();
    Likewise you can remove other options in that menu by specifying the appropriate id:



    But don't stop there - you can likewise add your own options to that menu.
    • GaryBoyd
    • Author
    • Registered
    • June 23, 2018
    Thanks Dan - for this and you obviously provide a lot of help on functionality when you search other posts also. Have not had time to try yet.

    Would be good to consider, if you restrict field role permissions to none, do the formulas for users relying on info from those fields fail?
    • GaryBoyd
    • Author
    • Registered
    • August 31, 2018
    Hi Dan - trying to use chrome to find elements and it is really worthwhile.
    This did not work & I could not find A1 in the source code.
    $("#A1").remove();


    $("#ViewOtherOps").remove();
    This partially works - pressing 'More' button does nothing, however the 'More' button still shows above the report.

    $("#vsmore").remove();
    More button clicks and shows no options
    Terms & ConditionsAccessibility statement