ReportName = Parts List By Type ReportGroup = Parts object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.Parts NoDataBehaviors = [ndBlankReport] PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Report' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'Default' PrinterSetup.mmMarginBottom = 6350 PrinterSetup.mmMarginLeft = 6350 PrinterSetup.mmMarginRight = 6350 PrinterSetup.mmMarginTop = 6350 PrinterSetup.mmPaperHeight = 279401 PrinterSetup.mmPaperWidth = 215900 PrinterSetup.PaperSize = 1 SaveAsTemplate = True Template.DatabaseSettings.DataPipeline = dpReports Template.DatabaseSettings.Name = 'Parts List By Type' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Parts List By Type.rtm' Template.SaveTo = stDatabase Template.Format = ftASCII AllowPrintToFile = True DeviceType = 'Screen' OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = False OutlineSettings.Visible = True PreviewFormSettings.ZoomSetting = zs100Percent TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True Left = 218 Top = 155 Version = '7.03' mmColumnWidth = 0 DataPipelineName = 'Parts' object ppTitleBand1: TppTitleBand mmBottomOffset = 0 mmHeight = 12700 mmPrintPosition = 0 object ppLabel1: TppLabel UserName = 'Label1' Caption = 'Parts List By Type' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 16 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 6562 mmLeft = 1323 mmTop = 1323 mmWidth = 42714 BandType = 1 end object ppDBText9: TppDBText UserName = 'DBText9' AutoSize = True DataField = 'CompanyName' DataPipeline = dpCompanyInfo Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 16 Font.Style = [fsBold, fsItalic] ParentDataPipeline = False TextAlignment = taRightJustified Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 6562 mmLeft = 166603 mmTop = 1323 mmWidth = 35010 BandType = 1 end object ppLabel10: TppLabel UserName = 'Params' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 4149 mmLeft = 1323 mmTop = 8202 mmWidth = 12404 BandType = 1 end end object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 10319 mmPrintPosition = 0 object ppLine1: TppLine UserName = 'Line1' Pen.Color = clNavy Pen.Width = 2 Weight = 1.5 mmHeight = 794 mmLeft = 1323 mmTop = 8731 mmWidth = 200555 BandType = 0 end object ppLabel2: TppLabel UserName = 'Label2' AutoSize = False Caption = 'Type / Description' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 1323 mmTop = 2910 mmWidth = 50536 BandType = 0 end object ppLabel3: TppLabel UserName = 'Label3' AutoSize = False Caption = 'Number' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 54769 mmTop = 2910 mmWidth = 16404 BandType = 0 end object ppLabel4: TppLabel UserName = 'Label4' AutoSize = False Caption = 'Vendor No.' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 73819 mmTop = 2910 mmWidth = 21167 BandType = 0 end object ppLabel5: TppLabel UserName = 'Label5' AutoSize = False Caption = 'Vendor' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 95779 mmTop = 2910 mmWidth = 32544 BandType = 0 end object ppLabel6: TppLabel UserName = 'Label6' AutoSize = False Caption = 'Location' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 129117 mmTop = 2910 mmWidth = 16933 BandType = 0 end object ppLabel7: TppLabel UserName = 'Label7' AutoSize = False Caption = 'Shelf' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 147109 mmTop = 2910 mmWidth = 16404 BandType = 0 end object ppLabel8: TppLabel UserName = 'Label8' Caption = 'Qty On Hand' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4498 mmLeft = 180182 mmTop = 2910 mmWidth = 21696 BandType = 0 end object ppLabel9: TppLabel UserName = 'Label9' Caption = 'Min. Qty' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4498 mmLeft = 164307 mmTop = 2910 mmWidth = 14288 BandType = 0 end end object ppDetailBand1: TppDetailBand mmBottomOffset = 0 mmHeight = 4233 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' DataField = 'Description' DataPipeline = daADOQueryDataView1.Parts Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Parts' mmHeight = 3175 mmLeft = 3969 mmTop = 529 mmWidth = 50006 BandType = 4 end object ppDBText2: TppDBText UserName = 'DBText2' DataField = 'Numbered' DataPipeline = daADOQueryDataView1.Parts Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Parts' mmHeight = 3175 mmLeft = 54769 mmTop = 529 mmWidth = 17992 BandType = 4 end object ppDBText3: TppDBText UserName = 'DBText3' DataField = 'VendorNumber' DataPipeline = daADOQueryDataView1.Parts Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Parts' mmHeight = 3175 mmLeft = 73819 mmTop = 529 mmWidth = 19579 BandType = 4 end object ppDBText4: TppDBText UserName = 'DBText4' DataField = 'Vendor' DataPipeline = daADOQueryDataView1.Parts Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Parts' mmHeight = 3175 mmLeft = 95779 mmTop = 529 mmWidth = 32544 BandType = 4 end object ppDBText5: TppDBText UserName = 'DBText5' DataField = 'Location' DataPipeline = daADOQueryDataView1.Parts Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Parts' mmHeight = 3175 mmLeft = 129117 mmTop = 529 mmWidth = 16404 BandType = 4 end object ppDBText6: TppDBText UserName = 'DBText6' DataField = 'Shelf' DataPipeline = daADOQueryDataView1.Parts Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Parts' mmHeight = 3175 mmLeft = 147109 mmTop = 529 mmWidth = 16404 BandType = 4 end object ppDBText7: TppDBText UserName = 'DBText7' DataField = 'QuantityOnHand' DataPipeline = daADOQueryDataView1.Parts DisplayFormat = '#,0;-#,0' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Parts' mmHeight = 3260 mmLeft = 180711 mmTop = 529 mmWidth = 21167 BandType = 4 end object ppDBText8: TppDBText UserName = 'DBText8' DataField = 'MinimumOnHand' DataPipeline = daADOQueryDataView1.Parts DisplayFormat = '#,0;-#,0' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Parts' mmHeight = 3175 mmLeft = 164307 mmTop = 529 mmWidth = 14288 BandType = 4 end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 7144 mmPrintPosition = 0 object ppLine2: TppLine UserName = 'Line2' Pen.Color = clGray Pen.Width = 2 Weight = 1.5 mmHeight = 3969 mmLeft = 1323 mmTop = 5821 mmWidth = 200555 BandType = 8 end object ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' VarType = vtPrintDateTime Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 4487 mmLeft = 1323 mmTop = 1323 mmWidth = 17187 BandType = 8 end object ppSystemVariable2: TppSystemVariable UserName = 'SystemVariable2' VarType = vtPageNoDesc Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 4487 mmLeft = 184680 mmTop = 1323 mmWidth = 17187 BandType = 8 end end object ppSummaryBand1: TppSummaryBand mmBottomOffset = 0 mmHeight = 7673 mmPrintPosition = 0 object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' AutoSize = True DataField = 'Description' DataPipeline = daADOQueryDataView1.Parts DisplayFormat = 'Total Number of Records: #####0' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 10 Font.Style = [] Transparent = True DBCalcType = dcCount DataPipelineName = 'Parts' mmHeight = 4149 mmLeft = 1588 mmTop = 2646 mmWidth = 27347 BandType = 7 end end object ppGroup2: TppGroup BreakName = 'Type' DataPipeline = daADOQueryDataView1.Parts KeepTogether = True OutlineSettings.CreateNode = True UserName = 'Group2' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Parts' object ppGroupHeaderBand2: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 6615 mmPrintPosition = 0 object ppDBText10: TppDBText UserName = 'DBText10' AutoSize = True DataField = 'Type' DataPipeline = daADOQueryDataView1.Parts Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True DataPipelineName = 'Parts' mmHeight = 4530 mmLeft = 1323 mmTop = 1852 mmWidth = 12996 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand2: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 0 mmPrintPosition = 0 end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_Parts' Height = 296 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 303 AutoSearchTabOrder = 0 object Parts: TppChildDBPipeline AutoCreateFields = False UserName = 'Parts' object ppField1: TppField FieldAlias = 'Description' FieldName = 'Description' FieldLength = 60 DisplayWidth = 60 Position = 0 TableName = 'Parts' end object ppField2: TppField FieldAlias = 'Location' FieldName = 'Location' FieldLength = 25 DisplayWidth = 25 Position = 1 TableName = 'Parts' end object ppField3: TppField FieldAlias = 'Manufacturer' FieldName = 'Manufacturer' FieldLength = 50 DisplayWidth = 50 Position = 2 TableName = 'Parts' end object ppField4: TppField FieldAlias = 'Numbered' FieldName = 'Numbered' FieldLength = 50 DisplayWidth = 50 Position = 3 TableName = 'Parts' end object ppField5: TppField FieldAlias = 'QuantityOnHand' FieldName = 'QuantityOnHand' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 4 TableName = 'Parts' end object ppField6: TppField FieldAlias = 'MinimumOnHand' FieldName = 'MinimumOnHand' FieldLength = 5 DataType = dtDouble DisplayWidth = 5 Position = 5 TableName = 'Parts' end object ppField7: TppField FieldAlias = 'Shelf' FieldName = 'Shelf' FieldLength = 25 DisplayWidth = 25 Position = 6 TableName = 'Parts' end object ppField8: TppField FieldAlias = 'Site' FieldName = 'Site' FieldLength = 25 DisplayWidth = 25 Position = 7 TableName = 'Parts' end object ppField9: TppField FieldAlias = 'Status' FieldName = 'Status' FieldLength = 1 DisplayWidth = 1 Position = 8 TableName = 'Parts' end object ppField10: TppField FieldAlias = 'Type' FieldName = 'Type' FieldLength = 25 DisplayWidth = 25 Position = 9 TableName = 'Parts' end object ppField11: TppField FieldAlias = 'Vendor' FieldName = 'Vendor' FieldLength = 50 DisplayWidth = 50 Position = 10 TableName = 'Parts' end object ppField12: TppField FieldAlias = 'VendorNumber' FieldName = 'VendorNumber' FieldLength = 50 DisplayWidth = 50 Position = 11 TableName = 'Parts' end object ppField13: TppField FieldAlias = 'CategoryID' FieldName = 'CategoryID' FieldLength = 25 DisplayWidth = 25 Position = 12 TableName = 'Parts' end end object daSQL1: TdaSQL DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'Parts' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Parts.Description, Parts.Location, ' ' Parts.Manufacturer, Parts.Numbered, ' ' Parts.QuantityOnHand, Parts.MinimumOnHand, ' ' Parts.Shelf, Parts.Site, Parts.Status, ' ' Parts.Type, Parts.Vendor, ' ' Parts.VendorNumber, Parts.CategoryID' 'FROM Parts Parts' 'ORDER BY Parts.Type, Parts.Description, ' ' Parts.Numbered') SQLType = sqSQL2 object daField1: TdaField Alias = 'Description' DisplayWidth = 60 FieldAlias = 'Description' FieldLength = 60 FieldName = 'Description' SQLFieldName = 'Description' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField2: TdaField Alias = 'Location' DisplayWidth = 25 FieldAlias = 'Location' FieldLength = 25 FieldName = 'Location' SQLFieldName = 'Location' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField3: TdaField Alias = 'Manufacturer' DisplayWidth = 50 FieldAlias = 'Manufacturer' FieldLength = 50 FieldName = 'Manufacturer' SQLFieldName = 'Manufacturer' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField4: TdaField Alias = 'Numbered' DisplayWidth = 50 FieldAlias = 'Numbered' FieldLength = 50 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField5: TdaField Alias = 'QuantityOnHand' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'QuantityOnHand' FieldLength = 5 FieldName = 'QuantityOnHand' SQLFieldName = 'QuantityOnHand' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField6: TdaField Alias = 'MinimumOnHand' DataType = dtDouble DisplayWidth = 5 FieldAlias = 'MinimumOnHand' FieldLength = 5 FieldName = 'MinimumOnHand' SQLFieldName = 'MinimumOnHand' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField7: TdaField Alias = 'Shelf' DisplayWidth = 25 FieldAlias = 'Shelf' FieldLength = 25 FieldName = 'Shelf' SQLFieldName = 'Shelf' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField8: TdaField Alias = 'Site' DisplayWidth = 25 FieldAlias = 'Site' FieldLength = 25 FieldName = 'Site' SQLFieldName = 'Site' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField9: TdaField Alias = 'Status' DisplayWidth = 1 FieldAlias = 'Status' FieldLength = 1 FieldName = 'Status' SQLFieldName = 'Status' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField10: TdaField Alias = 'Type' DisplayWidth = 25 FieldAlias = 'Type' FieldLength = 25 FieldName = 'Type' SQLFieldName = 'Type' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField11: TdaField Alias = 'Vendor' DisplayWidth = 50 FieldAlias = 'Vendor' FieldLength = 50 FieldName = 'Vendor' SQLFieldName = 'Vendor' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField12: TdaField Alias = 'VendorNumber' DisplayWidth = 50 FieldAlias = 'VendorNumber' FieldLength = 50 FieldName = 'VendorNumber' SQLFieldName = 'VendorNumber' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField13: TdaField Alias = 'CategoryID' DisplayWidth = 25 FieldAlias = 'CategoryID' FieldLength = 25 FieldName = 'CategoryID' SQLFieldName = 'CategoryID' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField14: TdaField ChildType = 2 Alias = 'Type' DisplayWidth = 25 FieldAlias = 'Type' FieldLength = 25 FieldName = 'Type' SQLFieldName = 'Type' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField15: TdaField ChildType = 2 Alias = 'Description' DisplayWidth = 60 FieldAlias = 'Description' FieldLength = 60 FieldName = 'Description' SQLFieldName = 'Description' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daField16: TdaField ChildType = 2 Alias = 'Numbered' DisplayWidth = 50 FieldAlias = 'Numbered' FieldLength = 50 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'Parts' TableName = 'Parts' TableSQLAlias = 'Parts' end object daTable1: TdaTable ChildType = 5 Alias = 'Parts' JoinType = dajtNone SQLAlias = 'Parts' TableAlias = 'Parts' TableName = 'Parts' end end end end object ppParameterList1: TppParameterList end end