dividing a report into four sections

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

Hey all,

I am having trouble formatting my report for a video library i am trying to
automate into a database. I can get the report to do everything i need but
the report will only format in two columns with each new entry at the start
of a new column like so:

|----------|----------|
| | |
| 1 | 2 |
| | |
| | |
| | |
| | |
| | |
|----------|----------|

Is it possible for me to format access to allow four sections on each page
like so:

|----------|----------|
| | |
| 1 | 3 |
| | |
|----------|----------|
| | |
| 2 | 4 |
| | |
|----------|----------|

as this would shrink my 100 page report in half, also it safes a massive
waste of white space as each tape only has a few entries on it

any help is greatly appreciated.

Thanks!
 
Hey again,

Sorry i wasn't being very specific. I apologise. Yes, I enabled a column
break 'before section' on my grouping by 'tape' parameter. I used this
because it was the only i could think of to collate the individual entries
by what tape they belonged to. I want the new tape headers to appear at
specific spots on the page. Looking below at my *dodgy* diagram, i want the
tape number to appear at the top of each 'section' making the page only
display four records at a time - no matter how many entries are tied to that
particular tape. Is this possible? and if so could someone help me? thanks.

Tom
 
tom said:
Sorry i wasn't being very specific. I apologise. Yes, I enabled a column
break 'before section' on my grouping by 'tape' parameter. I used this
because it was the only i could think of to collate the individual entries
by what tape they belonged to. I want the new tape headers to appear at
specific spots on the page. Looking below at my *dodgy* diagram, i want the
tape number to appear at the top of each 'section' making the page only
display four records at a time - no matter how many entries are tied to that
particular tape. Is this possible? and if so could someone help me?
Click to expand...

If I understand what you want, I think maybe you might want
to set the tape group header section's ForceNewPage property
to Before Section. This will make sure each tape starts on
a new page.

The detail section with the entries should have KeepTogether
set to Yes and the NewRowOrColumn set to None. Its Height
should be a little less than half the paper height less
margins with CanGrow set to No (individual detail text boxes
can have their CanGrow set to Yes). These KeepTogether and
size settings will allow two, but not three details in a
column.
 
Back
Top