change grouping on the fly
- From: "Stephen" <stephen@xxxxxxxxxxxxxxxxx>
- Date: Sun, 10 Jul 2005 22:13:15 -0700
I have a number of reports (25) that show agent activity for a specified
reporting period. We are trying to setup these reports so that they can be
printed as a company whole, OR grouped by office. The office name is one of
the fields passed in the query.
As far as I can tell, there are two ways to do this:
1. Create a duplicate of every report (formatted with office grouping) so
that either the Company report version is opened OR the Office-grouped
report is opened
2. Create VB code so that when a report is opened, it is formatted on the
fly with Office grouping.
Option 1 would end up creating a LOT of extra work to maintain because
whenever a report has a field edited or added, we must make all of the same
changes to the grouped report as well
Option 2 seems easier to maintain, but might be much more complicated to
setup.
Does anyone have a thought of either how to do this or whether Option1 or
Option 2 is a better solution?
-Stephen
.
- Follow-Ups:
- RE: change grouping on the fly
- From: Jeff C
- RE: change grouping on the fly
- Prev by Date: Re: Calculating Difference In Time For Age
- Next by Date: Re: Calculating Difference In Time For Age
- Previous by thread: Web front end for Access reports
- Next by thread: RE: change grouping on the fly
- Index(es):
Relevant Pages
|
