keeping detail together

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.
 
A

akphidelt

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.
 
A

akphidelt

Im so used to employees that I said employees, for you it is probably
patients... sorry!
 
K

KateB

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!
 
K

KateB

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top