if file('date_day.dbf')
// drop table date_day
endif
if not file('date_day.dbf')
create table date_day (id autoinc,ddate date)
use date_day
generate 10
use
endif
** END HEADER -- do not remove this line
//
// Generated on 2016/05/21
//
local r
r = new DATE_DAYREPORT()
r.render()
class DATE_DAYREPORT of REPORT
with (this)
autoSort = false
endwith
this.DATE_DAY1 = new QUERY(this)
with (this.DATE_DAY1)
left = 75.0
top = 4815.0
sql = 'select * from "date_day.DBF"'
requestLive = false
active = true
endwith
this.STREAMSOURCE1 = new STREAMSOURCE(this)
with (this.STREAMSOURCE1.detailBand)
height = 1350.0
endwith
this.STREAMSOURCE1.detailBand.TITLETEXTID1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TITLETEXTID1)
canRender = {||this.parent.firstOnFrame}
height = 300.0
left = 1425.0
top = 50.0
width = 1170.0
prefixEnable = false
alignHorizontal = 2 // Right
suppressIfBlank = true
text = "
Id
"
endwith
this.STREAMSOURCE1.detailBand.TEXTID1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTID1)
height = 293.0
left = 1455.0
top = 403.0
width = 1170.0
variableHeight = true
prefixEnable = false
alignHorizontal = 2 // Right
text = {||this.form.date_day1.rowset.fields["id"].value}
endwith
this.STREAMSOURCE1.detailBand.TITLETEXTDDATE1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TITLETEXTDDATE1)
canRender = {||this.parent.firstOnFrame}
height = 300.0
left = 4050.0
top = 5.0
width = 1080.0
prefixEnable = false
suppressIfBlank = true
text = "Ddate
"
endwith
this.STREAMSOURCE1.detailBand.TEXTDDATE1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTDDATE1)
height = 293.0
left = 4080.0
top = 403.0
width = 1080.0
variableHeight = true
prefixEnable = false
text = {||this.form.date_day1.rowset.fields["ddate"].value}
endwith
this.STREAMSOURCE1.detailBand.TEXT1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXT1)
canRender = class::TEXT1_CANRENDER
height = 300.0
left = 4080.0
top = 825.0
width = 1080.0
prefixEnable = false
text = "Text1"
endwith
this.PAGETEMPLATE1 = new PAGETEMPLATE(this)
with (this.PAGETEMPLATE1)
height = 16837.0
width = 11905.0
marginTop = 1080.0
marginLeft = 1080.0
marginBottom = 1080.0
marginRight = 1080.0
gridLineWidth = 0
endwith
this.PAGETEMPLATE1.STREAMFRAME1 = new STREAMFRAME(this.PAGETEMPLATE1)
with (this.PAGETEMPLATE1.STREAMFRAME1)
height = 11592.0
left = 360.0
top = 1365.0
width = 9360.0
form.STREAMFRAME1 = form.pagetemplate1.streamframe1
endwith
with (this.printer)
duplex = 1 // None
orientation = 1 // Portrait
paperSource = 7
paperSize = 9
resolution = 3 // Medium
color = 2 // Color
trueTypeFonts = 1 // Bitmap
endwith
with (this.reportGroup.footerBand)
height = 250.0
endwith
with (this.reportGroup.headerBand)
height = 250.0
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.date_day1.rowset
function TEXT1_canRender()
this.text = cdow(this.parent.textddate1.text())
return true
endclass