How do I display the employee policy name in a report?

Question

How do I display the employee policy name in a report?

Answer

You can add employee policy name as reporting column in timesheet and expense summary or details reports.

1. Navigate to the report and click edit
2. Scroll to report columns and click Plus(+) 
3. In the field pick list, scroll down to the bottom of the list and select <<SQL Expression>>
4. A SQL Expression dialog will open
5. Copy and paste the following sql into the edit box of the dialog:
   SELECT pp.name FROM t_policy AS pp WHERE pp.id=t_user.policyid
6. Set the Data Type to Text
7. Click OK to save the SQL Expression
8. From the Report Page, before doing your final save, click on Options on the lower right of the page.
9. In Options dialog, there will be a SQL "Group By" Expression edit box.
10. In this edit box, enter a comma (,) to the end of the text in this box, then add t_user.policyid
11. Click OK to save
12. Then click OK to save the report.
13. On the Reports tab, run the report which will now display the employee policy name.