Office Manager

Hiding reports in Office Manager

To prevent users from seeing patient data from other clinics to which they should not have access, you can use a script to hide Office Manager reports and restrict billing statement options.

To hide reports in Office Manager

Obtain the base script file (.sql file) from a representative on the Support or Implementations team. Copy the script file to your database server.

Modify the script as needed. Use the following table to determine how you want to modify the script.

Options for the "Hide reports in Office Manager" setting type
Field Value	Setting1 (Reference Reports)	Setting2 (Management Reports)	Setting3 (Billing)	Setting4 (Ledger Reports)	Setting5 (List Reports)	Setting6 (Blank ADA Form)	Explanation
0	Show	Show	Show	Show	Show	Show	All menu options are shown (current functionality).
1	Hide	Hide	Hide	Hide	Hide	Hide	All menu options are hidden.
2	N/A	N/A	Show	N/A	N/A	N/A	The menu option is shown. You can filter the statements by provider (in any clinic) or by the clinic that you are logged in to.
3	N/A	N/A	Show	N/A	N/A	N/A	The menu option is shown. The statements are filtered by the clinic that you are logged in to.

Run the script on the Dentrix database.