I have a report that consists of a table containing invoices grouped by
Customer. I'd like to keep all invoices for any given customer on the same
page, but without needing a page break after each customer (each page can fit
about 12 or so groups on it).
Does anyone know how to do this?
I found a thread dated 5/20/2005 called "Control Page Breaking in Detail
(Keep Together)". I think some of the people on that thread are also trying
to do what I want to do.
I tried the method suggested by Matt Temple at the end of the thread, but
this did not have the desired effect. This method resulted in keeping each
group on the same page BUT meant that only the first invoice for each
customer was displayed.
Any ideas?
Thanks,
RobRight, I had another go at Matt's suggestion (included below for convenience)
from the other thread. I was doing step 7 wrong. I've now redone it and am
getting closer, but still without the effect I need.
The instructions ensure that all the detail elements within a group are kept
on the same page, but sometimes the group header is shown at the bottom of
the previous page instead of with the detail elements.
My next step was to edit the Grouping and Sorting Properties of the group to
add a check next to "Repeat group header". This ensures that when a block of
detail elements are kept together by taking them to the next page, the group
header is repeated with them. However, I'm still left with a copy of the
group header at the bottom of the previous page.
I can't be the only person who's wanted to do this. Can anyone help?
______________________________________
Instructions to keep group elements together:
1) Right-click border of table containing the elements
2) Select "Properties"
3) Go to the "General" tab, if not already displayed
4) Place a check in the "Fit table on one page if possible" checkbox
5) Go to the "Groups" tab
6) Click on the "Details grouping..." button
7) Select the elements which comprise of the detail group you want to keep
together
8) Click "OK"
9) Click "OK" again
10) Test the modified design
"Rob Nelder" wrote:
> I have a report that consists of a table containing invoices grouped by
> Customer. I'd like to keep all invoices for any given customer on the same
> page, but without needing a page break after each customer (each page can fit
> about 12 or so groups on it).
> Does anyone know how to do this?
> I found a thread dated 5/20/2005 called "Control Page Breaking in Detail
> (Keep Together)". I think some of the people on that thread are also trying
> to do what I want to do.
> I tried the method suggested by Matt Temple at the end of the thread, but
> this did not have the desired effect. This method resulted in keeping each
> group on the same page BUT meant that only the first invoice for each
> customer was displayed.
> Any ideas?
> Thanks,
> Rob
No comments:
Post a Comment