Specialized Column Breaks

  • Thread starter Thread starter Pendragon
  • Start date Start date
P

Pendragon

Access03/WinXP

I have a report which is a schedule of events for a series of meeting rooms,
set out in a grid format. I need to be very specific in where a column
breaks and how.

Data examples:

Room 1 has a set of time blocks, Blocks 1-15
Room 2 Blocks 1-6
Room 3 Blocks 1-8
Rooms 4-7 Blocks 1-20
and so forth

I can get a ten by ten grid on a page, each "cell" representing a block.
The rooms are sequential across the page; the time slots going down the page.

The format needs to be something like this:
on page 1.....
Column 1 prints only Room 1, Blocks 1-10
Column 2 prints only Room 2, Blocks 1-6 and then blank space
Column 3 prints only Room 3, Blocks 1-8 and then blank space
Columns 4-7 print the respective rooms and only Blocks 1-10

on page 2....
Column 1 prints only Room 1, Blocks 11-15
Columns 2 & 3 are blank OR (if not possible to do this), print Columns 4-7,
Blocks 11-20

I can set column breaks after each grouping (by room) - this works well to
start Room 2, 3 & 4 on a new column. What happens, though, is that the all
Blocks greater than 10 spill over into a new column, so Column 1 prints Room
1 Blocks 1-10 and then Column 2 begins with the remainder of Column 1.

Is there a way limit sections/groups of records to print on a page and then
continue onto the next as I've set out above? Any suggestions?

Thanks in advance!
 
If your blocks are numbered then use Sorting And Grouping to force new page
for block >10.
 
Hi,

Not sure if this will do what you want. It is untested. If I
understand correctly, you have seven rooms and you want their information to
print down the page and spill over where appropriate onto succeeding pages,
remaining in their appropriate columns. If that is the case make your main
report an unbound report (no record source). Create a subreport that prints
one room only. Add that subreport to your main report seven times, as the
seven columns. In the master and child linking properties link your room
number to the appropriate constant value (1, 2, etc.). If that does not
allow for constant values, create a table with seven fields, Room1, Room2,
etc. Add one row to it placing 1 in Room1, 2 in Room2, etc. Use that as the
main report's record source and use the appropriate Room1, etc. as the master
link fields.

There may well be better ways.

Hope that helps,

Clifford Bass
 
Back
Top