keeping detail together

  • Thread starter Thread starter KateB
  • Start date Start date
K

KateB

I have a report that pulls results for patients. What I need is for each
patient to have their own page which works OK, but if a patient has more than
one result in a week I want it to be on one page. The report is set up to be
a fax sheet to send out to doctors practices. Each practice may have more
than one patient but these have to be on individual pages. Currently these
are coming out separately meaning some practices getting 6 fax pages for one
patient. How can I make it group? I hope this is enough information.
 
You are probably starting a new page after the detail section. Click the
grouping button which is the weird button with brackets and two = signs. Then
create an Employee grouping. On that where it says Group Footer... change
that from No to Yes.

Then on the report, right click on the Group Footer, go to properties, and
change that to force new page: "After Section".

This will allow as much detail of the single employee on each page. Hope
this helps.
 
Im so used to employees that I said employees, for you it is probably
patients... sorry!
 
I tried this and it gave me a blank page after each patient, but they still
have individual pages for each result. I have grouping for the practice code
(as a header) and grouping by patient surname. Its probably something really
simple that I just don't realise I've done so I'll keep trying, but if anyone
has any other suggestions I'd be happy to try them!
 
I've discovered that the reason they won't stay on one page is because I have
a text box in the same section that was making each result half a page. I
moved that to the footer, followed your instructions and it works perfectly.
Many thanks for your help.
 
Back
Top