PC World Komputer 1997 May/Pcwk0597.iso/borland/ib/setups/intrabld/data.z/EVENTS2.JRP

Text File | 1996-12-11 | 6KB | 254 lines

// {End Header} Do not remove this comment//
// Generated on 11/06/96
//
var r = new EVENTS2Report();
if (EVENTS2.arguments.length == 2) {
   r.startPage = EVENTS2.arguments[0];
   r.endPage = EVENTS2.arguments[1];
}
r.render();
class EVENTS2Report extends Report {
   with (this) {
      title = "Customer Contacts by Employee & Contact Type";
      linkText = "Next Page";
   }


   with (this.contacts1 = new Database()){
      left = 0;
      top = 0;
      databaseName = "CONTACTS";
      active = true;
   }


   with (this.events1 = new Query()){
      left = 5;
      top = 0;
      database = parent.contacts1;
      sql = "SELECT * FROM Events                                                       ORDER BY CONTNAME,CONTBY,CONTTYPE,CONTEND";

      active = true;
   }


   with (this.events1.rowset) {

   }


   with (this.streamSource1 = new StreamSource(this)){

   }


   with (this.streamSource1.group1 = new Group(this.streamSource1)){
      groupBy = "CONTNAME";
   }


   with (this.streamSource1.group1.headerBand) {
      height = 250;
   }


   with (this.streamSource1.group1.headerBand.Contname = new HTML(this.streamSource1.group1.headerBand)){
      height = 255;
      width = 7500;
      variableHeight = true;
      color = "blue";
      text = {||this.form.events1.rowset.fields["CONTNAME"].value};
   }


   with (this.streamSource1.group1.footerBand) {
      height = 150;
   }


   with (this.streamSource1.group2 = new Group(this.streamSource1)){
      groupBy = "CONTBY";
   }


   with (this.streamSource1.group2.headerBand) {
      height = 250;
   }


   with (this.streamSource1.group2.headerBand.Contby = new HTML(this.streamSource1.group2.headerBand)){
      height = 255;
      left = 270;
      width = 7230;
      variableHeight = true;
      color = "black";
      text = {||this.form.events1.rowset.fields["CONTBY"].value};
   }


   with (this.streamSource1.group2.footerBand) {
      height = 85;
   }


   with (this.streamSource1.group3 = new Group(this.streamSource1)){
      groupBy = "CONTTYPE";
   }


   with (this.streamSource1.group3.headerBand) {
      height = 250;
   }


   with (this.streamSource1.group3.headerBand.Conttype = new HTML(this.streamSource1.group3.headerBand)){
      height = 255;
      left = 540;
      width = 2745;
      variableHeight = true;
      color = "black";
      text = {||this.form.events1.rowset.fields["CONTTYPE"].value};
   }


   with (this.streamSource1.group3.footerBand) {
      height = 130;
   }


   with (this.streamSource1.group4 = new Group(this.streamSource1)){
      groupBy = "CONTEND";
   }


   with (this.streamSource1.group4.headerBand) {
      height = 0;
   }


   with (this.streamSource1.group4.footerBand) {
      height = 0;
   }


   with (this.streamSource1.detailBand) {
      height = 0;
   }


   with (this.streamSource1.detailBand.HTML4 = new HTML(this.streamSource1.detailBand)){
      height = 1;
      left = 2600;
      width = 4900;
      variableHeight = true;
      color = "black";
      fontBold = false;
      text = {||this.form.events1.rowset.fields["DESCRIPTION"].value};
   }


   with (this.streamSource1.detailBand.contend1 = new HTML(this.streamSource1.detailBand)){
      height = 255;
      left = 810;
      width = 1790;
      variableHeight = true;
      color = "black";
      fontBold = false;
      text = {||this.form.events1.rowset.fields["CONTEND"].value};
   }


   with (this.pageTemplate1 = new PageTemplate(this)){
      height = 15840;
      width = 9000;
      marginTop = 0;
      marginLeft = 0;
      marginBottom = 0;
      marginRight = 0;
      gridLineWidth = 0;
      background = "filename BKGND.GIF";
   }


   with (this.pageTemplate1.streamFrame1 = new StreamFrame(this.pageTemplate1)){
      height = 11376;
      top = 1584;
      width = 9000;
   }


   with (this.pageTemplate1.HTML1 = new HTML(this.pageTemplate1)){
      height = 250;
      top = 785;
      width = 5925;
      color = "blue";
      text = {||"Sorted by Employee " + '&' + '&' + " Contact Type, per Customer - " + new Date()};
   }


   with (this.pageTemplate1.image1 = new Image(this.pageTemplate1)){
      height = 650;
      width = 2460;
      dataSource = "filename EVENTLOG.GIF";
      alignment = 4;
   }


   with (this.pageTemplate1.image2 = new Image(this.pageTemplate1)){
      height = 135;
      top = 1125;
      width = 7500;
      dataSource = "filename BARSEP.GIF";
      alignment = 4;
   }


   with (this.printer) {
      duplex = 1;
      orientation = 1;
      paperSource = 7;
      paperSize = 1;
      resolution = 4;
      color = 1;
      trueTypeFonts = 3;
   }


   with (this.reportGroup) {
      groupBy = "";
   }


   with (this.reportGroup.headerBand) {
      height = 0;
   }


   with (this.reportGroup.footerBand) {
      height = 500;
   }


   with (this.reportGroup.footerBand.image1 = new Image(this.reportGroup.footerBand)){
      height = 200;
      width = 7500;
      dataSource = "filename BARSEP.GIF";
      alignment = 4;
   }


   with (this.reportGroup.footerBand.HTML1 = new HTML(this.reportGroup.footerBand)){
      height = 250;
      top = 200;
      width = 7500;
      color = "black";
      text = '<FONT COLOR="blue">Click <A HREF= "/svr/intrasrv.isv?apps/contacts/events.jfm">here</A> to return to Events Log.</font>';
   }

   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.events1.rowset

}