** END HEADER -- do not remove this line // // Generated on 2023-10-31 // local r r = new a_date_testReport() r.render() class a_date_testReport of REPORT with (this) autoSort = false endwith this.DBASESAMPLES1 = new DATABASE(this) with (this.DBASESAMPLES1) left = 8415.0 top = 555.0 width = 360.0 height = 360.0 databaseName = "DBASESAMPLES" active = true endwith this.ORDERS1 = new QUERY() this.ORDERS1.parent = this with (this.ORDERS1) left = 2220.0 top = 450.0 width = 360.0 height = 360.0 database = form.form.dbasesamples1 sql = "select * from orders where orderdate between :fdat1 and :tdat1 order by orderdate" requestLive = false params["fdat1"] = {2001-01-01} params["tdat1"] = {2001-02-28} active = true 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 this.PAGETEMPLATE1.TEXT1 = new TEXT(this.PAGETEMPLATE1) with (this.PAGETEMPLATE1.TEXT1) height = 555.0 left = 1200.0 top = 480.0 width = 4740.0 prefixEnable = false fontSize = 14.0 text = "January 2001 to February 2001" form.TEXT1 = form.pagetemplate1.text1 endwith this.STREAMSOURCE1 = new STREAMSOURCE(this) with (this.STREAMSOURCE1.detailBand) height = 250.0 endwith this.STREAMSOURCE1.detailBand.TEXTCUSTOMERID1 = new TEXT(this.STREAMSOURCE1.detailBand) with (this.STREAMSOURCE1.detailBand.TEXTCUSTOMERID1) height = 300.0 left = 465.0 top = 80.0 width = 1170.0 variableHeight = true prefixEnable = false alignHorizontal = 2 // Right text = {||this.form.orders1.rowset.fields["customerid"].value} endwith this.STREAMSOURCE1.detailBand.TEXTORDERDATE1 = new TEXT(this.STREAMSOURCE1.detailBand) with (this.STREAMSOURCE1.detailBand.TEXTORDERDATE1) height = 300.0 left = 2880.0 top = 110.0 width = 1080.0 variableHeight = true prefixEnable = false text = {||this.form.orders1.rowset.fields["orderdate"].value} 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.orders1.rowset endclass