Subject Re: EQ of XBase TOTAL Command
From Akshat Kapoor <akshat.kapoor@kapoorsons.in>
Date Wed, 9 Aug 2017 16:03:26 +0530
Newsgroups dbase.getting-started
Attachment(s) company2.DBFtemp.repUntitled.png

On 09/08/2017 00:24, Mustansir Ghor wrote:
> Dear Akshat
>
> Thank you. I am getting some feeling for the flow of commands. This means we design a form and get dates in entryfields. Then create process Pushbutton to process the data and bring same on screen. Then create print pushbutton to print the same. How can we see the report on screen before we print.
>
> Best Regards
> Mustansir
>

Hi Mustansir,
Sorry for the late reply,
Please run the attached report.
simply use the command
do temp.rep
and you should see a preview of the report.

I have highlighted the setting required to achieve this preview in
attached screenshot.

When the report is developed I change the setting from default to printer

Regards
Akshat



** END HEADER -- do not remove this line
//
// Generated on 09.08.2017
//
local r
r = new tempReport()
r.render()

class tempReport of REPORT
   with (this)
      autoSort = false
   endwith

   this.COMPANY1 = new QUERY(this)
   with (this.COMPANY1)
      left = 2265.0
      top = 705.0
      width = 360.0
      height = 360.0
      sql = 'select * from "company2.DBF"'
      requestLive = false
      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.STREAMSOURCE1 = new STREAMSOURCE(this)
   with (this.STREAMSOURCE1.detailBand)
      height = 250.0
   endwith

   this.STREAMSOURCE1.detailBand.TEXTCOMPANY1 = new TEXT(this.STREAMSOURCE1.detailBand)
   with (this.STREAMSOURCE1.detailBand.TEXTCOMPANY1)
      height = 300.0
      left = 345.0
      top = 50.0
      width = 3780.0
      variableHeight = true
      prefixEnable = false
      text = {||this.form.company1.rowset.fields["company"].value}
   endwith

   with (this.printer)
      duplex = 1        // None
      orientation = 1        // Portrait
      paperSource = 7
      paperSize = 9
      resolution = 0        // Default
      color = 1        // Monochrome
      trueTypeFonts = 0        // Default
   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.company1.rowset

endclass