Default value in a Create Report Filter

Sylvie Vincenti

We are looking at creating some manager reports similar to what we have in S3. Where the manager running the report sees their direct reports and can click on their reports and see the reports under them. We set up a test report using ReportingRelationship BC and using the EmployeeSubordinatePrimaryList.

First run gave us all levels including those above the manager running the report and list the employee on the report multiple times. I created a filter where it only pulls Level = 1. This eliminated the upper levels but showed everyone and not just their direct reports when report is initially run. I hardcoded the employee ID of the test user in the filter and it gave us the report in the format we are looking for.

(Level = 1) and (ReportingRelation.ManagerEmpID = 15470)

What we are having issues with is what field can we replace the ID 15470 with, so it defaults to the one for the manager running the report.

Has anyone done this in Create Report filter?

Thanks

Sylvie Vincenti

I think we figured out the field. This one seems to do what we need it to in case anyone else is trying to do this.

HROrganization.ActorAgentEmployee

Now we need to see if we can use it with the additional Business Classes