Subject Re: Is there a limit for # of fields in IF statement
From Ruth Bromer <ruth@treklite.com>
Date Mon, 8 Jul 2019 22:21:02 -0400
Newsgroups dbase.getting-started
Attachment(s) Packet2.DBFpacket3.reopacket3.repPacket Report.pdf

I finally have a report, very close to what I want.  Maybe it's even done.

I've attached the report, table, and pdf. Ignore the extensions
(packet2, packet3).  When I'm completely satisfied, there will only be
one version.  I'm not ready to discard old versions yet.

Thanks for so much help.
Ruth

On 7/8/2019 4:09 PM, Ruth Bromer wrote:
> First of all, most of my messages are just for testing and will come out.
>
> I'm really confused now.  I don't have a tshirt.dbf.  (I might have but
> in the process of running and trying to debug your program, it no longer
> exists.)
>
> Anyway, the packet2.dbf should have everything I need with 1 record per
> competitor per shirt type ordered.  I created this with
> Create_packet_table2.prg.
>
> I started to write that I had problems.  Then I just ran the packet2.rep
> (renamed packet3.rpt so that I wouldn't loose the existing one) and it
> all of a sudden works.  Maybe it's because dBase crashed and then I
> restarted it.
>
> It's almost there.  Just making sure that I have all of the fields in
> place.  I like your functions to change 'Not Competing' to 'Yes' and
> 'No'. This is exactly what I wanted.
>
> Thank your so much, Mervyn.  Hopefully, I'm nearly done.  Then I can
> plug in the real data.
>
> ***
> By the way, dBase crashes multiple times a day.  This does not sound
> very robust.  Sometimes I have to reboot my computer to actually get it
> to close down.
> ***
>
> Ruth
>



** END HEADER -- do not remove this line
//
// Generated on 07/08/2019
//
local r
r = new PACKET2REPORT()
r.render()

class PACKET2REPORT of REPORT
   set procedure to :DUFLP:RepCntl.cc additive
   with (this)
      metric = 3        // Inches
      autoSort = false
   endwith

   this.TSHIRT1 = new QUERY(this)
   with (this.TSHIRT1)
      left = 6.0
      sql = 'select first||" "||last as fullname,t.* from packet2 t order by last,first'
      requestLive = false
      active = true
   endwith

   this.PAGETEMPLATE1 = new PAGETEMPLATE(this)
   with (this.PAGETEMPLATE1)
      height = 8.5
      width = 11.0
      marginTop = 0.2382
      marginLeft = 0.1444
      marginBottom = 0.2695
      marginRight = 0.2486
      gridLineWidth = 0
   endwith

   this.PAGETEMPLATE1.STREAMFRAME1 = new STREAMFRAME(this.PAGETEMPLATE1)
   with (this.PAGETEMPLATE1.STREAMFRAME1)
      height = 6.4687
      left = 0.1875
      top = 0.9792
      width = 4.9
      form.STREAMFRAME1 = form.pagetemplate1.streamframe1
   endwith

   this.PAGETEMPLATE1.STREAMFRAME2 = new STREAMFRAME(this.PAGETEMPLATE1)
   with (this.PAGETEMPLATE1.STREAMFRAME2)
      height = 6.4167
      left = 5.4
      top = 1.0
      width = 4.9
      form.STREAMFRAME2 = form.pagetemplate1.streamframe2
   endwith

   with (this.printer)
      duplex = 1        // None
      orientation = 2        // Landscape
      paperSource = 7
      paperSize = 1
      resolution = 3        // Medium
      color = 2        // Color
      trueTypeFonts = 1        // Bitmap
   endwith

   this.STREAMSOURCE1 = new STREAMSOURCE(this)
   this.STREAMSOURCE1.GROUP1 = new GROUP(this.STREAMSOURCE1)
   with (this.STREAMSOURCE1.GROUP1)
      groupBy = "fullname"
   endwith

   with (this.STREAMSOURCE1.GROUP1.footerBand)
      height = 0.3931
   endwith

   this.STREAMSOURCE1.GROUP1.footerBand.TEXTNOTES1 = new TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
   with (this.STREAMSOURCE1.GROUP1.footerBand.TEXTNOTES1)
      height = 0.2083
      left = 0.1251
      top = 0.1667
      width = 8.875
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["notes"].value}
   endwith

   with (this.STREAMSOURCE1.GROUP1.headerBand)
      height = 5.0
      beginNewFrame = true
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTFULLNAME1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTFULLNAME1)
      height = 0.2083
      left = 0.0938
      top = 0.0208
      width = 1.7396
      variableHeight = true
      prefixEnable = false
      fontSize = 12.0
      fontBold = true
      text = {||this.form.tshirt1.rowset.fields["fullname"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT2 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT2)
      height = 0.2083
      left = 0.2395
      top = 4.6458
      width = 1.5312
      prefixEnable = false
      text = "T-Shirts Ordered"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTFOXPRACCOURSE1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTFOXPRACCOURSE1)
      canRender = class::TEXTFOXPRACCOURSE1_CANRENDER
      onRender = class::TEXTFOXPRACCOURSE1_ONRENDER
      height = 0.2083
      left = 3.6979
      top = 1.0521
      width = 0.6875
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["foxpraccourse"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTM2PRACCOURSE1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTM2PRACCOURSE1)
      canRender = class::TEXTM2PRACCOURSE1_CANRENDER
      onRender = class::TEXTM2PRACCOURSE1_ONRENDER
      height = 0.2083
      left = 3.6979
      top = 2.0105
      width = 0.6875
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["m2praccourse"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTM80PRACCOURSE1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTM80PRACCOURSE1)
      canRender = class::TEXTM80PRACCOURSE1_CANRENDER
      onRender = class::TEXTM80PRACCOURSE1_ONRENDER
      height = 0.2083
      left = 3.6979
      top = 1.6979
      width = 0.6875
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["m80praccourse"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTSPRINTPRACCOURSE1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTSPRINTPRACCOURSE1)
      canRender = class::TEXTSPRINTPRACCOURSE1_CANRENDER
      onRender = class::TEXTSPRINTPRACCOURSE1_ONRENDER
      height = 0.2083
      left = 3.6979
      top = 2.3125
      width = 0.6875
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["sprintpraccourse"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT3 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT3)
      height = 0.2083
      left = 2.5208
      top = 1.0833
      width = 0.75
      prefixEnable = false
      text = "Fox practice"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT4 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT4)
      height = 0.2083
      left = 2.5417
      top = 2.0313
      width = 0.75
      prefixEnable = false
      text = "M2 practice"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT5 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT5)
      height = 0.2083
      left = 2.5417
      top = 1.6979
      width = 0.8854
      prefixEnable = false
      text = "M80 practice"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT6 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT6)
      height = 0.2083
      left = 2.5209
      top = 2.3125
      width = 0.9167
      prefixEnable = false
      text = "Sprint practice"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.LINE1 = new KMLINE(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.LINE1)
      left = 0.1875
      right = 4.625
      top = 2.6354
      bottom = 2.6354
      width = 2
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTBLINDPRACCOURSE1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTBLINDPRACCOURSE1)
      canRender = class::TEXTBLINDPRACCOURSE1_CANRENDER
      onRender = class::TEXTBLINDPRACCOURSE1_ONRENDER
      height = 0.2083
      left = 3.6979
      top = 1.3959
      width = 0.6875
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["blindpraccourse"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT7 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT7)
      height = 0.2083
      left = 2.5209
      top = 1.3855
      width = 0.9167
      prefixEnable = false
      text = "Blind practice"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.USCHAMPLABEL = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.USCHAMPLABEL)
      height = 0.1771
      left = 2.4895
      top = 0.0875
      width = 0.75
      prefixEnable = false
      alignHorizontal = 2        // Right
      fontBold = true
      text = "US Champ: "
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.USCHAMP = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.USCHAMP)
      canRender = class::TEXTUSAYN1_CANRENDER
      onRender = class::TEXTUSAYN1_ONRENDER
      height = 0.2083
      left = 3.375
      top = 0.0729
      width = 0.27
      prefixEnable = false
      text = {||form.streamSource1.rowset.fields["USAYN"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.REGION2LABEL = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.REGION2LABEL)
      height = 0.1875
      left = 2.0209
      top = 0.3583
      width = 1.2084
      prefixEnable = false
      alignHorizontal = 2        // Right
      fontBold = true
      text = "Region 2 Champ: "
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.REGION2 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.REGION2)
      canRender = class::TEXTREGIIYN1_CANRENDER
      onRender = class::TEXTREGIIYN1_ONRENDER
      height = 0.2083
      left = 3.375
      top = 0.3646
      width = 0.27
      prefixEnable = false
      text = {||form.streamSource1.rowset.fields["REGIIYN"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTLUNCHYN1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTLUNCHYN1)
      canRender = class::TEXTLUNCHYN1_CANRENDER
      onRender = class::TEXTLUNCHYN1_ONRENDER
      height = 0.2083
      left = 4.5209
      top = 0.6667
      width = 0.27
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["lunchyn"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTDINNER1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTDINNER1)
      height = 0.2083
      left = 4.5521
      top = 0.4063
      width = 0.25
      variableHeight = true
      prefixEnable = false
      alignHorizontal = 2        // Right
      picture = "999"
      fontSize = 11.0
      text = {||this.form.tshirt1.rowset.fields["dinner"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT8 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT8)
      height = 0.2083
      left = 3.9584
      top = 0.6667
      width = 0.4479
      prefixEnable = false
      alignHorizontal = 2        // Right
      text = "Lunch"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT9 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT9)
      height = 0.2083
      left = 3.9271
      top = 0.3958
      width = 0.4583
      prefixEnable = false
      alignHorizontal = 2        // Right
      text = "Dinner"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTBIBNUM1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTBIBNUM1)
      height = 0.2083
      left = 4.4896
      top = 0.0729
      width = 0.375
      variableHeight = true
      prefixEnable = false
      alignHorizontal = 2        // Right
      picture = "99999"
      fontSize = 14.0
      fontBold = true
      text = {||this.form.tshirt1.rowset.fields["bibnum"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT10 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT10)
      height = 0.25
      left = 3.8333
      top = 0.0625
      width = 0.6042
      prefixEnable = false
      alignHorizontal = 1        // Center
      text = "<p>Bib No:</p><p></p>"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT12 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT12)
      height = 0.2083
      left = 0.4584
      top = 0.3229
      width = 0.5625
      prefixEnable = false
      alignHorizontal = 2        // Right
      text = "SI Card:"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTEPUNCHID1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTEPUNCHID1)
      height = 0.2083
      left = 1.1145
      top = 0.3333
      width = 0.7292
      variableHeight = true
      prefixEnable = false
      picture = "999999999"
      text = {||this.form.tshirt1.rowset.fields["epunchid"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT33 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT33)
      height = 0.2083
      left = 0.1146
      top = 0.6325
      width = 0.9583
      prefixEnable = false
      alignHorizontal = 2        // Right
      text = "Rent Punch?"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTRENTPUNCH1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTRENTPUNCH1)
      canRender = class::TEXTRENTPUNCH1_CANRENDER
      onRender = class::TEXTRENTPUNCH1_ONRENDER
      height = 0.2083
      left = 1.1666
      top = 0.6429
      width = 0.2917
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["rentpunch"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTCALLSIGN1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTCALLSIGN1)
      height = 0.2083
      left = 2.7604
      top = 0.698
      width = 0.7188
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["callsign"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT11 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT11)
      canRender = class::TEXT11_CANRENDER
      height = 0.2083
      left = 2.1146
      top = 0.6875
      width = 0.5521
      prefixEnable = false
      alignHorizontal = 2        // Right
      text = "Callsign"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTTOTALFEE1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTTOTALFEE1)
      canRender = class::TEXTTOTALFEE1_CANRENDER
      height = 0.2083
      left = 1.1562
      top = 4.22
      width = 0.4375
      variableHeight = true
      prefixEnable = false
      alignHorizontal = 2        // Right
      picture = "$999"
      text = {||this.form.tshirt1.rowset.fields["totalfee"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTAMTPAID1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTAMTPAID1)
      canRender = class::TEXTAMTPAID1_CANRENDER
      height = 0.2083
      left = 2.7083
      top = 4.22
      width = 0.4375
      variableHeight = true
      prefixEnable = false
      alignHorizontal = 2        // Right
      picture = "$999"
      text = {||this.form.tshirt1.rowset.fields["amtpaid"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTBALANCE1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTBALANCE1)
      canRender = class::TEXTBALANCE1_CANRENDER
      height = 0.2083
      left = 4.1771
      top = 4.22
      width = 0.4375
      variableHeight = true
      prefixEnable = false
      alignHorizontal = 2        // Right
      picture = "$999"
      text = {||this.form.tshirt1.rowset.fields["balance"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT13 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT13)
      height = 0.2083
      left = 0.2187
      top = 4.22
      width = 0.75
      prefixEnable = false
      alignHorizontal = 2        // Right
      text = "Total Fee"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT14 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT14)
      height = 0.2083
      left = 1.7709
      top = 4.22
      width = 0.8542
      prefixEnable = false
      alignHorizontal = 2        // Right
      text = "Amount Paid"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT15 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT15)
      canRender = class::TEXT15_CANRENDER
      height = 0.2083
      left = 3.5313
      top = 4.2292
      width = 0.5938
      prefixEnable = false
      alignHorizontal = 2        // Right
      text = "Balance"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT16 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT16)
      height = 0.2083
      left = 0.1563
      top = 1.0625
      width = 1.2188
      prefixEnable = false
      text = "Sunday July 28"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT17 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT17)
      height = 0.2083
      left = 0.1563
      top = 1.6979
      width = 1.2188
      prefixEnable = false
      text = "Monday July 29"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT18 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT18)
      height = 0.2083
      left = 0.1563
      top = 2.0105
      width = 1.2188
      prefixEnable = false
      text = "Tuesday July 30"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT19 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT19)
      height = 0.2083
      left = 1.5729
      top = 1.0833
      width = 0.75
      prefixEnable = false
      text = "9 am"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT20 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT20)
      height = 0.2083
      left = 1.5729
      top = 2.3125
      width = 0.75
      prefixEnable = false
      text = "9 am"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT21 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT21)
      height = 0.2083
      left = 1.5625
      top = 1.375
      width = 0.75
      prefixEnable = false
      text = "6 pm"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT22 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT22)
      height = 0.2083
      left = 1.5625
      top = 1.6979
      width = 0.75
      prefixEnable = false
      text = "9 am"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT23 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT23)
      height = 0.2083
      left = 1.5625
      top = 2.0105
      width = 0.75
      prefixEnable = false
      text = "9 am"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT24 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT24)
      height = 0.2083
      left = 0.1667
      top = 2.7709
      width = 1.2188
      prefixEnable = false
      text = "Thursday August 1"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT25 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT25)
      height = 0.2083
      left = 0.1563
      top = 3.1458
      width = 1.2188
      prefixEnable = false
      text = "Friday August 2"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT26 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT26)
      height = 0.2083
      left = 0.1563
      top = 3.521
      width = 1.2188
      prefixEnable = false
      text = "Saturday August 3"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT27 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT27)
      height = 0.2083
      left = 0.1563
      top = 3.8543
      width = 1.2188
      prefixEnable = false
      text = "Sunday August 4"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT1)
      height = 0.2083
      left = 1.5625
      top = 2.7709
      width = 0.75
      prefixEnable = false
      text = "FoxOring"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT28 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT28)
      height = 0.2083
      left = 1.5625
      top = 3.1458
      width = 0.75
      prefixEnable = false
      text = "Sprint"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT30 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT30)
      height = 0.2083
      left = 1.5625
      top = 3.5209
      width = 0.75
      prefixEnable = false
      text = "2 M"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT31 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT31)
      height = 0.2083
      left = 1.5625
      top = 3.875
      width = 0.75
      prefixEnable = false
      text = "80 M"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTFOXCLASS1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTFOXCLASS1)
      canRender = class::TEXTFOXCLASS1_CANRENDER
      height = 0.2083
      left = 2.7313
      top = 2.7619
      width = 0.6771
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["foxclass"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTSPRINTCLASS1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTSPRINTCLASS1)
      canRender = class::TEXTSPRINTCLASS1_CANRENDER
      height = 0.2083
      left = 2.7313
      top = 3.1368
      width = 0.6875
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["sprintclass"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTM80CLASS1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTM80CLASS1)
      canRender = class::TEXTM80CLASS1_CANRENDER
      height = 0.2083
      left = 2.7209
      top = 3.8556
      width = 0.5625
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["m80class"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTM2CLASS1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTM2CLASS1)
      canRender = class::TEXTM2CLASS1_CANRENDER
      height = 0.2083
      left = 2.7416
      top = 3.5119
      width = 0.7188
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["m2class"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTFOXSTART1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTFOXSTART1)
      canRender = class::TEXTFOXSTART1_CANRENDER
      height = 0.2083
      left = 3.5646
      top = 2.7619
      width = 0.625
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["foxstart"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTSPRINTSTART1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTSPRINTSTART1)
      canRender = class::TEXTSPRINTSTART1_CANRENDER
      height = 0.2083
      left = 3.5958
      top = 3.1472
      width = 0.625
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["sprintstart"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTM2START1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTM2START1)
      canRender = class::TEXTM2START1_CANRENDER
      height = 0.2083
      left = 3.5958
      top = 3.5014
      width = 0.625
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["m2start"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXTM80START1 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXTM80START1)
      canRender = class::TEXTM80START1_CANRENDER
      height = 0.2083
      left = 3.5958
      top = 3.8764
      width = 0.625
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["m80start"].value}
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.TEXT32 = new TEXT(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.TEXT32)
      height = 0.2083
      left = 0.1563
      top = 2.3022
      width = 1.2188
      prefixEnable = false
      text = "Wednesday July 31"
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.LINE2 = new KMLINE(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.LINE2)
      left = 0.1771
      right = 4.6146
      top = 4.1354
      bottom = 4.1354
      width = 3
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.LINE3 = new KMLINE(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.LINE3)
      left = 0.1563
      right = 4.8021
      top = 0.9792
      bottom = 0.9792
      width = 2
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.LINE4 = new KMLINE(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.LINE4)
      left = 0.1875
      right = 4.625
      top = 2.6354
      bottom = 2.6354
      width = 2
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.LINE5 = new KMLINE(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.LINE5)
      left = 0.1979
      right = 4.6354
      top = 4.5313
      bottom = 4.5313
      width = 2
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.LINE6 = new KMLINE(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.LINE6)
      left = 0.1875
      right = 4.625
      top = 2.6354
      bottom = 2.6354
      width = 2
   endwith

   this.STREAMSOURCE1.GROUP1.headerBand.LINE7 = new KMLINE(this.STREAMSOURCE1.GROUP1.headerBand)
   with (this.STREAMSOURCE1.GROUP1.headerBand.LINE7)
      left = 0.1667
      right = 4.6042
      top = 4.9271
      bottom = 4.9375
      width = 2
   endwith

   with (this.STREAMSOURCE1.detailBand)
      height = 0.1736
   endwith

   this.STREAMSOURCE1.detailBand.TEXTTSHIRTSIZE1 = new TEXT(this.STREAMSOURCE1.detailBand)
   with (this.STREAMSOURCE1.detailBand.TEXTTSHIRTSIZE1)
      height = 0.2083
      left = 0.2084
      top = 0.02
      width = 0.7604
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["tshirtsize"].value}
   endwith

   this.STREAMSOURCE1.detailBand.TEXTTSHIRTCOLOR1 = new TEXT(this.STREAMSOURCE1.detailBand)
   with (this.STREAMSOURCE1.detailBand.TEXTTSHIRTCOLOR1)
      height = 0.2083
      left = 1.1146
      top = 0.02
      width = 0.8438
      variableHeight = true
      prefixEnable = false
      text = {||this.form.tshirt1.rowset.fields["tshirtcolor"].value}
   endwith

   this.STREAMSOURCE1.detailBand.TEXTTSHIRTQUANT1 = new TEXT(this.STREAMSOURCE1.detailBand)
   with (this.STREAMSOURCE1.detailBand.TEXTTSHIRTQUANT1)
      canRender = class::TEXTTSHIRTQUANT1_CANRENDER
                height = 0.2083
      left = 2.1771
      top = 0.02
      width = 0.8958
      variableHeight = true
      prefixEnable = false
      alignHorizontal = 2        // Right
      picture = "999"
      text = {||this.form.tshirt1.rowset.fields["tshirtquant"].value}
   endwith

   this.STREAMSOURCE1.detailBand.LINE6 = new KMLINE(this.STREAMSOURCE1.detailBand)
   with (this.STREAMSOURCE1.detailBand.LINE6)
      left = 0.1875
      right = 4.625
      top = 0.25
      bottom = 0.25
      width = 1
   endwith

   with (this.reportGroup.footerBand)
      height = 0.0
   endwith

   with (this.reportGroup.headerBand)
      height = 0.0
   endwith

   this.firstPageTemplate = this.form.pagetemplate1
   this.form.pagetemplate1.nextPageTemplate = this.form.pagetemplate1
   this.form.pagetemplate1.streamframe1.streamSource = this.form.streamsource1
   this.form.pagetemplate1.streamframe2.streamSource = this.form.streamsource1
   this.form.streamsource1.rowset = this.form.tshirt1.rowset

   function TEXT11_canRender()
      if empty(this.parent.textcallsign1.text())
          lRet  = false
       else
         lRet = true
      endif        
   return lRet

   function TEXT15_canRender()
      if this.parent.textbalance1.text() = 0
          lRet = false
      else
          lRet = true
      endif          
   return lRet

   function TEXTAMTPAID1_canRender()
      if this.text() <10
           this.picture = '$9'
       elseif this.text() < 100
           this.picture = '$99'
       else
           this.picture = '$999'
       endif          
   return true

   function TEXTBALANCE1_canRender()
      if this.text() <10
           this.picture = '$9'
       elseif this.text() < 100
           this.picture = '$99'
       else
           this.picture = '$999'
       endif
      if this.text() = 0
         lRet = false
      else
         lRet = true
      endif        
   return lRet

   function TEXTTSHIRTQUANT1_canRender()
      if this.text() = 0
         lRet = false
      else
         lRet = true
      endif        
   return lRet
        
   function TEXTBLINDPRACCOURSE1_canRender()
      if this.text() ='Competing'
          this.text = 'Yes'
       else
          this.text = 'No'
      endif  
   return true

   function TEXTBLINDPRACCOURSE1_onRender()
       this.text = {||this.form.tshirt1.rowset.fields["blindpraccourse"].value}
   return

   function TEXTEPUNCHID1_canRender()
      if this.parent.parent.parent.rowset.fields['rentpunch'].value = 'Y'
         this.text= 'Rental'
       endif
   return true

   function TEXTEPUNCHID1_onRender()
      this.text = {||this.form.tshirt1.rowset.fields["epunchid"].value}
   return

   function TEXTFOXCLASS1_canRender()
      if this.text() ='NC'
         lRet = false
      else
         lRet = true
      endif        
   return lRet

   function TEXTFOXPRACCOURSE1_canRender()
      if this.text() ='Competing'
          this.text = 'Yes'
       else
          this.text = 'No'
      endif  
   return true

   function TEXTFOXPRACCOURSE1_onRender()
      this.text = {||this.form.tshirt1.rowset.fields["foxpraccourse"].value}
   return

   function TEXTFOXSTART1_canRender()
      if this.parent.textfoxclass1.text() = 'NC'
          lRet = false
      else
          lRet = true
      endif          
   return lRet

   function TEXTLUNCHYN1_canRender()
      if this.text() ='Y'
          this.text = 'Yes'
       else
          this.text = 'No'
      endif          
   return true

   function TEXTLUNCHYN1_onRender()
      this.text = {||this.form.tshirt1.rowset.fields["rentpunch"].value}
   return

   function TEXTRENTPUNCH1_canRender()
      if this.text() ='Y'
          this.text = 'Yes'
       else
          this.text = 'No'
      endif          
   return true

   function TEXTRENTPUNCH1_onRender()
      this.text = {||this.form.tshirt1.rowset.fields["rentpunch"].value}
   return
                

        function TEXTUSAYN1_canRender()
      if this.text() ='Y'
          this.text = 'Yes'
       else
          this.text = 'No'
      endif          
   return true

   function TEXTUSAYN1_onRender()
      this.text = {||this.form.tshirt1.rowset.fields["usayn"].value}
      return

        function TEXTREGIIYN1_canRender()
      if this.text() ='Y'
          this.text = 'Yes'
       else
          this.text = 'No'
      endif          
   return true

   function TEXTREGIIYN1_onRender()
      this.text = {||this.form.tshirt1.rowset.fields["regiiyn"].value}
   return

   function TEXTM2CLASS1_canRender()
      if this.text() ='NC'
         lRet = false
      else
         lRet = true
      endif        
   return lRet

   function TEXTM2PRACCOURSE1_canRender()
      if this.text() ='Competing'
          this.text = 'Yes'
       else
          this.text = 'No'
      endif          
   return true

   function TEXTM2PRACCOURSE1_onRender()
      this.text = {||this.form.tshirt1.rowset.fields["m2praccourse"].value}
      return

   function TEXTM2START1_canRender()
      if this.parent.textm2class1.text() = 'NC'
          lRet = false
      else
          lRet = true
      endif          
   return lRet

   function TEXTM80CLASS1_canRender()
      if this.text() ='NC'
         lRet = false
      else
         lRet = true
      endif        
   return lRet

   function TEXTM80PRACCOURSE1_canRender()
      if this.text() ='Competing'
          this.text = 'Yes'
       else
          this.text = 'No'
      endif  
   return true

   function TEXTM80PRACCOURSE1_onRender()
      this.text = {||this.form.tshirt1.rowset.fields["m80praccourse"].value}
   return

   function TEXTM80START1_canRender()
      if this.parent.textm80class1.text() = 'NC'
          lRet = false
      else
          lRet = true
      endif          
   return lRet
   return true

   function TEXTSPRINTCLASS1_canRender()
      if this.text() ='NC'
         lRet = false
      else
         lRet = true
      endif        
   return lRet

   function TEXTSPRINTPRACCOURSE1_canRender()
      if this.text() ='Competing'
          this.text = 'Yes'
       else
          this.text = 'No'
      endif  
   return true

   function TEXTSPRINTPRACCOURSE1_onRender()
      this.text = {||this.form.tshirt1.rowset.fields["sprintpraccourse"].value}
   return

   function TEXTSPRINTSTART1_canRender()
      if this.parent.textsprintclass1.text() = 'NC'
          lRet = false
      else
          lRet = true
      endif          
   return lRet

   function TEXTTOTALFEE1_canRender()
       if this.text() <10
           this.picture = '$9'
       elseif this.text() < 100
           this.picture = '$99'
       else
           this.picture = '$999'
       endif          
   return true

endclass