I have created a report that uses columns for an ORG chart report. I need to display the total number of employees within each column. How do I incorporated this value so that it is displayed at the bottom of the report and not at the floating bottom of the column.
I also need to include a total of employees, broken down by the type of employee - ie a legend. to also be displayed on the bottom of the report.
Note: I have tried various approaches by including the count (ie. Count(Empl#) places in the Manager footer - this gave me the floating value depending on the height of the column values. Then I tried using this field as a hidden field and placing a text field in the Report footer that references that hidden field - but that failed.
Also tried using a subreport but I was unable to get the report to line up with the Manager's column in the main report.
Looking for any suggestions.
![1]()
- sample from the original spreadsheet - which I am attempting to create in an Access Report.
I would use the page/report footer as appropriate and keep your own counts.
In the reports module at the top, dim variables to keep the totals.
In the page/report header OnFormat event, init those variables to 0.
In the detail section, add to those variables in the OnFormat event doing:
If FormatCount = 1 then
' Add to variables. Use the left property to determine the column your in.
End If
In the page/report footer, push the value of your variables into unbound text controls in the OnFormat event.
Do this with one total first to get it working, then add your other totals as needed (maybe use an array).
Jim.