ReportName = Vendor Totals ReportGroup = Purchase Orders object ppReport1: TppReport AutoStop = False DataPipeline = daADOQueryDataView1.Porders NoDataBehaviors = [ndBlankReport] PrinterSetup.BinName = 'Default' PrinterSetup.DocumentName = 'Vendor Totals' PrinterSetup.PaperName = 'Letter' PrinterSetup.PrinterName = 'HP LaserJet 1022' 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 = 'Vendor Totals' Template.DatabaseSettings.NameField = 'ReportName' Template.DatabaseSettings.TemplateField = 'NewDef' Template.FileName = 'Vendor Totals.rtm' Template.SaveTo = stDatabase Template.Format = ftASCII AllowPrintToArchive = True AllowPrintToFile = True DeviceType = 'Screen' EmailSettings.ReportFormat = 'PDF' EmailSettings.Enabled = True EmailSettings.PreviewInEmailClient = False EmailSettings.ShowEmailDialog = True OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enabled = True OutlineSettings.Visible = True PreviewFormSettings.ZoomSetting = zs100Percent SavePrinterSetup = True ShowAutoSearchDialog = True TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = True Left = 218 Top = 155 Version = '10.07' mmColumnWidth = 0 DataPipelineName = 'Porders' object ppHeaderBand1: TppHeaderBand mmBottomOffset = 0 mmHeight = 27781 mmPrintPosition = 0 object ppLine3: TppLine UserName = 'Line3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Pen.Color = clNavy Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 1323 mmLeft = 1323 mmTop = 26458 mmWidth = 200555 BandType = 0 end object ppLabel2: TppLabel UserName = 'Label2' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Date' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] Transparent = True mmHeight = 4763 mmLeft = 23283 mmTop = 21696 mmWidth = 15610 BandType = 0 end object ppLabel3: TppLabel UserName = 'Label3' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'PO #' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4763 mmLeft = 1323 mmTop = 21696 mmWidth = 16404 BandType = 0 end object ppLabel4: TppLabel UserName = 'Label4' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Total' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4763 mmLeft = 45508 mmTop = 21696 mmWidth = 9525 BandType = 0 end object ppLabel7: TppLabel UserName = 'Label7' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Count' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 11 Font.Style = [fsBold, fsItalic] TextAlignment = taRightJustified Transparent = True mmHeight = 4763 mmLeft = 74613 mmTop = 21696 mmWidth = 9525 BandType = 0 end object ppDBText5: TppDBText UserName = 'DBText5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'CompanyName' DataPipeline = dpCompanyInfo Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 12 Font.Style = [] ParentDataPipeline = False TextAlignment = taCentered Transparent = True DataPipelineName = 'dpCompanyInfo' mmHeight = 5027 mmLeft = 2117 mmTop = 6615 mmWidth = 199496 BandType = 0 end object ppLabel1: TppLabel UserName = 'Label1' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Vendor Transactions' Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 14 Font.Style = [] TextAlignment = taCentered Transparent = True mmHeight = 5800 mmLeft = 2117 mmTop = 529 mmWidth = 199496 BandType = 0 end object ppLabel8: TppLabel UserName = 'params' AutoSize = False Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'DateOrdered: 2/28/2008- 2/28/2008' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 12 Font.Style = [] TextAlignment = taCentered Transparent = True mmHeight = 4995 mmLeft = 2117 mmTop = 11642 mmWidth = 199496 BandType = 0 end end object ppDetailBand1: TppDetailBand mmBottomOffset = 0 mmHeight = 6085 mmPrintPosition = 0 object ppDBText2: TppDBText UserName = 'DBText2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'DateOrdered' DataPipeline = daADOQueryDataView1.Porders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] Transparent = True DataPipelineName = 'Porders' mmHeight = 3260 mmLeft = 21167 mmTop = 529 mmWidth = 23019 BandType = 4 end object ppDBText3: TppDBText UserName = 'DBText3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Numbered' DataPipeline = daADOQueryDataView1.Porders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Porders' mmHeight = 3260 mmLeft = 1323 mmTop = 529 mmWidth = 18521 BandType = 4 end object ppDBText4: TppDBText UserName = 'DBText4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Total' DataPipeline = daADOQueryDataView1.Porders DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'ARIAL' Font.Size = 8 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Porders' mmHeight = 3260 mmLeft = 46038 mmTop = 529 mmWidth = 16933 BandType = 4 end end object ppFooterBand1: TppFooterBand mmBottomOffset = 0 mmHeight = 6350 mmPrintPosition = 0 object ppLine4: TppLine UserName = 'Line4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Pen.Color = clGray Pen.Width = 2 Weight = 1.500000000000000000 mmHeight = 3969 mmLeft = 1323 mmTop = 5027 mmWidth = 200555 BandType = 8 end object ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False VarType = vtPrintDateTime Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True mmHeight = 3725 mmLeft = 1323 mmTop = 1323 mmWidth = 31157 BandType = 8 end object ppSystemVariable2: TppSystemVariable UserName = 'SystemVariable2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False VarType = vtPageNoDesc Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3725 mmLeft = 193411 mmTop = 1323 mmWidth = 8594 BandType = 8 end end object ppSummaryBand1: TppSummaryBand mmBottomOffset = 0 mmHeight = 6085 mmPrintPosition = 0 object ppDBCalc2: TppDBCalc UserName = 'DBCalc2' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Total' DataPipeline = daADOQueryDataView1.Porders DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Porders' mmHeight = 3704 mmLeft = 45773 mmTop = 1588 mmWidth = 17198 BandType = 7 end object ppLine6: TppLine UserName = 'Line6' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 1323 mmLeft = 37306 mmTop = 1058 mmWidth = 25665 BandType = 7 end object ppLabel6: TppLabel UserName = 'Label6' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Grand Total' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3725 mmLeft = 12181 mmTop = 1588 mmWidth = 15409 BandType = 7 end object ppDBCalc4: TppDBCalc UserName = 'DBCalc4' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Numbered' DataPipeline = daADOQueryDataView1.Porders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True DBCalcType = dcCount DataPipelineName = 'Porders' mmHeight = 3704 mmLeft = 66940 mmTop = 1588 mmWidth = 17198 BandType = 7 end end object ppGroup1: TppGroup BreakName = 'VendorName' DataPipeline = daADOQueryDataView1.Porders OutlineSettings.CreateNode = True UserName = 'Group1' mmNewColumnThreshold = 0 mmNewPageThreshold = 0 DataPipelineName = 'Porders' object ppGroupHeaderBand1: TppGroupHeaderBand mmBottomOffset = 0 mmHeight = 6350 mmPrintPosition = 0 object ppDBText1: TppDBText UserName = 'DBText1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'VendorName' DataPipeline = daADOQueryDataView1.Porders Font.Charset = DEFAULT_CHARSET Font.Color = clNavy Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] Transparent = True DataPipelineName = 'Porders' mmHeight = 3704 mmLeft = 1323 mmTop = 529 mmWidth = 55827 BandType = 3 GroupNo = 0 end end object ppGroupFooterBand1: TppGroupFooterBand mmBottomOffset = 0 mmHeight = 7408 mmPrintPosition = 0 object ppLine5: TppLine UserName = 'Line5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Weight = 0.750000000000000000 mmHeight = 1323 mmLeft = 37306 mmTop = 1058 mmWidth = 25665 BandType = 5 GroupNo = 0 end object ppDBCalc1: TppDBCalc UserName = 'DBCalc1' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Total' DataPipeline = daADOQueryDataView1.Porders DisplayFormat = '$#,0.00;($#,0.00)' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DataPipelineName = 'Porders' mmHeight = 3704 mmLeft = 45773 mmTop = 2381 mmWidth = 17198 BandType = 5 GroupNo = 0 end object ppLabel5: TppLabel UserName = 'Label5' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False Caption = 'Vendor Total' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3725 mmLeft = 12340 mmTop = 2381 mmWidth = 17103 BandType = 5 GroupNo = 0 end object ppDBCalc3: TppDBCalc UserName = 'DBCalc3' Border.BorderPositions = [] Border.Color = clBlack Border.Style = psSolid Border.Visible = False DataField = 'Numbered' DataPipeline = daADOQueryDataView1.Porders Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'TIMES NEW ROMAN' Font.Size = 9 Font.Style = [] ResetGroup = ppGroup1 TextAlignment = taRightJustified Transparent = True DBCalcType = dcCount DataPipelineName = 'Porders' mmHeight = 3704 mmLeft = 66940 mmTop = 2117 mmWidth = 17198 BandType = 5 GroupNo = 0 end end end object daDataModule1: TdaDataModule object daADOQueryDataView1: TdaADOQueryDataView UserName = 'Query_Porders' Height = 160 Left = 10 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 10 TypeColumnWidth = 52 Width = 263 AutoSearchTabOrder = 0 object Porders: TppChildDBPipeline AutoCreateFields = False UserName = 'Porders' object ppField1: TppField FieldAlias = 'VendorName' FieldName = 'VendorName' FieldLength = 50 DisplayWidth = 10 Position = 0 TableName = 'Porders' end object ppField2: TppField FieldAlias = 'Numbered' FieldName = 'Numbered' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 1 TableName = 'Porders' end object ppField3: TppField FieldAlias = 'Total' FieldName = 'Total' FieldLength = 2 DataType = dtDouble DisplayWidth = 10 Position = 2 TableName = 'Porders' end object ppField4: TppField FieldAlias = 'DateOrdered' FieldName = 'DateOrdered' FieldLength = 0 DataType = dtDateTime DisplayWidth = 10 Position = 3 TableName = 'Porders' end end object daSQL1: TdaSQL GuidCollationType = gcMSSQLServer DatabaseName = 'ADO1' DatabaseType = dtMSSQLServer DataPipelineName = 'Porders' LinkColor = clMaroon MaxSQLFieldAliasLength = 25 SQLText.Strings = ( 'SELECT Porders.VendorName, Porders.Numbered, ' ' Porders.Total, Porders.DateOrdered' 'FROM Porders Porders' 'WHERE ('#39'c'#39' <> '#39'c'#39' )') SQLType = sqSQL2 object TdaCriteria ChildType = 7 Level = 0 Operator = dacoBetween Value = '2/28/2008," 2/28/2008"' object TdaField Alias = 'DateOrdered' AutoSearch = True DataType = dtDateTime DisplayWidth = 10 FieldAlias = 'DateOrdered' FieldLength = 10 FieldName = 'DateOrdered' SQLFieldName = 'DateOrdered' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object TdaNumericValue Value = 39506.000000000000000000 end object TdaNumericValue Value = 39506.000000000000000000 end end object daField1: TdaField Alias = 'VendorName' DisplayWidth = 10 FieldAlias = 'VendorName' FieldLength = 50 FieldName = 'VendorName' SQLFieldName = 'VendorName' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField2: TdaField Alias = 'Numbered' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Numbered' FieldLength = 0 FieldName = 'Numbered' SQLFieldName = 'Numbered' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField3: TdaField Alias = 'Total' DataType = dtDouble DisplayWidth = 10 FieldAlias = 'Total' FieldLength = 2 FieldName = 'Total' SQLFieldName = 'Total' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField4: TdaField Alias = 'DateOrdered' DataType = dtDateTime DisplayWidth = 10 FieldAlias = 'DateOrdered' FieldLength = 0 FieldName = 'DateOrdered' SQLFieldName = 'DateOrdered' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField5: TdaField ChildType = 2 Alias = 'VendorName' DisplayWidth = 10 FieldAlias = 'VendorName' FieldLength = 10 FieldName = 'VendorName' SQLFieldName = 'VendorName' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daField6: TdaField ChildType = 2 Alias = 'DateOrdered' DataType = dtDateTime DisplayWidth = 10 FieldAlias = 'DateOrdered' FieldLength = 10 FieldName = 'DateOrdered' SQLFieldName = 'DateOrdered' TableAlias = 'Porders' TableName = 'Porders' TableSQLAlias = 'Porders' end object daTable1: TdaTable ChildType = 5 Alias = 'Porders' JoinType = dajtNone SQLAlias = 'Porders' TableAlias = 'Porders' TableName = 'Porders' end end end end object ppParameterList1: TppParameterList end end