Computer Buyer 1999 September

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

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

Wrap

Text File | 1999-04-07 | 21KB | 1,182 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 = 318 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 = 377 Height = 34 Width = 625 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 = 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 = 344 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 = DESC Left = 190 Top = 344 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 = 318 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 = 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 = QtySoldCap Left = 523 Top = 318 Height = 22 Width = 90 Caption = Qty Sold 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 = SalesCostCap Left = 727 Top = 318 Height = 22 Width = 110 Caption = Cost of Sales 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 = TotQtySold Left = 521 Top = 383 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 = ValSold Left = 615 Top = 344 Height = 22 Width = 110 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 = TotValSold Left = 614 Top = 383 Height = 22 Width = 110 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 = SalesCost Left = 727 Top = 344 Height = 22 Width = 110 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 = ProfitCap Left = 839 Top = 318 Height = 22 Width = 110 Caption = Profit 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 = Profit Left = 839 Top = 344 Height = 22 Width = 110 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 = TotSalesCost Left = 726 Top = 383 Height = 22 Width = 110 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 = TotProfit Left = 838 Top = 383 Height = 22 Width = 110 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 = ProfPer Left = 951 Top = 344 Height = 22 Width = 45 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 = TotProfPer Left = 950 Top = 383 Height = 22 Width = 45 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 = QtySold Left = 523 Top = 344 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 = Label1 Left = 35 Top = 110 Height = 45 Width = 586 Caption = Stock Profit Report (Period Analysis) 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 = 645 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 = Label30 Left = 28 Top = 318 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 = ProfPerCap Left = 951 Top = 300 Height = 40 Width = 45 Caption = Profit % Alignment = 2 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 = 379 Top = 383 Height = 22 Width = 139 Caption = Profit 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 = ValSoldCap Left = 615 Top = 318 Height = 22 Width = 110 Caption = Sold 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 = PeriodHeader Left = 524 Top = 268 Height = 22 Width = 466 Caption = Alignment = 2 Color = clWhite Transparent = 1 FontName = Arial FontSize = 10 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 = 866 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 = 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 = 645 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