| Frank J. Polan 2006-11-27, 7:13 pm |
| Michel
Copy the following to a file & run from the navigator. It will display
the fields from both the active table and the 1 line table.,
Check the code to see if there's anything obviously different in your
report.
HTH
Frank Polan
..........................Michel.rep .................................
/* use this to create tables for turnkey */
/////////////// test.wfm ////////////////
close databases
close all
clear all
release all
clear memory
clear program
set proc to
//
if file('test.dbf')
drop table 'test.dbf'
endif
create table 'test.dbf' ( ;
field1 char (10), ;
field2 char (10) ;
)
insert into test (field1, field2) values ('abc', 'def')
insert into test (field1, field2) values ('ghi', 'jkl')
insert into test (field1, field2) values ('mno', 'pqr')
//
if file('testA.dbf')
drop table 'testA.dbf'
endif
create table 'testA.dbf' ( ;
field1 char (25), ;
field2 char (25) ;
)
insert into testA (field1, field2) values ('Static Table Field1',
'Static Table Field2')
//
** END HEADER -- do not remove this line
//
// Generated on 11/27/2006
//
local r
r = new michelReport()
r.render()
class michelReport of REPORT
with (this)
metric = 3 // Inches
autoSort = false
endwith
this.TEST1 = new QUERY()
this.TEST1.parent = this
with (this.TEST1)
left = 1.7604
top = 5.1563
sql = 'select * from "test.dbf"'
requestLive = false
active = true
endwith
this.TESTA1 = new QUERY()
this.TESTA1.parent = this
with (this.TESTA1)
left = 3.6667
top = 5.3646
sql = 'select * from "testA.dbf"'
requestLive = false
active = true
endwith
this.PAGETEMPLATE1 = new PAGETEMPLATE(this)
with (this.PAGETEMPLATE1)
height = 11.0
width = 8.5
marginTop = 0.75
marginLeft = 0.7604
marginBottom = 0.75
marginRight = 0.7396
gridLineWidth = 0
endwith
this.PAGETEMPLATE1.STREAMFRAME1 = new
STREAMFRAME(this.PAGETEMPLATE1)
with (this.PAGETEMPLATE1.STREAMFRAME1)
height = 4.0
left = 0.25
top = 0.9479
width = 6.5
form.STREAMFRAME1 = form.pagetemplate1.streamframe1
endwith
this.PAGETEMPLATE1.TEXT1 = new TEXT(this.PAGETEMPLATE1)
with (this.PAGETEMPLATE1.TEXT1)
height = 0.2083
left = 2.8125
top = 0.1979
width = 1.3021
prefixEnable = false
text = "Michel"
form.TEXT1 = form.pagetemplate1.text1
endwith
this.PAGETEMPLATE1.TEXTFIELD11 = new TEXT(this.PAGETEMPLATE1)
with (this.PAGETEMPLATE1.TEXTFIELD11)
height = 0.2083
left = 1.0833
top = 5.2188
width = 1.5104
variableHeight = true
prefixEnable = false
text = {||this.form.testa1.rowset.fields["field1"].value}
form.TEXTFIELD11 = form.pagetemplate1.textfield11
endwith
this.PAGETEMPLATE1.TEXTFIELD21 = new TEXT(this.PAGETEMPLATE1)
with (this.PAGETEMPLATE1.TEXTFIELD21)
height = 0.2083
left = 2.75
top = 5.1771
width = 1.7188
variableHeight = true
prefixEnable = false
text = {||this.form.testa1.rowset.fields["field2"].value}
form.TEXTFIELD21 = form.pagetemplate1.textfield21
endwith
this.STREAMSOURCE1 = new STREAMSOURCE(this)
with (this.STREAMSOURCE1.detailBand)
height = 0.1736
endwith
this.STREAMSOURCE1.detailBand.TITLETEXTFIELD1 = new
TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TITLETEXTFIELD1)
canRender = {||this.parent.firstOnFrame}
height = 0.2083
left = 0.2813
top = 0.0313
width = 0.75
prefixEnable = false
suppressIfBlank = true
text = "<H3>Field1</H3>"
endwith
this.STREAMSOURCE1.detailBand.TEXTFIELD11 = new
TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTFIELD11)
height = 0.2083
left = 0.2813
top = 0.2396
width = 0.75
variableHeight = true
prefixEnable = false
text = {||this.form.test1.rowset.fields["field1"].value}
endwith
this.STREAMSOURCE1.detailBand.TITLETEXTFIELD2 = new
TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TITLETEXTFIELD2)
canRender = {||this.parent.firstOnFrame}
height = 0.2083
left = 1.5208
top = 0.0521
width = 0.75
prefixEnable = false
suppressIfBlank = true
text = "<H3>Field2</H3>"
endwith
this.STREAMSOURCE1.detailBand.TEXTFIELD21 = new
TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTFIELD21)
height = 0.2083
left = 1.5208
top = 0.2604
width = 0.75
variableHeight = true
prefixEnable = false
text = {||this.form.test1.rowset.fields["field2"].value}
endwith
with (this.printer)
duplex = 1 // None
orientation = 1 // Portrait
paperSource = 15
paperSize = 1
resolution = 0 // Default
color = 1 // Monochrome
trueTypeFonts = 3 // Substitute
endwith
with (this.reportGroup.headerBand)
height = 0.1736
endwith
with (this.reportGroup.footerBand)
height = 0.1736
endwith
this.firstPageTemplate = this.form.pagetemplate1
this.form.pagetemplate1.nextPageTemplate = this.form.pagetemplate1
this.form.pagetemplate1.streamframe1.streamSource =
this.form.streamsource1
this.form.streamsource1.rowset = this.form.test1.rowset
endclass
On Mon, 27 Nov 2006 06:10:43 -0500, Michel PAIN <michel.pain@free.fr>
wrote:
>Second part of my problems
>
>in the PageTemplate I'm not able to include Fields
>- from a static table (parameters all defined in a single row)
>I can drag them from the palette to the template
>but they don't print on the report ???
>What's the mistake ???
>thanks for help
|