Computer Buyer 1999 September

home *** CD-ROM | disk | FTP | other *** search

/ Computer Buyer 1999 September / Dpcb0999.iso / Business / Empire / _SETUP.1 / SD_RANTemplate.SRW < prev next >

Wrap

Text File | 1999-03-02 | 20KB | 1,052 lines

<SHAZAM REPORT WIZARD> BEGIN REPORT FileVersion = 3.50 ProductVersion = 3.50 ProductRevision = K Password = PixelsPerInch = 120 Distinct = 0 Count = 39 DateFormat = 1 DateSeparator = / DecimalSeparator = . END REPORT BEGIN PAGE PaperType = 1 PaperHeight = 11.00 PaperWidth = 8.50 PaperOrientation = 0 MarginTop = 0.30 MarginBottom = 0.30 MarginRight = 0.30 MarginLeft = 0.30 LabelsActive = 0 LabelsAcross = 0 LabelsDown = 0 LabelsGapHorz = 0.000 LabelsGapVert = 0.000 LabelsHeight = 0.000 LabelsWidth = 0.000 END PAGE BEGIN TITLE Caption = Report FontName = Arial FontSize = 24 FontColor = clBlack FontBold = 1 FontItalic = 1 FontUnderline = 0 FontStrikeOut = 0 END TITLE BEGIN SUBTITLE Caption = FontName = Arial FontSize = 14 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END SUBTITLE BEGIN FOOTER Caption = FontName = Arial FontSize = 10 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END FOOTER BEGIN RECORD FontName = Arial FontSize = 10 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END RECORD BEGIN TABLE DatabaseName = EmpireBuilder TableName = Supplier.DBF TableAlias = Supplier Top = 1 Left = 5 Height = 175 Width = 143 END TABLE BEGIN TABLE DatabaseName = EmpireBuilder TableName = Trans.DBF TableAlias = Trans Top = 1 Left = 176 Height = 174 Width = 137 END TABLE BEGIN JOIN LeftTable = Supplier LeftField = ACCREF JoinOperator = 0 RightTable = Trans RightField = ACCREF JoinType = 0 END JOIN BEGIN FILTER FieldAlias = ACCREF TableAlias = Supplier FieldExpr = ACCREF Show = 0 Sort = 1 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = ACCREF DataType = 1 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = NAME TableAlias = Supplier FieldExpr = NAME Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = NAME DataType = 1 Width = 40 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = ADDRESS1 TableAlias = Supplier FieldExpr = ADDRESS1 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = ADDRESS1 DataType = 1 Width = 30 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = ADDRESS2 TableAlias = Supplier FieldExpr = ADDRESS2 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = ADDRESS2 DataType = 1 Width = 30 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = ADDRESS3 TableAlias = Supplier FieldExpr = ADDRESS3 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = ADDRESS3 DataType = 1 Width = 30 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = POSTCODE TableAlias = Supplier FieldExpr = POSTCODE Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = POSTCODE DataType = 1 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = TELNO1 TableAlias = Supplier FieldExpr = TELNO1 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = TELNO1 DataType = 1 Width = 15 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = TELNO2 TableAlias = Supplier FieldExpr = TELNO2 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = TELNO2 DataType = 1 Width = 15 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = FAXNO TableAlias = Supplier FieldExpr = FAXNO Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = FAXNO DataType = 1 Width = 15 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = EMAIL TableAlias = Supplier FieldExpr = EMAIL Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = EMAIL DataType = 1 Width = 70 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = CONTACT TableAlias = Supplier FieldExpr = CONTACT Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = CONTACT DataType = 1 Width = 25 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = CREITLMT TableAlias = Supplier FieldExpr = CREITLMT Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = CREITLMT DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = TERMS TableAlias = Supplier FieldExpr = TERMS Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = TERMS DataType = 2 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0 END FILTER BEGIN FILTER FieldAlias = VATID TableAlias = Supplier FieldExpr = VATID Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = VATID DataType = 1 Width = 15 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = VATCODE TableAlias = Supplier FieldExpr = VATCODE Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = VATCODE DataType = 1 Width = 7 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = ECCODE TableAlias = Supplier FieldExpr = ECCODE Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = ECCODE DataType = 1 Width = 6 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = BALANCE TableAlias = Supplier FieldExpr = BALANCE Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = BALANCE DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = CURRENT TableAlias = Supplier FieldExpr = CURRENT Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = CURRENT DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = PERBAL1 TableAlias = Supplier FieldExpr = PERBAL1 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = PERBAL1 DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = PERBAL2 TableAlias = Supplier FieldExpr = PERBAL2 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = PERBAL2 DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = PERBAL3 TableAlias = Supplier FieldExpr = PERBAL3 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = PERBAL3 DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = PERBAL4 TableAlias = Supplier FieldExpr = PERBAL4 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = PERBAL4 DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = AMTQUERY TableAlias = Supplier FieldExpr = AMTQUERY Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = AMTQUERY DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = PAYDUE TableAlias = Supplier FieldExpr = PAYDUE Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = PAYDUE DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = MTOVER TableAlias = Supplier FieldExpr = MTOVER Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = MTOVER DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = YTOVER TableAlias = Supplier FieldExpr = YTOVER Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = YTOVER DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = TRANSTYPE TableAlias = Trans FieldExpr = TRANSTYPE Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = TRANSTYPE DataType = 1 Width = 9 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = TRANSDATE TableAlias = Trans FieldExpr = TRANSDATE Show = 0 Sort = 1 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = TRANSDATE DataType = 9 Width = 9 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = END FILTER BEGIN FILTER FieldAlias = INVREF TableAlias = Trans FieldExpr = INVREF Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = INVREF DataType = 1 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = DETAILS TableAlias = Trans FieldExpr = DETAILS Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = DETAILS DataType = 1 Width = 30 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = NETVALUE TableAlias = Trans FieldExpr = NETVALUE Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = NETVALUE DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = VATVALUE TableAlias = Trans FieldExpr = VATVALUE Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = VATVALUE DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = TOTAL TableAlias = Trans FieldExpr = TOTAL Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = TOTAL DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = BALFORWARD TableAlias = FieldExpr = (Trans.BALANCE) Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = (Trans.BALANCE) DataType = 0 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = TERMS TableAlias = Trans FieldExpr = TERMS Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = TERMS DataType = 2 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0 END FILTER BEGIN FILTER FieldAlias = PAYMENT TableAlias = Trans FieldExpr = PAYMENT Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = PAYMENT DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = OUTSTAND TableAlias = FieldExpr = (Trans.TOTAL - Trans.PAYMENT ) Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = (Trans.TOTAL - Trans.PAYMENT ) DataType = 0 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = 0.00 END FILTER BEGIN FILTER FieldAlias = MODULE TableAlias = Trans FieldExpr = MODULE Show = 0 Sort = 0 FilterDisplay1 = Equals 'S' FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = MODULE DataType = 1 Width = 6 FilterValues1 = 0|0|S||||| FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN SECTION Index = 1 Type = 0 Mode = 0 Field = Height = 151 KeepGroup = 0 NewPage = 0 NewPageNo = 0 PrintSection = 1 END SECTION BEGIN SECTION Index = 2 Type = 1 Mode = 0 Field = Height = 125 KeepGroup = 0 NewPage = 0 NewPageNo = 0 PrintSection = 1 END SECTION BEGIN SECTION Index = 13 Type = 3 Mode = 0 Field = Height = 100 KeepGroup = 0 NewPage = 0 NewPageNo = 0 PrintSection = 1 END SECTION BEGIN SECTION Index = 29 Type = 1 Mode = 1 Field = Height = 125 KeepGroup = 0 NewPage = 0 NewPageNo = 0 PrintSection = 1 END SECTION BEGIN LABEL Type = 0 Name = Label2 Left = 76 Top = 326 Height = 77 Width = 323 Caption = In this section you put the details of individual transaction ie . Date, Reference, Total Value etc. Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 12 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Label4 Left = 76 Top = 79 Height = 77 Width = 323 Caption = In this section you put your company details ie Company Name, Address, Logo etc. Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 12 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Label3 Left = 74 Top = 215 Height = 77 Width = 323 Caption = In this section you put the details of the remittance ie Supplier Address, Date, Page No. etc. Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 12 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Label1 Left = 74 Top = 422 Height = 102 Width = 323 Caption = In this section you put the details that you want at the bottom of the remittance ie. Total Balance, Notes etc. Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 12 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL