Can a user view a report without having the table show on the menu bar?
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?
Forum Discussion
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.
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.