Jim-
Is there any grouping in the report? It would seem natural to group by department code and do the sums in group footer sections. If you didn't want to display the totals at the end of each group, you could write code to grab each code and total in the group footer Print event and stuff them into a dynamic array. Then in Report Footer format, dump the values out into unbound text boxes. The group footers could have zero height. The only sticky bit would be to sure to provide sufficient unbound text boxes in the report footer to handle any number of departments. You wouldn't need to modify the report again until you exceeded the number of available text boxes in the report footer - it could be dynamic.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On May 26, 2015, at 8:33 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hello all,
In an effort to unify some report summaries, I have discovered that the current process we have for summary pages on the Report Footers are not very efficient. There are not a lot of reports with this summary information but each time we get a new department, I cringe.
So right now we have on the report footer a series of labels and associated text boxes they go like below as samples. There are close to 35 as of today because of the new departments added recently.
HVAC Services =Sum(Abs([HR_HOME_DEPARTMENT_CODE]="D0802"))
Central Plant =Sum(Abs([HR_HOME_DEPARTMENT_CODE]="D0803"))
I was wondering what others are doing to fulfill this summary on a report? Is there a more efficient way of doing a summary? Each report has a different source because of the parameters needed for each.
Thank You
Jim Wagner
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar