There is no straightforward way of telling the Report engine that you
only want the first page of each section, though you could probably do
it in code. However, if you are really only interested in seeing the
most imminent tasks, it should be relatively easy to modify your
source query so that it only reports tasks to be started within the
next n days, n weeks, or whatever, and adjust n so that it results in
the reported tasks for most or all jobs fitting on a single page.
Using a rather more complex query/subquery structure for the source
Query, it should be possible to report on the most imminent n tasks
for each job. In the subquery, you would need to order tasks by start
date for each job and then select the "TOP n" tasks. I believe that
this is possible, but it is not something I have ever had to do.
I have a number of jobs that each have a from 50 to 200 tasks that happen on
different dates.
I am getting 2 to 3 pages for each job because there are anywhere from 50 to
200 tasks for each job. I have set a page break before each group heading
(grouping on jobs) so that I have separate multi page reports for each job.
The tasks are set in order of ascending chronology. I am not interested in
all the tasks, only those in the most immediate future so I would like to
limit each job report to 1 page. I am now doing this by selecting only the
pages for printing that are the first page of each job. This takes numerous
print jobs. Is there a way to limit the printing to only the first page of
each job so that I only have one print job?
I suppose I could print the entire report and throw away all the unwanted
pages but that is a rather inelegant solution.
Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
