Computer Buyer 1999 September

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

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

Wrap

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

<SHAZAM REPORT WIZARD> BEGIN REPORT FileVersion = 3.50 ProductVersion = 3.50 ProductRevision = M Password = PixelsPerInch = 120 Distinct = 0 Count = 13 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 = 5 Left = 159 Height = 132 Width = 155 END TABLE BEGIN TABLE DatabaseName = EmpireBuilder TableName = StkCats.DBF TableAlias = StkCats Top = 7 Left = 8 Height = 100 Width = 113 END TABLE BEGIN JOIN LeftTable = Stock LeftField = PRODGROUP JoinOperator = 0 RightTable = StkCats RightField = PRODCODE JoinType = 0 END JOIN BEGIN FILTER FieldAlias = PRODCODE TableAlias = StkCats FieldExpr = PRODCODE Show = 0 Sort = 1 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = PRODCODE DataType = 1 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER BEGIN FILTER FieldAlias = PGDESC TableAlias = FieldExpr = (StkCats."DESC") Show = 0 Sort = 0 FilterDisplay1 = FilterDisplay2 = FilterDisplay3 = FilterDisplay4 = FilterDisplay5 = FieldName = (StkCats."DESC") DataType = 0 Width = 10 FilterValues1 = FilterValues2 = FilterValues3 = FilterValues4 = FilterValues5 = Alignment = 0 Format = END FILTER 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 = 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 = 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 = 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 = 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 = 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 = 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 SECTION Index = 2 Type = 1 Mode = 0 Field = Height = 299 KeepGroup = 0 NewPage = 0 NewPageNo = 0 PrintSection = 1 END SECTION BEGIN SECTION Index = 3 Type = 2 Mode = 0 Field = PRODCODE Height = 125 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 = 27 Type = 2 Mode = 1 Field = PRODCODE Height = 68 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 = Rectangle2 Left = 503 Top = 491 Height = 36 Width = 495 BrushColor = clWhite BrushStyle = 1 PenColor = clBlack PenMode = 4 PenStyle = 0 PenWidth = 1 END SHAPE BEGIN SHAPE Type = 3 Name = Rectangle1 Left = 504 Top = 552 Height = 36 Width = 494 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 = 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 = 450 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 = 450 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 = DESC Left = 190 Top = 450 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 = 423 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 = 423 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 = 405 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 = 690 Top = 405 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 = 791 Top = 405 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 = 405 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 = 450 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 = 450 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 = 450 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 = 450 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 = Label30 Left = 28 Top = 423 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 = PRODCODE Left = 159 Top = 341 Height = 22 Width = 162 Caption = [PRODCODE] Alignment = 0 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 = PRODCODE Caption Left = 29 Top = 341 Height = 22 Width = 126 Caption = Product Group 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 = PGDESC Caption Left = 29 Top = 367 Height = 22 Width = 125 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 = PGDESC Left = 160 Top = 367 Height = 22 Width = 350 Caption = [PGDESC] Alignment = 0 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 = Label15 Left = 508 Top = 497 Height = 22 Width = 169 Caption = Group 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 = Label5 Left = 509 Top = 558 Height = 22 Width = 157 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 = 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 = 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 = FinProdGrp Left = 641 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 = GrpCostVal Left = 680 Top = 497 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 = GrpSaleVal Left = 885 Top = 497 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 = TotSaleVal Left = 885 Top = 558 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 = 680 Top = 558 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 = 37 Top = 115 Height = 45 Width = 410 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 = Label10 Left = 641 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 = CompName Left = 36 Top = 38 Height = 32 Width = 660 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