Filtering report groups
To filter out a report group from access, you'll need to create a query that excludes the report group.
This example creates a Report Group Query that excludes the payslip report group.
- Go to Reports > Report Groups > View Queries.
_Page_04_Image_0003.png?inst-v=e1384ab6-150f-4d24-beed-5a419c4e6827)
- Insert a new query. For example, NOPAYSLIP.
- To add the clause to exclude the payslip group(s), you need to save the query and then edit it again.
- After saving the query, click Edit.
_Page_05_Image_0003.png?inst-v=e1384ab6-150f-4d24-beed-5a419c4e6827)
Select No restrictions and press Enter on your keyboard.
In the Fields window, select Report group and click OK.
_Page_05_Image_0004.png?inst-v=e1384ab6-150f-4d24-beed-5a419c4e6827)
In the Operators window, select is not equal to and click OK.
_Page_06_Image_0003.png?inst-v=e1384ab6-150f-4d24-beed-5a419c4e6827)
Select the PAYSLIPS report group and click Select.
_Page_06_Image_0004.png?inst-v=e1384ab6-150f-4d24-beed-5a419c4e6827)
Your query will look like this:
_Page_07_Image_0003.png?inst-v=e1384ab6-150f-4d24-beed-5a419c4e6827)
- Open the user’s Security Profile, Edit and Add the query against report groups.
_Page_08_Image_0003.png?inst-v=e1384ab6-150f-4d24-beed-5a419c4e6827)
Go to Report > Report Groups do the following
Add the new query to Security Query field
Change the Access Level to VIEW
Save and Close.
This stops the user from changing any of the other report groups to add the payslip report. They can still edit report settings and change destination, format, etc.
These changes will affect everyone on the same security profile
