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

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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?
Photo of Mary

Mary

  • 240 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.
Photo of Mary

Mary

  • 240 Points 100 badge 2x thumb
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.

Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.
(Edited)
Photo of Mary

Mary

  • 240 Points 100 badge 2x thumb
Yes.  That worked.  Thanks so much!!