Multi-column Report, How????

[wrek]

Hi, this is such a simple report....or so it seems

Two tables:

Table1 Fields - Group, Group Description
Table2 Fields - Group, Equipment, Status

I have two problems really:

1) This report is potentially huge (35,000+ records). How do I spill over?

For example, if Group is the Header, A is Equipment and 1 is the Status. On each page is it possible to show the columns more than once, so in effect I can halve the size of the report?

A1 A2 E1 E2
B1 B2 F1 F2
C1 C2 G1 G2
D1 D2


2) Is it good report practice to put the Table2 data in a subreport, as opposed to the Detail of the Main Report? In this case, if the subrpt spanned more than a page, how would I get the header to repeat for every page?


Thanks,

(I hate reports - searching for enlightenment)

 

[wrek]

Ignore me guys...

After a lot of searching I figured out the way you 'snake' reports, as they call it, is through the Page Setup, Columns Tab...

You can display reports in telephone-directory format

If anyone's interested the Solutions.mdb Sample database, displays this in the Report "ShippingLog"

 

[wrek]

Also, I found this pretty cool function, to suffix the word "Continued" to any header that is being repeated at the top of a page for instance...here is the code (I would cite the source, but unfortunately I lost the link where I 'borrowed' it from)


Private Sub GroupHeader0_Print(Cancel As Integer, PrintCount As Integer)
Static strPreviousName As String

If Me.Group = strPreviousName Then
txtFGName = Me.Group & " (cont'd)"
Else
txtFGName = Me.Group
End If

strPreviousName = Me.Group
End Sub

Two things to note:
1) Set the repeating label to visible=No
2) Add an unbound textbox (in my case 'txtFGName') to display in place of the repeating label

*this would work for any header*