Topic: Group totals in a report
Hello,
I am working on a demo project for a customer which allows the user to total expenses by type for each employee in the specified date range. The main table has employee name, date, code, and amount. The employee name and code are both dictionary fields. I need for the user to be able to enter a date range to generate a report. This report should show each employee and there expenses for that date range. It needs to give a total for each code for each employee. For example, if an employee has three travel expenses during the specified date range, the report should add the three and show a total for this code. It would be good if each expense could be shown just above the total also.
I am getting so confused and wonder of anyone can help please.
Thanks in advance, David.