1
|
def temp-table person field id as integer
|
2
|
field name as char
|
3
|
field city as char
|
4
|
field street as char.
|
5
|
|
6
|
create person. assign city = "Berne" id = 22 name = "Bill Otto" street = "250 - 20th Ave.".
|
7
|
create person. assign city = "Berne" id = 9 name = "James Schneider" street = "277 Seventh Av.".
|
8
|
create person. assign city = "Boston" id = 32 name = "Michael Ott" street = "339 College Av.".
|
9
|
create person. assign city = "Boston" id = 23 name = "Mary Karsen" street = "412 College Av.".
|
10
|
create person. assign city = "Chicago" id = 39 name = "George Karsen" street = " Upland Pl..".
|
11
|
create person. assign city = "Chicago" id = 35 name = "Julia White" street = "412 Upland Pl.".
|
12
|
create person. assign city = "Chicago" id = 11 name = "Janet Fuller" street = "445 Upland Pl.".
|
13
|
create person. assign city = "Dallas" id = 47 name = "Susanne Smith" street = "2 Upland Pl.".
|
14
|
create person. assign city = "Dallas" id = 43 name = "Susanne Miller" street = "96 College Av.".
|
15
|
create person. assign city = "Dallas" id = 40 name = "John Steel" street = "32 College Av.".
|
16
|
create person. assign city = "Dallas" id = 54 name = "Michael Clancy" street = "18 Seventh Av.".
|
17
|
create person. assign city = "Dallas" id = 11 name = "Susanne Heiniger" street = "440 - 20th Ave.".
|
18
|
create person. assign city = "Dallas" id = 7 name = "Anne Fuller" street = "276 Upland Pl.".
|
19
|
create person. assign city = "Dallas" id = 25 name = "Sylvia Ringer" street = "19 Seventh Av.".
|
20
|
create person. assign city = "Dallas" id = 18 name = "Laura Steel" street = "86 - 20th Ave.".
|
21
|
create person. assign city = "Dallas" id = 5 name = "Andrew Heiniger" street = "135 Upland Pl.".
|
22
|
create person. assign city = "Lyon" id = 7 name = "Susanne White" street = "429 Seventh Av.".
|
23
|
create person. assign city = "Lyon" id = 2 name = "Laura Ott" street = "74 - 20th Ave.".
|
24
|
create person. assign city = "Lyon" id = 94 name = "Anne Miller" street = "443 Seventh Av.".
|
25
|
create person. assign city = "Lyon" id = 33 name = "Andrew May" street = "20 Upland Pl.".
|
26
|
create person. assign city = "New York" id = 71 name = "Sylvia Ott" street = "172 Seventh Av.".
|
27
|
create person. assign city = "New York" id = 12 name = "Bill King" street = "546 College Av.".
|
28
|
create person. assign city = "New York" id = 5 name = "Janet May" street = "396 Seventh Av.".
|
29
|
create person. assign city = "Oslo" id = 29 name = "Robert Ott" street = "503 Seventh Av.".
|
30
|
create person. assign city = "Oslo" id = 19 name = "Sylvia Steel" street = "269 College Av.".
|
31
|
create person. assign city = "Paris" id = 62 name = "Sylvia Fuller" street = "294 Seventh Av.".
|
32
|
create person. assign city = "Paris" id = 25 name = "Laura Miller" street = "549 Seventh Av.".
|
33
|
create person. assign city = "Paris" id = 26 name = "Robert White" street = "158 - 20th Ave.".
|
34
|
create person. assign city = "San Francisco" id = 31 name = "James Peterson" street = "49 Seventh Av.".
|
35
|
create person. assign city = "San Francisco" id = 17 name = "Robert Gampthon" street = "231 Upland Pl.".
|
36
|
|
37
|
|
38
|
open query q for each person.
|
39
|
|
40
|
def var rpt as handle.
|
41
|
create report rpt.
|
42
|
rpt:report-query = query q:handle.
|
43
|
rpt:report-design = "AddressReport.jrxml".
|
44
|
rpt:set-report-param("ReportTitle", "Address Report").
|
45
|
rpt:export-report-pdf("AddressReport.pdf").
|