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
|
field data as char.
|
6
|
|
7
|
create person. assign city = "Berne" id = 22 name = "Bill Otto" street = "250 - 20th Ave." data = "Lorem ipsum".
|
8
|
create person. assign city = "Berne" id = 9 name = "James Schneider" street = "277 Seventh Av." data = "Lorem ipsum dolor".
|
9
|
create person. assign city = "Boston" id = 32 name = "Michael Ott" street = "339 College Av." data = "Lorem ipsum dolor sit amet".
|
10
|
create person. assign city = "Boston" id = 23 name = "Mary Karsen" street = "412 College Av." data = "Lorem ipsum dolor sit amet, consectetur adipiscing".
|
11
|
create person. assign city = "Chicago" id = 39 name = "George Karsen" street = " Upland Pl.." data = "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do".
|
12
|
create person. assign city = "Chicago" id = 35 name = "Julia White" street = "412 Upland Pl." data = "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt".
|
13
|
create person. assign city = "Chicago" id = 11 name = "Janet Fuller" street = "445 Upland Pl." data = "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt".
|
14
|
|
15
|
create person. assign city = "Vancouver" id = 1 name = "James Gallahan" street = "13 - 20th Ave." data = "Lorem ipsum".
|
16
|
create person. assign city = "Vancouver" id = 2 name = "Romy Swartz" street = "25 Seventh Av." data = "Lorem ipsum".
|
17
|
create person. assign city = "Vancouver" id = 86 name = "Keanu Rollings" street = "66 College Av." data = "Lorem ipsum".
|
18
|
create person. assign city = "Vancouver" id = 90 name = "Amy Bowden" street = "777 - 20th Ave." data = "Lorem ipsum".
|
19
|
create person. assign city = "Vancouver" id = 55 name = "Casey Livert" street = "81 Seventh Av." data = "Lorem ipsum".
|
20
|
create person. assign city = "Vancouver" id = 13 name = "Victoria Adams" street = "350 College Av." data = "Lorem ipsum".
|
21
|
create person. assign city = "Vancouver" id = 52 name = "Maria Lovely" street = "23 Seventh Av." data = "Lorem ipsum".
|
22
|
create person. assign city = "Vancouver" id = 11 name = "John Vaguant" street = "25 College Av." data = "Lorem ipsum".
|
23
|
create person. assign city = "Vancouver" id = 53 name = "Missy Grey" street = "123 Seventh Av." data = "Lorem ipsum".
|
24
|
create person. assign city = "Vancouver" id = 111 name = "Kim Nun" street = "125 College Av." data = "Lorem ipsum".
|
25
|
create person. assign city = "Vancouver" id = 5 name = "Johnathan Jiss" street = "3 Seventh Av." data = "Lorem ipsum".
|
26
|
create person. assign city = "Vancouver" id = 7 name = "Jessy James" street = "22 College Av." data = "Lorem ipsum".
|
27
|
|
28
|
|
29
|
|
30
|
open query q for each person.
|
31
|
|
32
|
def var rpt as handle.
|
33
|
create report rpt.
|
34
|
rpt:report-data-source = query q:handle.
|
35
|
rpt:report-design = "ReportFormatting.jrxml".
|
36
|
rpt:set-report-param("ReportTitle", "Report Formatting Test").
|
37
|
rpt:export-report-xls("ReportFormatting.xls").
|