Formatting report

[ncub]

I have a table with 6 fields : Class_code, Name, Birth, Sex, Address and Phone.


And I need to generate a report where 3 fields at the top of page and 2 field are at the bottom of the same page.

This report grouped by Class_code where a group may have more than 5 records, but I want the report view 5 records per page.

Any simple way to do this with Access 2007 ?

[ranman256]

In rpt design, click Grouping/sort. Insert CLASS. Turn on header and footer.
In the header put the Class field.
Click the tools, make them visible
in the footer grab the pageBreak icon and drag it into the footer.

you may need to review in the Access report help. Or Google.

[ncub]

But I need to format the report page as in the picture, not only grouping the records.

3 fields on top of page, and the rest 2 fields on the bottom of the same page.

In rpt design, click Grouping/sort. Insert CLASS. Turn on header and footer.
In the header put the Class field.
Click the tools, make them visible
in the footer grab the pageBreak icon and drag it into the footer.

you may need to review in the Access report help. Or Google.

[June7]

Odd arrangement. Why would you want the address and phone separated from the name?

Might require subreport(s).

[ncub]

It's only a simple example.
The real one have many field that will not fit even in landscape mode, and the user want them printed on the same page to make it easy to read.

Odd arrangement. Why would you want the address and phone separated from the name?

Might require subreport(s).

[June7]

Same comment about subreport(s) applies.

I have faced this same issue. I ended up making the report display the data for each record on multiple 'lines'. I arranged the texboxes in staggered arrangement above each other and the labels in header the same staggered arrangement.

[ncub]

Try to use subreport.

Main report fields : Name, Birth, Sex
Subreport fields : Address, Phone

Subreport placed in Page footer. Both report linked and grouped by Class_code.

Then add some codes in main report property :

Dim RecPerPage As Integer


Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
'Reset record per page for each group
    RecPerPage = 1
End Sub


Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
'Set max record per page = 5
    If RecPerPage = 5 Then
        Reports![Main_Report].Section(acDetail).ForceNewPage = 1
        RecPerPage = 0
    Else
        Reports![Main_Report].Section(acDetail).ForceNewPage = 0
    End If
    RecPerPage = RecPerPage + 1
End Sub

The field arrangement works perfectly with limited record per page in main report, but I can't limit the record in each subreport page.

For example, if a Class_Code has 12 records, the first N records will be repeated in every page. Where N depends on how many line will fit in the height of the page footer.


Still need some help on how to limit record in subreport....

[ncub]

no hope.....