How do I place totals derived from a header into the report footer?
Posted on 2015-02-02
I have several headers on my report: Supervisor, team (multiple teams under one supervisor), and employee. Under the employee name his training is listed. How do I total the number of employees, from the employee header, and place the total in the report footer?
The details on the report are:
Header: User_ID Header
Text Box: Name User_ID1
Text Box: Control Source: User_ID
In the Report Footer, I put a text box with, =Sum([User_ID])
For this, I got the error message, "Data type mismatch in criteria expression."
When I changed the text box by adding a 1 at the end of User_ID, I got a "Enter Parameter Value" dialog box for User_ID1. Clicking OK, gave me a blank text box in the Report Footer in the report view.
Changing the Format property of the text box to Standard and 0 decimal places produced the same result. Visible is "Yes."