Computer Buyer 1999 September

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

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

Wrap

Text File | 1999-04-07 | 19KB | 1,084 lines

<SHAZAM REPORT WIZARD> BEGIN REPORT FileVersion = 3.50 ProductVersion = 3.50 ProductRevision = M Password = PixelsPerInch = 120 Distinct = 0 Count = 16 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 = SALEPRICE1 TableAlias = Stock FieldExpr = SALEPRICE1 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = SALEPRICE1 DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = END FILTER BEGIN FILTER FieldAlias = SALEPRICE2 TableAlias = Stock FieldExpr = SALEPRICE2 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = SALEPRICE2 DataType = 6 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 2 Format = END FILTER BEGIN FILTER FieldAlias = SALEPRICE3 TableAlias = Stock FieldExpr = SALEPRICE3 Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = SALEPRICE3 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 = 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 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 = Rectangle1 Left = 530 Top = 359 Height = 36 Width = 468 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 = 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 = INSTOCK Left = 507 Top = 325 Height = 22 Width = 80 Caption = [INSTOCK] 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 = Label30 Left = 28 Top = 297 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 = DESC Left = 190 Top = 325 Height = 22 Width = 315 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 = 297 Height = 22 Width = 315 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 = INSTOCK Caption Left = 507 Top = 297 Height = 22 Width = 80 Caption = In Stock 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 = COSTPRICE Caption Left = 589 Top = 279 Height = 40 Width = 100 Caption = Average Unit Cost 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 = Label11 Left = 691 Top = 279 Height = 40 Width = 100 Caption = Stock Value At Cost 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 = SalePriceCap Left = 794 Top = 279 Height = 40 Width = 100 Caption = Sales Price 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 = Label12 Left = 896 Top = 279 Height = 40 Width = 100 Caption = Stock Sales Value 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 = SaleVal Left = 896 Top = 325 Height = 22 Width = 100 Caption = Label 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 = SalePrice Left = 794 Top = 325 Height = 22 Width = 100 Caption = Label 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 = CostVal Left = 691 Top = 325 Height = 22 Width = 100 Caption = Label 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 = AvUnitCost Left = 589 Top = 325 Height = 22 Width = 100 Caption = Label 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 = Label5 Left = 535 Top = 365 Height = 22 Width = 139 Caption = Valuation 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 = 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 = 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 = TotSaleVal Left = 885 Top = 365 Height = 22 Width = 110 Caption = Label 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 = TotCostVal Left = 682 Top = 365 Height = 22 Width = 110 Caption = Label 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 = 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 = Label25 Left = 38 Top = 115 Height = 45 Width = 427 Caption = Stock Valuation 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 = 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 = 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 = Label10 Left = 645 Top = 191 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 BEGIN LABEL Type = 0 Name = FinProdGrp Left = 645 Top = 216 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 = CompName Left = 36 Top = 38 Height = 32 Width = 659 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