Discussions

Expand all | Collapse all

Can a user view a report without having the table show on the menu bar?

  • 1.  Can a user view a report without having the table show on the menu bar?

    Posted 04-21-2017 17:20
    I want to create a button on a form that links to a report on another table, but I don't want the other table to show in the users menu bar. Is this possible?


  • 2.  RE: Can a user view a report without having the table show on the menu bar?

    Posted 04-21-2017 17:27
    Yes this is possible, (and this might rock a few peoples perception of QB security)

    But the option of "May be viewed by" actually ONLY restricts what appears in the 'reports & charts' menu.  Any user regardless of role can see the report if they have the url, report id, or just change their URL to a different qid.

    So yes, just make that report only show in the menu for who you'd like, but the button to have a URL link to that report will work for anybody who has access to the app.

    You can make a formula url, and just copy the report URL into the formula box.


  • 3.  RE: Can a user view a report without having the table show on the menu bar?

    Posted 04-21-2017 18:23
    So I have done that.  I made only the specific report viewable that I want them to see.  I have the URL for the button specifically to that report.  But, if I have the "Hide Table In Bar" checked on the User Interface tab under Roles, the button doesn't work.  If I don't hide the table in the bar, then the button works.  I don't want to show the table in the Table Bar.



  • 4.  RE: Can a user view a report without having the table show on the menu bar?

    Posted 04-21-2017 18:26
    What does the end of your link look like?

    Like this:  "?a=td"
    or This: "?a=q&qid=1"

    The first is a link to the table home page, the second is a link to the actual report.

    **Edit**: The first wont work if you hide the table, but the second should work as long as they have permissions to view records in that table.


  • 5.  RE: Can a user view a report without having the table show on the menu bar?

    Posted 04-21-2017 18:56
    Yes.  That worked.  Thanks so much!!