Computer Buyer 1999 September

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

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

Wrap

Text File | 1999-04-07 | 21KB | 1,163 lines

<SHAZAM REPORT WIZARD> BEGIN REPORT FileVersion = 3.50 ProductVersion = 3.50 ProductRevision = M Password = PixelsPerInch = 120 Distinct = 0 Count = 17 DateFormat = 1 DateSeparator = / DecimalSeparator = . DataModel = 0 END REPORT BEGIN PAGE PaperType = 1 PaperHeight = 11.00 PaperWidth = 8.50 PaperOrientation = 0 MarginTop = 0.20 MarginBottom = 0.20 MarginRight = 0.20 MarginLeft = 0.20 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 = Stock.DBF TableAlias = Stock Top = 7 Left = 0 Height = 132 Width = 155 END TABLE BEGIN FILTER FieldAlias = STOCKCODE TableAlias = Stock FieldExpr = STOCKCODE Show = 0 Sort = 1 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = STOCKCODE DataType = 1 Width = 16 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = DESC TableAlias = Stock FieldExpr = DESC Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = DESC DataType = 1 Width = 40 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = PRODGROUP TableAlias = Stock FieldExpr = PRODGROUP Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = PRODGROUP DataType = 1 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = REORDLEV TableAlias = Stock FieldExpr = REORDLEV Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = REORDLEV DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = END FILTER BEGIN FILTER FieldAlias = REORDQUAN TableAlias = Stock FieldExpr = REORDQUAN Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = REORDQUAN DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = END FILTER BEGIN FILTER FieldAlias = LOCATION TableAlias = Stock FieldExpr = LOCATION Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = LOCATION DataType = 1 Width = 15 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = INSTOCK TableAlias = Stock FieldExpr = INSTOCK Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = INSTOCK DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = END FILTER BEGIN FILTER FieldAlias = ONORDER TableAlias = Stock FieldExpr = ONORDER Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = ONORDER DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = END FILTER BEGIN FILTER FieldAlias = COSTPRICE TableAlias = Stock FieldExpr = COSTPRICE Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = COSTPRICE DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = END FILTER BEGIN FILTER FieldAlias = REORDVAL TableAlias = FieldExpr = (Stock.REORDQUAN * Stock.COSTPRICE ) Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = (Stock.REORDQUAN * Stock.COSTPRICE ) DataType = 0 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = LEVELS TableAlias = Stock FieldExpr = LEVELS Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = LEVELS DataType = 5 Width = 6 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = REP_T_VAL1 TableAlias = Stock FieldExpr = REP_T_VAL1 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = REP_T_VAL1 DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = END FILTER BEGIN FILTER FieldAlias = REP_T_VAL2 TableAlias = Stock FieldExpr = REP_T_VAL2 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = REP_T_VAL2 DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = END FILTER BEGIN FILTER FieldAlias = REP_T_VAL3 TableAlias = Stock FieldExpr = REP_T_VAL3 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = REP_T_VAL3 DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = END FILTER BEGIN FILTER FieldAlias = REP_T_VAL4 TableAlias = Stock FieldExpr = REP_T_VAL4 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = REP_T_VAL4 DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = END FILTER BEGIN FILTER FieldAlias = REP_T_VAL5 TableAlias = Stock FieldExpr = REP_T_VAL5 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = REP_T_VAL5 DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = END FILTER BEGIN SECTION Index = 2 Type = 1 Mode = 0 Field = Height = 299 KeepGroup = 0 NewPage = 0 NewPageNo = 0 PrintSection = 1 END SECTION BEGIN SECTION Index = 13 Type = 3 Mode = 0 Field = Height = 28 KeepGroup = 0 NewPage = 0 NewPageNo = 0 PrintSection = 1 END SECTION BEGIN SECTION Index = 28 Type = 0 Mode = 1 Field = Height = 59 KeepGroup = 0 NewPage = 0 NewPageNo = 0 PrintSection = 1 END SECTION BEGIN SHAPE Type = 3 Name = RepTotBox Left = 374 Top = 359 Height = 36 Width = 624 BrushColor = clWhite BrushStyle = 1 PenColor = clBlack PenMode = 4 PenStyle = 0 PenWidth = 1 END SHAPE BEGIN LABEL Type = 0 Name = Time Left = 867 Top = 94 Height = 22 Width = 100 Caption = @Time Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 10 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Label3 Left = 768 Top = 68 Height = 22 Width = 91 Caption = Date Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 10 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Label2 Left = 769 Top = 41 Height = 22 Width = 91 Caption = Page No. Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 10 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = PageNo Left = 867 Top = 41 Height = 22 Width = 81 Caption = @PageNo Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 10 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Label6 Left = 85 Top = 192 Height = 22 Width = 175 Caption = Start Stock Code Alignment = 0 Color = clWhite Transparent = 1 FontName = MS Sans Serif FontSize = 9 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 1 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Label8 Left = 278 Top = 192 Height = 22 Width = 175 Caption = Finish Stock Code Alignment = 0 Color = clWhite Transparent = 1 FontName = MS Sans Serif FontSize = 9 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 1 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = StProdGrp Left = 473 Top = 217 Height = 22 Width = 150 Caption = Alignment = 0 Color = clWhite Transparent = 1 FontName = MS Sans Serif FontSize = 9 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = FinStkCode Left = 278 Top = 217 Height = 22 Width = 175 Caption = Alignment = 0 Color = clWhite Transparent = 1 FontName = MS Sans Serif FontSize = 9 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = StStkCode Left = 85 Top = 217 Height = 22 Width = 175 Caption = Alignment = 0 Color = clWhite Transparent = 1 FontName = MS Sans Serif FontSize = 9 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = STOCKCODE Left = 28 Top = 325 Height = 22 Width = 160 Caption = [STOCKCODE] Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 8 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Label9 Left = 473 Top = 192 Height = 22 Width = 150 Caption = Start Product Group Alignment = 0 Color = clWhite Transparent = 1 FontName = MS Sans Serif FontSize = 9 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 1 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Label30 Left = 28 Top = 296 Height = 22 Width = 160 Caption = Stock Code Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 9 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per1Tot Left = 525 Top = 366 Height = 22 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 9 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per2Tot Left = 619 Top = 366 Height = 22 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 9 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per3Tot Left = 714 Top = 366 Height = 22 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 9 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per4Tot Left = 808 Top = 366 Height = 22 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 9 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per5Tot Left = 904 Top = 366 Height = 22 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 9 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per5 Left = 904 Top = 325 Height = 22 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 8 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per4 Left = 809 Top = 325 Height = 22 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 8 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per3 Left = 714 Top = 325 Height = 22 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 8 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per2 Left = 618 Top = 325 Height = 22 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 8 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per1 Left = 525 Top = 325 Height = 22 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 8 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per2Cap Left = 618 Top = 278 Height = 40 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 9 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per3Cap Left = 714 Top = 278 Height = 40 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 9 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per4Cap Left = 809 Top = 278 Height = 40 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 9 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per5Cap Left = 904 Top = 278 Height = 40 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 9 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Label5 Left = 380 Top = 366 Height = 22 Width = 139 Caption = Sales Totals Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 9 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = DESC Left = 190 Top = 325 Height = 22 Width = 330 Caption = [DESC] Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 8 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Label7 Left = 190 Top = 296 Height = 22 Width = 330 Caption = Description Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 9 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Label1 Left = 35 Top = 110 Height = 45 Width = 317 Caption = Stock Sales Report Alignment = 0 Color = clBlue Transparent = 1 FontName = Arial FontSize = 20 FontColor = clWhite FontBold = 1 FontItalic = 1 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = FinProdGrp Left = 626 Top = 217 Height = 22 Width = 150 Caption = Alignment = 0 Color = clWhite Transparent = 1 FontName = MS Sans Serif FontSize = 9 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Per1Cap Left = 524 Top = 278 Height = 40 Width = 90 Caption = Alignment = 1 Color = clWhite Transparent = 1 FontName = Arial FontSize = 9 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Label4 Left = 769 Top = 94 Height = 22 Width = 89 Caption = Time Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 10 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = SysDate Left = 867 Top = 68 Height = 22 Width = 100 Caption = Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 10 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 0 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = CompName Left = 36 Top = 38 Height = 32 Width = 657 Caption = Company Name Alignment = 0 Color = clWhite Transparent = 1 FontName = Arial FontSize = 14 FontColor = clBlack FontBold = 1 FontItalic = 0 FontUnderline = 1 FontStrikeOut = 0 END LABEL BEGIN LABEL Type = 0 Name = Label10 Left = 626 Top = 192 Height = 22 Width = 150 Caption = Finish Product Group Alignment = 0 Color = clWhite Transparent = 1 FontName = MS Sans Serif FontSize = 9 FontColor = clBlack FontBold = 0 FontItalic = 0 FontUnderline = 1 FontStrikeOut = 0 END LABEL