I have a table which includes some following fields:
section - char 2
street # - num 4
street addr - cha 36
last name - char 30
first name - char 25
Phone - 9
Rents to - char 35
The file is sequenced Street # within Streen Name within Section
I'd like to produce a report that breaks on Section and Street
---------------------------------------------------
Report Header would look something like this:
_________________________________________________________________
Street Brakembury Ct. Section 1 <-- Report Header
_________________________________________________________________
Street # Owner of record Rents to Phone <--Det Heading
-----------------------------------------------------------------
8 Joe Boombotts Mary xxx-xx-xxxx <--Det Print Ln
9 Mary Abbot Simon xxx-xx-xxxx
14 Able Jones Paul xxx-xx-xxxx
Number of Brankbury Ct. Records = 3 <-- Break
On a street break and or Street/Section Break, new Page
Report Header would look something like this:
_________________________________________________________________
Street Georgetown Rd Section 1 <-- Report Header
_________________________________________________________________
Street # Owner of record Rents to Phone <--Det Heading
-----------------------------------------------------------------
101 Mark Rush Sue xxx-xx-xxxx <--Det Print Ln
109 Sam Adams Sara xxx-xx-xxxx
114 Pete Love Mike xxx-xx-xxxx
Number of Georgetown records = 3 <-- Break
and so on...
Section 2 would come next with a new street and the format would be the same as above.
Can someone please advise me on this? I've spent an enormous amount of time on this and I'm sure one of you experts could solve this in a minute or two.
I'd also like to be able to count the number of records per Street Name / Section.
Please help.
Thanks,
Rudy
section - char 2
street # - num 4
street addr - cha 36
last name - char 30
first name - char 25
Phone - 9
Rents to - char 35
The file is sequenced Street # within Streen Name within Section
I'd like to produce a report that breaks on Section and Street
---------------------------------------------------
Report Header would look something like this:
_________________________________________________________________
Street Brakembury Ct. Section 1 <-- Report Header
_________________________________________________________________
Street # Owner of record Rents to Phone <--Det Heading
-----------------------------------------------------------------
8 Joe Boombotts Mary xxx-xx-xxxx <--Det Print Ln
9 Mary Abbot Simon xxx-xx-xxxx
14 Able Jones Paul xxx-xx-xxxx
Number of Brankbury Ct. Records = 3 <-- Break
On a street break and or Street/Section Break, new Page
Report Header would look something like this:
_________________________________________________________________
Street Georgetown Rd Section 1 <-- Report Header
_________________________________________________________________
Street # Owner of record Rents to Phone <--Det Heading
-----------------------------------------------------------------
101 Mark Rush Sue xxx-xx-xxxx <--Det Print Ln
109 Sam Adams Sara xxx-xx-xxxx
114 Pete Love Mike xxx-xx-xxxx
Number of Georgetown records = 3 <-- Break
and so on...
Section 2 would come next with a new street and the format would be the same as above.
Can someone please advise me on this? I've spent an enormous amount of time on this and I'm sure one of you experts could solve this in a minute or two.
I'd also like to be able to count the number of records per Street Name / Section.
Please help.
Thanks,
Rudy
Comment